중급3
테이블 (7)
driver_vehicles
- driver_idx — INT — 외래 키 → 기사.driver_idx — NOT NULL
- vehicle_idx — INT — 외래 키 → 차량.vehicle_idx — NOT NULL
결제 (payments)
- payment_idx — INT — 기본 키 — NOT NULL
- payment_id — VARCHAR(50) — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- method — ENUM('card','cash','mobile','points') — NOT NULL
- payment_date — DATETIME
- status — ENUM('pending','completed','failed','refunded')
- created_at — DATETIME
- updated_at — DATETIME
- ride_idx — INT — 외래 키 → 운행.ride_idx — NOT NULL
기사 (drivers)
- driver_idx — INT — 기본 키 — NOT NULL
- driver_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- license_no — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
승객 (passengers)
- passenger_idx — INT — 기본 키 — NOT NULL
- passenger_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
운행 (rides)
- ride_idx — INT — 기본 키 — NOT NULL
- ride_id — VARCHAR(50) — NOT NULL
- start_location — VARCHAR(200) — NOT NULL
- end_location — VARCHAR(200) — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
- status — ENUM('requested','assigned','in_progress','completed','cancelled')
- fare_amount — DECIMAL(10,2)
- created_at — DATETIME
- updated_at — DATETIME
- passenger_idx — INT — 외래 키 → 승객.passenger_idx — NOT NULL
- driver_idx — INT — 외래 키 → driver_vehicles.driver_idx — NOT NULL
- vehicle_idx — INT — 외래 키 → driver_vehicles.vehicle_idx — NOT NULL
차량 (vehicles)
- vehicle_idx — INT — 기본 키 — NOT NULL
- vehicle_id — VARCHAR(50) — NOT NULL
- license_plate — VARCHAR(20) — NOT NULL
- model — VARCHAR(100) — NOT NULL
- capacity — INT
- created_at — DATETIME
- updated_at — DATETIME
평점 (ratings)
- rating_idx — INT — 기본 키 — NOT NULL
- from_type — ENUM('driver','passenger') — NOT NULL
- from_idx — INT — NOT NULL
- to_type — ENUM('driver','passenger') — NOT NULL
- to_idx — INT — NOT NULL
- score — INT — NOT NULL
- comment — TEXT — EX
- created_at — DATETIME
- updated_at — DATETIME
- ride_idx — INT — 외래 키 → 운행.ride_idx — NOT NULL