rusty-mermaid Gallery

erDiagram
    PRODUCT {
        int productId PK "Auto-incremented"
        string name
        float price
        string category FK
        string sku UK "Stock keeping unit"
        int quantity
        boolean active
    }

erDiagram
    CUSTOMER {
        int customerId PK
        string name
        string email UK
    }
    ORDER {
        int orderId PK
        date orderDate
        string status
    }
    CUSTOMER ||--o{ ORDER : places

erDiagram
    A ||--|| B : "exactly one to one"
    C ||--o{ D : "one to zero or more"
    E ||--|{ F : "one to one or more"
    G o|--|| H : "zero or one to one"

erDiagram
    CUSTOMER {
        int id PK
        string firstName
        string lastName
        string email UK
    }
    ORDER {
        int id PK
        date orderDate
        string status
        int customerId FK
    }
    LINE-ITEM {
        int id PK
        int orderId FK
        int productId FK
        int quantity
        float unitPrice
    }
    PRODUCT {
        int id PK
        string name
        string description
        float price
        int categoryId FK
    }
    CATEGORY {
        int id PK
        string name
    }
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE-ITEM : contains
    PRODUCT ||--o{ LINE-ITEM : "appears in"
    CATEGORY ||--o{ PRODUCT : groups

erDiagram
    direction LR
    USER {
        int id PK
        string name
    }
    PROFILE {
        int id PK
        string bio
        int userId FK
    }
    USER ||--|| PROFILE : has

erDiagram
    PERSON {
        int id PK
        string name
    }
    ADDRESS {
        int id PK
        string street
        string city
    }
    PERSON }|..|{ ADDRESS : "lives at"