## Airlines

id | name | country
--- | --- | ---
1 | United Airlines | USA
2 | Delta Airlines | USA
3 | American Airlines | USA
4 | Southwest Airlines | USA
5 | Air Canada | Canada

## Airports

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

## Flights

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

## Gates

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

## Services

id | serviceName
--- | ---
1 | Baggage_Claim
2 | Food_Court
3 | Duty_Free
4 | Car_Rental
5 | Lost_and_Found

## Gates_Services

gateId | serviceId
--- | ---
(→ Gates.id) | (→ Services.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 3