카풀

테이블 (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