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