hpick
Tables (4)
Category (카테고리)
- Category (Key) — VARCHAR(32) — Primary key — NOT NULL
- Category_group_code (Field1) — VARCHAR(32)
Cluster (클러스터우선순위)
- Iswork (Field) — VARCHAR(4)
- Category (Field2) — VARCHAR(32) — Foreign key → Category.Category — NOT NULL
- Cluster0 (Field3) — FLOAT
- Cluster1 (Field4) — FLOAT
- Cluster2 (Field5) — FLOAT
- Cluster3 (Field6) — FLOAT
Stores (제휴처)
- Category_group_code (Field) — VARCHAR(32)
- Category_group_name (Field2) — VARCHAR(32)
- Category (Field3) — VARCHAR(32) — Foreign key → Category.Category — NOT NULL
- Category_name (Field4) — VARCHAR(128)
- Event_info (Field5) — VARCHAR(128)
Timeline (시간대우선순위)
- Iswork (Field) — VARCHAR(4)
- Category (Field1) — VARCHAR(32) — Foreign key → Category.Category — NOT NULL
- Dawn (Field2) — FLOAT
- Morning (Field3) — FLOAT
- Lunch (Field4) — FLOAT
- Evening (Field5) — FLOAT
- Night (Field6) — FLOAT