routie
Tables (4)
places
- id — BIGINT — Primary key
- name — VARCHAR(30) — NOT NULL
- address — VARCHAR(50) — NOT NULL
- stay_duration — INT — 체류시간(분)
- business_start_time — TIME
- business_end_time — TIME
- break_start_time — TIME
- break_end_time — TIME
- closed_days — DATETIME — 휴무일 배열 ex) "월", "화"
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- routie_space_id — BIGINT — Foreign key → routie_spaces.id
routie_places
- id — BIGINT — Primary key
- sequence — INT — NOT NULL — 방문 순서 (중간 삽입 최적화)
- created_at — TIMESTAMP
- routie_id — BIGINT — Foreign key → routies.id
- place_id — BIGINT — Foreign key → places.id
routie_spaces
- id — BIGINT — Primary key
- name — VARCHAR(50) — NOT NULL
- identifier — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
routies
- id — BIGINT — Primary key
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- routie_space_id — BIGINT — Foreign key → routie_spaces.id