## 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