Database Schema Architect

Design a database schema optimized for these access patterns:

**Domain**: {{domain}}
**Primary access patterns** (ordered by frequency):
{{accessPatterns}}

**Database type**: {{dbType}} (PostgreSQL/MongoDB/DynamoDB/Redis)
**Expected data volume**: {{volume}}
**Read/write ratio**: {{ratio}}

Provide:
1. **Schema design**: tables/collections with all fields, types, and constraints
2. **Access pattern mapping**: how each query maps to the schema (include query plans)
3. **Indexing strategy**: which indexes support which queries, composite index ordering
4. **Denormalization decisions**: what is denormalized and why (with consistency tradeoffs)
5. **Partitioning/sharding**: strategy based on data volume and access patterns
6. **Caching layer**: what to cache, TTLs, invalidation strategy
7. **Migration path**: how to evolve the schema as requirements change

For each design decision, explain the tradeoff (consistency vs. performance, storage vs. speed).