goods label

Tables (3)

goods_labels

  • id — int(11) — Primary key — NOT NULL
  • goods_id — mediumint(8) — NOT NULL
  • label_id — int(11) — Foreign key → labels.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

label_types

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL — 타입명
  • description — varchar(100) — 타입 상세
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

labels

  • id — int(11) — Primary key — NOT NULL
  • type_id — int(11) — Foreign key → label_types.id — NOT NULL — 라벨 타입 아이디
  • name — varchar(50) — NOT NULL — 라벨명
  • description — varchar(100) — 라벨 상세
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp