Terminals
ID | Name |
1 | Terminal 1 |
2 | Terminal 2 |
3 | Terminal 3 |
Airlines
ID | Name |
1 | American Airlines |
2 | Delta Airlines |
3 | United Airlines |
Flights
FlightID | AirlineID | DepartureTime | ArrivalTime | BoardingGate |
| (→ Airlines.ID) | | | |
101 | 1 | 2023-01-01 08:00 | 2023-01-01 10:00 | 1 |
102 | 2 | 2023-01-01 09:00 | 2023-01-01 11:00 | 2 |
103 | 3 | 2023-01-01 10:00 | 2023-01-01 12:00 | 3 |
104 | 1 | 2023-01-01 11:00 | 2023-01-01 13:00 | 4 |
105 | 2 | 2023-01-01 12:00 | 2023-01-01 14:00 | 5 |
Boards
BoardID | FlightID | EquipmentType | TerminalID |
| (→ Flights.FlightID) | | (→ Terminals.ID) |
101 | 101 | Jet Bridge | 1 |
102 | 102 | Staircar | 1 |
103 | 103 | Jet Bridge | 2 |
104 | 104 | Staircar | 2 |
105 | 105 | Jet Bridge | 3 |