중급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