How would you design DynamoDB partition and sort keys?

Question

Design the DynamoDB table layout for the rider onboarding system: choose partition keys and sort keys for each table.

Discussion points

• Index types and when to use each (LSI vs GSI)
• Choosing partition keys that avoid hot partitions
• Sort key design for range queries and access patterns
• Modeling each table around its query patterns