id | name | country |
---|---|---|
1 | United Airlines | USA |
2 | Delta Airlines | USA |
3 | American Airlines | USA |
4 | Southwest Airlines | USA |
5 | Air Canada | Canada |
id | airportName | city | country |
---|---|---|---|
1 | John F. Kennedy International Airport | New York | USA |
2 | Hartsfield-Jackson Atlanta International Airport | Atlanta | USA |
3 | Los Angeles International Airport | Los Angeles | USA |
4 | Toronto Pearson International Airport | Toronto | Canada |
5 | Vancouver International Airport | Vancouver | Canada |
id | flightNumber | departureTime | arrivalTime | airlineId | originAirportId | destinationAirportId |
---|---|---|---|---|---|---|
(→ Airlines.id) | (→ Airports.id) | (→ Airports.id) | ||||
1 | UA123 | 2022-07-10 08:00:00 | 2022-07-10 10:00:00 | 1 | 1 | 2 |
2 | DL456 | 2022-07-10 10:00:00 | 2022-07-10 12:00:00 | 2 | 1 | 3 |
3 | AA789 | 2022-07-10 14:00:00 | 2022-07-10 16:00:00 | 3 | 1 | 4 |
4 | SW101 | 2022-07-10 16:00:00 | 2022-07-10 18:00:00 | 4 | 1 | 5 |
5 | AC246 | 2022-07-10 18:00:00 | 2022-07-10 20:00:00 | 5 | 1 | 6 |
id | gateNumber | terminal | airportId |
---|---|---|---|
(→ Airports.id) | |||
1 | 1 | 1 | 1 |
2 | 2 | 1 | 1 |
3 | 3 | 1 | 1 |
4 | 4 | 1 | 1 |
5 | 5 | 1 | 1 |
id | serviceName |
---|---|
1 | Baggage_Claim |
2 | Food_Court |
3 | Duty_Free |
4 | Car_Rental |
5 | Lost_and_Found |
gateId | serviceId |
---|---|
(→ Gates.id) | (→ Services.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 3 |