Entity Relationship Diagrams

ER diagrams model database schemas.

erDiagram
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE_ITEM : contains
    PRODUCT ||--o{ LINE_ITEM : "ordered in"

    CUSTOMER {
        int id PK
        string name
        string email
        string phone
    }
    ORDER {
        int id PK
        date order_date
        string status
        int customer_id FK
    }
    LINE_ITEM {
        int id PK
        int quantity
        float price
        int order_id FK
        int product_id FK
    }
    PRODUCT {
        int id PK
        string name
        float price
        int stock
    }

Back to overview.