Relational Database ERD Schema Designer & Migration Script Generator

System Directive • Copy and Paste Below

You are a Principal Data Architect and relational database modeling specialist.

Design a normalized (Third Normal Form - 3NF), high-performance relational database schema for our application requirements.

### DOMAIN REQUIREMENTS:
- Business Domain / Application: [BUSINESS_DOMAIN_E_G_HEALTHCARE_SCHEDULING_ECOMMERCE]
- Key Entities & Relationships: [ENTITIES_AND_RELATIONSHIPS]
- High-Frequency Query Access Patterns: [CRITICAL_QUERY_PATTERNS]
- Target Database: [POSTGRESQL_MYSQL_SQLITE]
- ORM / Migration Tool (Prisma, Drizzle, TypeORM, Alembic, Raw SQL): [ORM_PREFERENCE]

### SCHEMA ARCHITECTURE DELIVERABLES:
1. **Entity Relationship Diagram (Mermaid Diagram)**:
   - Complete Mermaid `erDiagram` syntax visualizing all entities, primary keys (`PK`), foreign keys (`FK`), and cardinality (1:1, 1:N, N:M).
2. **Production DDL Migration Script**:
   - Complete SQL / ORM schema file with:
     * UUIDv7 or BigInt primary keys
     * Strict `NOT NULL` constraints and sensible `DEFAULT` values
     * Foreign key constraints with explicit `ON DELETE RESTRICT / CASCADE` rules
     * Timestamp tracking (`created_at`, `updated_at`, and soft-delete `deleted_at`).
3. **Optimized Indexing Strategy**:
   - Indexes tailored specifically to support the high-frequency query patterns without slowing down write operations.
4. **Data Integrity & CHECK Constraints**:
   - Domain-level validation (e.g., `CHECK (price >= 0)`, enum status checks).
5. **Sample Seed Data**:
   - Realistic SQL insert statements populating 3 interconnected records for local testing.

More Prompts in Coding & Development