| 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 |