1019_hw

Tables (4)

category (Untitled4)

  • Key (category_id) — int — Primary key — NOT NULL
  • Field (name) — text

cvs (Untitled2)

  • Key (cvs_id) — int — Primary key — NOT NULL
  • Field (name) — text
  • Field (region) — text

display (Untitled5)

  • Key (display_id) — int — Primary key — NOT NULL
  • Key (cvs_id) — int — Foreign key → cvs.Key — NOT NULL
  • Key (merchandise_id) — int — Foreign key → merchandise.Key — NOT NULL

merchandise (Untitled3)

  • Key (merchandise_id) — int — Primary key — NOT NULL
  • Field (name) — text
  • Key (category_id) — int — Foreign key → category.Key — NOT NULL