Airports

idnamelocationcode
1JFK InternationalNew York, USAJFK
2LAXLos Angeles, USALAX
3YYZToronto, CanadaYYZ
4LHRLondon, UKLHR
5CDGParis, FranceCDG

Food_Courts

idairport_idnamefood_type
(→ Airports.id)
11Taste of New YorkAmerican
22California DelightsFast Food
33Maple Leaf BistroCanadian
44The British TavernBritish
55Le Petit DejeunerFrench

Retail_Shops

idairport_idnametype
(→ Airports.id)
11Duty Free ShopsDuty Free
22Gift ShopGifts
33Books & MagazinesBookstore
44Electronics StoreElectronics
55Clothing and AccessoriesClothing

Revenue

iddaterevenuefc_totalrs_total
12022-07-01$980,000NoneNone
22022-07-01$650,000NoneNone
32022-07-01$1,100,000NoneNone
42022-07-01$780,000NoneNone
52022-07-01$550,000NoneNone

FC_RS_Revenues

idfc_idrs_idrevenue_id
(→ Food_Courts.id)(→ Retail_Shops.id)(→ Revenue.id)
1111
2222
3333
4444
5555