Airports
id | name | location | code |
1 | JFK International | New York, USA | JFK |
2 | LAX | Los Angeles, USA | LAX |
3 | YYZ | Toronto, Canada | YYZ |
4 | LHR | London, UK | LHR |
5 | CDG | Paris, France | CDG |
Food_Courts
id | airport_id | name | food_type |
| (→ Airports.id) | | |
1 | 1 | Taste of New York | American |
2 | 2 | California Delights | Fast Food |
3 | 3 | Maple Leaf Bistro | Canadian |
4 | 4 | The British Tavern | British |
5 | 5 | Le Petit Dejeuner | French |
Retail_Shops
id | airport_id | name | type |
| (→ Airports.id) | | |
1 | 1 | Duty Free Shops | Duty Free |
2 | 2 | Gift Shop | Gifts |
3 | 3 | Books & Magazines | Bookstore |
4 | 4 | Electronics Store | Electronics |
5 | 5 | Clothing and Accessories | Clothing |
Revenue
id | date | revenue | fc_total | rs_total |
1 | 2022-07-01 | $980,000 | None | None |
2 | 2022-07-01 | $650,000 | None | None |
3 | 2022-07-01 | $1,100,000 | None | None |
4 | 2022-07-01 | $780,000 | None | None |
5 | 2022-07-01 | $550,000 | None | None |
FC_RS_Revenues
id | fc_id | rs_id | revenue_id |
| (→ Food_Courts.id) | (→ Retail_Shops.id) | (→ Revenue.id) |
1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
4 | 4 | 4 | 4 |
5 | 5 | 5 | 5 |