E-commerce Schema (ER)

Customers, orders, products, and line items as an ER diagram.

MermaidData & Schema Mermaid syntax docs

Template previewMermaid

Rendering…

Make it your own.

erDiagram
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE_ITEM : contains
    PRODUCT ||--o{ LINE_ITEM : "ordered in"
    CUSTOMER {
      uuid id PK
      string email
      string name
    }
    ORDER {
      uuid id PK
      uuid customer_id FK
      datetime created_at
      string status
    }
    PRODUCT {
      uuid id PK
      string title
      decimal price
    }
    LINE_ITEM {
      uuid id PK
      uuid order_id FK
      uuid product_id FK
      int quantity
    }