졸업시험

테이블 (4)

Autonomous Vehicle (Untitled2)

  • VehicleID (Key) — 기본 키 — NOT NULL
  • Model (Field)
  • BetteryLevel (Field2)
  • ChargingStatus (Field3)

Ride (Untitled4)

  • RideID (Key) — 기본 키 — NOT NULL
  • TripID (Key2) — 외래 키 → Trip.TripID — NOT NULL
  • PassengerID (Key22) — 외래 키 → Trip.UserID — NOT NULL

Trip (Untitled3)

  • TripID (Key) — 기본 키 — NOT NULL
  • UserID (Key2) — 외래 키 → User.UserID — NOT NULL
  • VehicleID (Key3) — 외래 키 → Autonomous Vehicle.VehicleID — NOT NULL
  • PickupLocation (Field2)
  • Destination (Field3)

User (Untitled)

  • UserID (Key) — 기본 키 — NOT NULL
  • Name (Field2)
  • Phone (Field3)
  • Email (Field4)