리얼찐

테이블 (5)

fare_policy

  • fare_id — BIGINT — 기본 키 — NOT NULL
  • min_distance_km — DECIMAL(5,2) — NOT NULL
  • max_distance_km — DECIMAL(5,2) — NOT NULL
  • base_fare — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

line

  • line_id — BIGINT — 기본 키 — NOT NULL
  • line_name — VARCHAR(20) — NOT NULL
  • line_color — VARCHAR(10)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

station

  • station_id — BIGINT — 기본 키 — NOT NULL
  • line_id — BIGINT — 외래 키 → line.line_id — NOT NULL
  • station_name — VARCHAR(50) — NOT NULL
  • station_code — VARCHAR(20)
  • sequence — INT — NOT NULL
  • is_transfer — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

station_section

  • section_id — BIGINT — 기본 키 — NOT NULL
  • from_station_id — BIGINT — 외래 키 → station.station_id — NOT NULL
  • to_station_id — BIGINT — 외래 키 → station.station_id — NOT NULL
  • direction — VARCHAR(10) — NOT NULL
  • duration_seconds — INT — NOT NULL
  • distance_km — DECIMAL(5,2) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

transfer_info

  • transfer_id — BIGINT — 기본 키 — NOT NULL
  • from_station_id — BIGINT — 외래 키 → station.station_id — NOT NULL
  • to_station_id — BIGINT — 외래 키 → station.station_id — NOT NULL
  • transfer_time_sec — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL