Online Shopping System ER Diagram

erDiagram
  CUSTOMER ||--o{ ADDRESS : has
  CUSTOMER ||--|| CART : owns
  CART ||--o{ CART_ITEM : contains
  PRODUCT ||--o{ CART_ITEM : "added as"
  CATEGORY ||--o{ PRODUCT : groups
  SELLER ||--o{ PRODUCT : sells
  CUSTOMER ||--o{ ORDERS : places
  ADDRESS ||--o{ ORDERS : "delivered to"
  ORDERS ||--|{ ORDER_ITEM : contains
  PRODUCT ||--o{ ORDER_ITEM : "ordered as"
  ORDERS ||--o| PAYMENT : "paid by"
  CUSTOMER ||--o{ REVIEW : writes
  PRODUCT ||--o{ REVIEW : receives
  CUSTOMER {
    int customer_id PK
    string name
    string email
  }
  ADDRESS {
    int address_id PK
    int customer_id FK
    string city
    string pincode
  }
  SELLER {
    int seller_id PK
    string name
    string gstin
  }
  CATEGORY {
    int category_id PK
    string name
  }
  PRODUCT {
    int product_id PK
    int category_id FK
    int seller_id FK
    string name
    decimal price
    int stock
  }
  CART {
    int cart_id PK
    int customer_id FK
  }
  CART_ITEM {
    int cart_id FK
    int product_id FK
    int quantity
  }
  ORDERS {
    int order_id PK
    int customer_id FK
    int address_id FK
    date ordered_on
    string status
  }
  ORDER_ITEM {
    int order_id FK
    int product_id FK
    int quantity
    decimal unit_price
  }
  PAYMENT {
    int payment_id PK
    int order_id FK
    decimal amount
    string method
  }
  REVIEW {
    int review_id PK
    int customer_id FK
    int product_id FK
    int rating
  }