product

Tables (3)

allproduct

  • product_id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • category_id — INT
  • series_id — INT
  • start_date — DATE
  • end_date — DATE

categoryproduct

  • category_id — INT — Primary key — NOT NULL
  • name — VARCHAR

seriesproduct

  • series_id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • product_id — NUMBER — Foreign key → allproduct.product_id — NOT NULL