FlightID | DepartureTime | Destination | Origin | FlightNumber | Type | AirlineID |
---|---|---|---|---|---|---|
(→ Airlines.AirlinesID) | ||||||
1 | 2023-01-01 08:00 | New York | Los Angeles | AA123 | Boeing 737 | 1 |
2 | 2023-01-01 10:00 | Chicago | Miami | UA678 | Boeing 747 | 2 |
3 | 2023-01-01 12:00 | Dallas | Atlanta | DL987 | Airbus A320 | 3 |
4 | 2023-01-01 14:00 | Philadelphia | Phoenix | SW456 | Bombardier Q400 | 4 |
5 | 2023-01-01 16:00 | San Francisco | Honolulu | JB234 | Boeing 787 | 5 |
AirlinesID | Name |
---|---|
1 | American Airlines |
2 | United Airlines |
3 | Delta Airlines |
4 | Southwest Airlines |
5 | JetBlue Airlines |
FacilityID | Description |
---|---|
1 | Free WiFi access for passengers. |
2 | Business center with printing services. |
3 | Kids play area for families. |
4 | VIP lounge for premium customers. |
5 | Currency exchange services. |
DepartureID | FacilityID |
---|---|
(→ Flights.FlightID) | (→ Facilities.FacilityID) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
ArrivalID | FacilityID |
---|---|
(→ Flights.FlightID) | (→ Facilities.FacilityID) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |