id | name | city | country |
---|---|---|---|
1 | San Francisco International | San Francisco | USA |
2 | London Heathrow | London | UK |
3 | Dubai International | Dubai | UAE |
4 | Tokyo Haneda | Tokyo | Japan |
5 | New York JFK | New York | USA |
id | number | capacity | airportId |
---|---|---|---|
(→ Airport.id) | |||
1 | 1 | 30 | 1 |
2 | 2 | 28 | 1 |
3 | 1 | 27 | 2 |
4 | 2 | 26 | 2 |
5 | 1 | 25 | 3 |
id | gateNumber | terminalId |
---|---|---|
(→ Terminal.id) | ||
1 | 1 | 1 |
2 | 2 | 1 |
3 | 3 | 2 |
4 | 4 | 2 |
5 | 5 | 1 |
id | flightNumber | airlineName | departureTime | arrivalTime | originAirportId | destinationAirportId | gateId |
---|---|---|---|---|---|---|---|
(→ Airport.id) | (→ Airport.id) | (→ Gate.id) | |||||
1 | AA101 | American Airlines | 2022-12-10 09:00:00 | 2022-12-10 12:00:00 | 1 | 2 | 1 |
2 | BA202 | British Airways | 2022-12-11 11:00:00 | 2022-12-11 15:00:00 | 2 | 3 | 2 |
3 | EK310 | Emirates | 2022-12-12 08:00:00 | 2022-12-12 14:00:00 | 3 | 4 | 3 |
4 | UA888 | United Airlines | 2022-12-13 09:00:00 | 2022-12-13 12:00:00 | 1 | 2 | 4 |
5 | NH100 | All Nippon Airways | 2022-12-14 11:00:00 | 2022-12-14 15:00:00 | 4 | 1 | 5 |
id | operationType | details | facilities | flightId |
---|---|---|---|---|
(→ Flight.id) | ||||
1 | Departure | Check-in counters open at 6am | Lounge Access | 1 |
2 | Departure | Security checkpoint opens at 5:30am | Free WiFi | 2 |
3 | Arrival | Customs and immigration hall open at 6am | Lounge Access | 3 |
4 | Arrival | Baggage claim area opens at 5:30am | Free WiFi | 4 |
5 | Departure | Gates close at 8:45am | 5 | |
6 | Arrival | Gates open at 7am | 6 |