ProgramID | ProgramName | PointsRequired |
---|---|---|
1 | MileagePlus | 2000 |
2 | AAdvantage | 3000 |
3 | SkyMiles | 4000 |
4 | OneWorld | 5000 |
5 | KrisFlyer | 6000 |
BenefitID | BenefitType |
---|---|
1 | Free_Upgrades |
2 | Lounge_Access |
3 | Priority_Checkin |
4 | Extra_Baggage |
5 | Discounted_Flights |
ProgramID | BenefitID |
---|---|
(→ Frequent_Flyer_Programs.ProgramID) | (→ Benefits.BenefitID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |