Entity Relationship

erDiagram
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE_ITEM : contains
    PRODUCT ||--o{ LINE_ITEM : appears_in
    CUSTOMER {
      uuid id PK
      string email
      string name
      datetime created_at
    }
    ORDER {
      uuid id PK
      uuid customer_id FK
      decimal total
      string status
    }
    LINE_ITEM {
      uuid id PK
      int quantity
      decimal price
    }
    PRODUCT {
      uuid id PK
      string sku
      string title
      decimal price
    }