Free
6,125 uses
Design an optimized database schema for your application.
Prompt
Design a normalized database schema for a [application type] application using [PostgreSQL/MySQL/MongoDB]. Core entities: [entity 1], [entity 2], [entity 3], [entity 4]. Requirements: [key requirements]. Create: entity-relationship description, table definitions with column names, data types, constraints, and indexes, foreign key relationships, junction tables for many-to-many relationships, and 5 common query examples with SQL. Also identify which fields need indexing for performance and why.
Paste directly into ChatGPT · Replace text in [brackets] with your own info
Enter your topic — AI fills the prompt and shows a live sample
See what others created with this prompt
No results yet — be the first to share!