택시 서비스 설계하기

테이블 (5)

결제 (payments)

  • Payment (idx) — INT — 기본 키 — NOT NULL
  • Price (price) — INT
  • Category (category) — VARCHAR(30)
  • State (state) — VARCHAR(30)
  • Operation (operation_id) — INT — 외래 키 → 운행.Operation — NOT NULL

기사 (drivers)

  • Driver (idx) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(30)
  • Phone (phone) — VARCHAR(30)
  • License (license) — VARCHAR(30)
  • State (state) — VARCHAR(30)
  • Rating (rating) — NUMERIC
  • Operation (operation_id) — INT — 외래 키 → 운행.Operation — NOT NULL

승객 (passengers)

  • Passenger (idx) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(30)
  • Phone (phone) — VARCHAR(30)
  • Rating (rating) — NUMERIC
  • Operation (operation_id) — INT — 외래 키 → 운행.Operation — NOT NULL

운행 (Untitled4)

  • Operation (idx) — INT — 기본 키 — NOT NULL
  • Price (price) — INT
  • Distance (distance) — NUMERIC
  • Customer_rating (customer_rating) — NUMERIC
  • Driver_rating (driver_rating) — NUMERIC
  • Passenger (passenger_id) — INT — 외래 키 → 승객.Passenger — NOT NULL
  • Car (car_id) — INT — 외래 키 → 차량.Car — NOT NULL
  • Driver (driver_id) — INT — 외래 키 → 차량.Driver — NOT NULL

차량 (cars)

  • Car (idx) — INT — 기본 키 — NOT NULL
  • Driver (driver_id) — INT — 외래 키 → 기사.Driver — NOT NULL
  • Plate (plate) — VARCHAR(30)
  • Type (type) — VARCHAR(30)
  • State (state) — VARCHAR(30)