Terminals

idLocation
1Terminal 1
2Terminal 2
3Terminal 3
4Terminal 4
5Terminal 5

Flights

FlightIDDepartureTimeArrivalTimeDestinationGateNumberTerminalId
(→ Terminals.id)
12023-01-01 10:002023-01-01 11:30New York61
22023-01-02 12:002023-01-02 14:30Los Angeles82
32023-01-03 13:002023-01-03 17:30Chicago93
42023-01-04 14:002023-01-04 19:30Miami104
52023-01-05 15:002023-01-05 20:30Honolulu115

SecurityChecks

IdTimeStampFlightIdResult
(→ Flights.FlightID)
12023-01-01 09:0011
22023-01-02 11:0021
32023-01-03 12:0031
42023-01-04 14:0040
52023-01-05 15:0051

BaggageClaims

IdTimeStampFlightIdStatus
(→ Flights.FlightID)
12023-01-01 13:001Closed
22023-01-02 15:002Open
32023-01-03 16:003Closed
42023-01-04 18:004Open
52023-01-05 19:005Closed