ID | Name | City | Country |
---|---|---|---|
1 | Chicago O'Hare International Airport | Chicago | USA |
2 | Dallas/Fort Worth International Airport | DFW | USA |
3 | Los Angeles International Airport | LAX | USA |
4 | New York John F. Kennedy International Airport | NYC | USA |
5 | London Heathrow Airport | London | UK |
ID | Name | Code |
---|---|---|
1 | United Airlines | UA |
2 | Delta Airlines | DL |
3 | Southwest Airlines | WN |
4 | JetBlue Airways | B6 |
5 | Spirit Airlines | NK |
ProgramId | AirlineId | MemberName | JoinDate |
---|---|---|---|
(→ Airlines.ID) | |||
1 | 1 | John Doe | 2022-01-01 |
2 | 2 | Jane Smith | 2022-07-01 |
3 | 3 | Mike Johnson | 2022-10-01 |
4 | 4 | Emily Brown | 2022-11-01 |
5 | 5 | David Wilson | 2022-12-01 |
BenefitId | Description |
---|---|
1 | Elite Status |
2 | Priority Boarding |
3 | Free Baggage Check |
4 | Lounge Access |
5 | Preferred Seating |
ProgramId | BenefitId |
---|---|
(→ Frequent_Flyer_Program.ProgramId) | (→ Benefits.BenefitId) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |
3 | 4 |