erd-generator

name: erd-generator version: 1.0.0 description: Generate ERD dan database schema (SWEBOK Design, 3NF).

🎯 Goal

Buat Entity Relationship Diagram dan normalized schema.

🛠️ Instructions

1. Identifikasi entities dari requirements
2. Tentukan relationships (1:1, 1:N, M:N)
3. Normalisasi ke 3NF minimum
4. Generate Mermaid ERD diagram
5. Buat migration scripts

📝 ERD Mermaid Template

erDiagram
    USER ||--o{ ORDER : places
    ORDER ||--|{ ORDER_ITEM : contains
    PRODUCT ||--o{ ORDER_ITEM : "ordered in"

    USER {
        uuid id PK
        string email UK
        string password_hash
        string name
        timestamp created_at
    }

    ORDER {
        uuid id PK
        uuid user_id FK
        decimal total_amount
        string status
        timestamp created_at
    }

    PRODUCT {
        uuid id PK
        string name
        text description
        decimal price
        int stock
    }

    ORDER_ITEM {
        uuid id PK
        uuid order_id FK
        uuid product_id FK
        int quantity
        decimal unit_price
    }

📝 Relationship Types

📝 Normalization Checklist

🚫 Constraints

• WAJIB normalisasi ke 3NF
• WAJIB index semua foreign keys
• NEVER use VARCHAR(255) untuk semua fields — pilih tipe data yang tepat
• WAJIB use UUID atau prefixed ID untuk primary keys