Product Catalog Database Schema

erDiagram
  CATEGORY ||--o{ CATEGORY : "parent of"
  CATEGORY ||--o{ PRODUCT : contains
  BRAND ||--o{ PRODUCT : makes
  PRODUCT ||--|{ PRODUCT_VARIANT : "sold as"
  PRODUCT ||--o{ PRODUCT_IMAGE : shows
  PRODUCT_VARIANT ||--|| PRICE : "priced at"
  PRODUCT_VARIANT ||--o{ INVENTORY : stocked
  WAREHOUSE ||--o{ INVENTORY : holds
  PRODUCT {
    int id PK
    int category_id FK
    int brand_id FK
    string title
  }
  PRODUCT_VARIANT {
    int id PK
    int product_id FK
    string sku
    string size
    string colour
  }
  PRICE {
    int variant_id FK
    decimal mrp
    decimal sale_price
  }
  INVENTORY {
    int variant_id FK
    int warehouse_id FK
    int quantity
  }