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