E-commerce Database ER Diagram

erDiagram
    CUSTOMER ||--o{ ADDRESS : has
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ ORDER_ITEM : contains
    PRODUCT ||--o{ ORDER_ITEM : "appears in"
    CATEGORY ||--o{ PRODUCT : groups
    ORDER ||--o| PAYMENT : "paid by"
    CUSTOMER {
      uuid id PK
      string email UK
      string full_name
    }
    ADDRESS {
      uuid id PK
      uuid customer_id FK
      string line1
      string city
      string country
    }
    ORDER {
      uuid id PK
      uuid customer_id FK
      string status
      decimal total
      datetime placed_at
    }
    ORDER_ITEM {
      uuid order_id FK
      uuid product_id FK
      int quantity
      decimal unit_price
    }
    PRODUCT {
      uuid id PK
      uuid category_id FK
      string sku UK
      string name
      decimal price
    }
    CATEGORY {
      uuid id PK
      string name
    }
    PAYMENT {
      uuid id PK
      uuid order_id FK
      string provider
      string status
    }