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