데카트론

테이블 (3)

고객 (Customers)

  • customer_id (PRIMARY KEY) — INT — 기본 키 — NOT NULL
  • purchase_state (Field) — BOOLEAN
  • path_history (Field2) — TEXT

구역 (Zones)

  • zone_id (PRIMARY KEY) — INT — 기본 키 — NOT NULL
  • zone_name (Field) — VARCHAR(50)

체류시간 (ZoneStayTimes)

  • stay_id (PRIMARY KEY) — INT — 기본 키 — NOT NULL
  • customer_id (FOREIGN KEY) — INT — 외래 키 → 고객.customer_id — NOT NULL
  • zone_id (FOREIGN KEY2) — INT — 외래 키 → 구역.zone_id — NOT NULL
  • stay_time_seconds (Field2) — INT
  • log_date (Field3) — DATE
  • visited_at (Field4) — DATETIME
  • left_at (Field5) — DATETIME