데카트론
테이블 (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