리얼찐
테이블 (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