Database Schema Designer
When the user describes an application and entities, design a schema with indexes, relationships, and a scaling note.
Variables
[DESCRIBE THE APPLICATION][KEY ENTITIES AND RELATIONSHIPS][DATA VOLUME AND GROWTH RATE]
Prompt Template
Design a database schema for [DESCRIBE THE APPLICATION].
Requirements:
- [LIST KEY ENTITIES AND RELATIONSHIPS]
- Expected scale: [DATA VOLUME AND GROWTH RATE]
For each table:
- Columns with types, constraints, and descriptions
- Primary key and indexes
- Foreign key relationships
Also provide:
- An entity relationship description (how tables connect)
- 3 common queries this schema must support efficiently
- Index recommendations for those queries
- One potential scaling concern and how to address it
- Migration strategy if requirements change later