Flights

FlightIDOriginDestinationDepartureTimeArrivalTime
1JFKLAX2023-01-01 10:00:002023-01-01 17:00:00
2ORDDFW2023-01-02 11:00:002023-01-02 18:00:00
3SEASFO2023-01-03 12:00:002023-01-03 19:00:00

Passengers

PassengerIDFirstNameLastNameDateOfBirthNationality
1JohnDoe1990-01-01US
2JaneSmith1985-06-15UK
3AliceJohnson1992-12-20CA
4MichaelWilliams1988-03-03AU
5EmilyBrown1995-07-12FR

Luggage

ItemIDPassengerIDDescriptionFees
(→ Passengers.PassengerID)
11Cabin Baggage$25
22Checked Baggage$30
33Checked Baggage$25
44Cabin Baggage€35
55Checked Baggage$30

Aircrafts

AircraftIDModelCapacityRegistrationNumber
1Boeing 737200N12345
2Airbus A320180N67890
3Embraer E190100N23456

Assignments

AssignmentIDFlightIDAircraftIDAssignedDateReturnedDate
(→ Flights.FlightID)(→ Aircrafts.AircraftID)
1112023-01-012023-01-02
2222023-01-022023-01-03
3332023-01-032023-01-04

CheckIns

CheckInIDFlightIDPassengerIDCheckInDateTimeBoardingGateSeat
(→ Flights.FlightID)(→ Passengers.PassengerID)
1112023-01-01 09:00:00Gates C1-C1012A
2222023-01-02 10:00:00Gates D1-D2023B
3332023-01-03 11:00:00Gates E1-E1034A
4142023-01-01 09:30:00Gates C1-C10None
5252023-01-02 10:30:00Gates D1-D20None