카풀
테이블 (3)
BOOKING
- booking_id — INT — 기본 키
- ride_id (ride_id2) — INT — 외래 키 → RIDE.ride_id
- passenger_id — INT — NOT NULL
- status — ENUM('pending', 'confirmed', 'cancelled')
- user_id — INT — 외래 키 → USER.user_id
RIDE
- ride_id — INT — 기본 키
- driver_id — INT — NOT NULL
- departure_location — VARCHAR(255) — NOT NULL
- arrival_location — VARCHAR(255) — NOT NULL
- departure_time — DATETIME — NOT NULL
- available_seats — INT — NOT NULL
- user_id — INT — 외래 키 → USER.user_id
USER
- user_id — INT — 기본 키
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- user_type — ENUM('driver', 'passenger') — NOT NULL