testdb2
Tables (4)
categories
- category_id — INT(10) — Primary key — NOT NULL
- category_name — VARCHAR(45) — NOT NULL
colors
- color_id — INT(10) — Primary key — NOT NULL
- color_name — VARCHAR(45) — NOT NULL
product
- product_id — INT(10) — Primary key — NOT NULL
- product_specid — INT(10) — Foreign key → product_spec.product_specid — NOT NULL
- product_name — VARCHAR(45) — NOT NULL
- memo — VARCHAR(45) — NOT NULL
- INDEX — `product_idx1`
- INDEX — `fk_product_product_spec_idx`
product_spec
- product_specid — INT(10) — Primary key — NOT NULL
- color_id — INT(10) — Foreign key → colors.color_id — NOT NULL
- category_id — INT(10) — Foreign key → categories.category_id — NOT NULL
- INDEX — `fk_product_spec_colors1_idx`
- INDEX — `fk_product_spec_categories1_idx`