SD ERD

Tables (3)

PRODUCT (Untitled)

  • product_id (Key) — Primary key — NOT NULL
  • barcode (unique)
  • product_name (Field2)
  • category_id (Field3)
  • price (Field4)
  • cost_price (Field5)
  • expire_date (Field6)
  • stock_qty (Field7)

PRODUCT_CATEGORY (Untitled2)

  • category_id (Key) — Primary key — NOT NULL
  • Field

SALES_DETAIL (Untitled3)

  • Key — Primary key — NOT NULL