택시 서비스 설계하기
테이블 (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)