Airports

idnamelocation
1JFK InternationalQueens, NY
2Los Angeles InternationalLAX, CA
3Dubai InternationalUAE
4Tokyo HanedaTokyo, Japan
5Heathrow AirportLondon, UK

Flights

idflightNumberdepartureTimedestinationairport_id
(→ Airports.id)
11232023-01-01 18:00:00Paris1
24562023-01-01 21:00:00Dublin2
37892023-01-01 22:00:00Cape Town3
41012023-01-01 17:00:00Beijing4
51112023-01-01 16:00:00Hong Kong5

Terminals

idnamecapacityairport_id
(→ Airports.id)
1Terminal A10001
2Terminal B15001
3Terminal C20002
4Terminal D25003
5Terminal E30004

Renovations

idstartDateendDatecostdescriptionterminal_id
(→ Terminals.id)
12023-01-012023-01-15500000.0Upgrading security systems1
22023-01-152023-01-30600000.0Additional shopping area2
32023-01-302023-02-15700000.0Improving passenger flow3
42023-02-152023-03-01800000.0Enhancing lighting and signage4
52023-03-012023-03-15900000.0Redesigning gate areas5