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`