Rentals

rentalIDcustomerNamecarModelpickUpTimedropOffTimeRental_CarPick_up_Location
1John DoeTesla Model S2023-01-01 08:00:002023-01-02 17:00:00Audi A6Zone D
2Jane SmithFord Mustang2023-01-02 09:00:002023-01-03 18:00:00Chevrolet CamaroTerminal C
3Alice JohnsonHonda Accord2023-01-03 10:00:002023-01-04 19:00:00Volkswagen JettaGate E
4Bob BrownNissan Altima2023-01-04 11:00:002023-01-05 20:00:00Kia OptimaConcourse F
5Charlie WhiteSubaru Forester2023-01-05 12:00:002023-01-06 21:00:00Mazda CX-5Zone D

Shuttles

shuttleIDcustomerNamedestinationdepartureTimearrivalTimeAirport_ShuttlePick_up_Location
1Anna DavisNew York2023-01-01 07:00:002023-01-01 09:00:00NYC ExpressZone D
2Tom GreenLos Angeles2023-01-02 08:00:002023-01-02 10:00:00LA ConnectTerminal B
3Emma StoneParis2023-01-03 09:00:002023-01-03 11:00:00Eiffel AirGate G
4Leonardo DiCaprioTokyo2023-01-04 10:00:002023-01-04 12:00:00Japan JourneyConcourse H
5Scarlett JohanssonLondon2023-01-05 11:00:002023-01-05 13:00:00British CharterZone D

Passengers

passengerIDnameagenationality
1David Beckham39English
2Victoria Beckham45English
3Brooklyn Beckham23English
4Romeo Beckham20English
5Cruz Beckham17English

Flights

flightIDairlineorigindestinationdepartureTimearrivalTime
1United AirlinesSan Francisco2023-01-01 05:00:002023-01-01 07:00:00UA123
2Delta AirlinesAtlanta2023-01-02 06:00:002023-01-02 08:00:00DL543
3Southwest AirlinesLas Vegas2023-01-03 07:00:002023-01-03 09:00:00WN789
4American AirlinesDallas2023-01-04 08:00:002023-01-04 10:00:00AA345
5Spirit AirlinesOrlando2023-01-05 09:00:002023-01-05 11:00:00NK126

Baggage

baggageIDpassengerIDweighttype
(→ Passengers.passengerID)
1130Checked Luggage
2115Carry-On Bag
3220Checked Luggage
4210Carry-On Bag
5325Checked Luggage