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