Database schema designer from business requirements
Views
8.3K
Copies
2.5K
Likes
1.7K
Comments
0
Copy rate
30.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