pro

Tables (7)

Untitled (color)

  • Key (color_id) — INT — Primary key — NOT NULL
  • Field (name) — VAR

category

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

color (likenum)

  • color_id (likenum_id) — INT — Primary key — NOT NULL
  • name (range)

company

  • company_id — INT — Primary key — NOT NULL
  • name — VAR

item (post)

  • item_id (post_id) — INT — Primary key — NOT NULL
  • company_id — INT — Foreign key → company.company_id — NOT NULL
  • likenum_id (item_id) — INT — Foreign key → likenum.likenum_id — NOT NULL
  • color_id (likenum_id) — INT — Foreign key → color.color_id — NOT NULL
  • Key (color_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • subcategory_id — INT — Foreign key → subcategory.subcategory_id — NOT NULL
  • name — VAR
  • Field (url) — VAR

likenum (item)

  • likenum_id (item_id) — INT — Primary key — NOT NULL
  • range (name) — VAR

subcategory

  • subcategory_id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → category.category_id — NOT NULL
  • name — VAR