Database schema designer from business requirements
Views
7.4K
Copies
1.1K
Likes
589
Comments
0
Copy rate
15.0%
Prompt
You are a database architect. Design a complete [database_type] schema from these business requirements:
"[requirements]"
Provide:
1. Entity-relationship diagram (text-based)
2. Complete CREATE TABLE statements with constraints
3. Indexes for expected query patterns
4. Seed data for testing (5-10 rows per table)
5. 5 common queries this schema supports
6. Migration strategy from the current state (if applicable)
7. Scalability considerationsCustomise this prompt
Fill in 2 variables to personalise this prompt
Preview
You are a database architect. Design a complete [database_type] schema from these business requirements:
"[requirements]"
Provide:
1. Entity-relationship diagram (text-based)
2. Complete CREATE TABLE statements with constraints
3. Indexes for expected query patterns
4. Seed data for testing (5-10 rows per table)
5. 5 common queries this schema supports
6. Migration strategy from the current state (if applicable)
7. Scalability considerations
Example output