## Airports

id | name | location
--- | --- | ---
1 | JFK International | Queens, NY
2 | Los Angeles International | LAX, CA
3 | Dubai International | UAE
4 | Tokyo Haneda | Tokyo, Japan
5 | Heathrow Airport | London, UK

## Flights

id | flightNumber | departureTime | destination | airport_id
--- | --- | --- | --- | ---
|  |  |  | (→ Airports.id)
1 | 123 | 2023-01-01 18:00:00 | Paris | 1
2 | 456 | 2023-01-01 21:00:00 | Dublin | 2
3 | 789 | 2023-01-01 22:00:00 | Cape Town | 3
4 | 101 | 2023-01-01 17:00:00 | Beijing | 4
5 | 111 | 2023-01-01 16:00:00 | Hong Kong | 5

## Terminals

id | name | capacity | airport_id
--- | --- | --- | ---
|  |  | (→ Airports.id)
1 | Terminal A | 1000 | 1
2 | Terminal B | 1500 | 1
3 | Terminal C | 2000 | 2
4 | Terminal D | 2500 | 3
5 | Terminal E | 3000 | 4

## Renovations

id | startDate | endDate | cost | description | terminal_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Terminals.id)
1 | 2023-01-01 | 2023-01-15 | 500000.0 | Upgrading security systems | 1
2 | 2023-01-15 | 2023-01-30 | 600000.0 | Additional shopping area | 2
3 | 2023-01-30 | 2023-02-15 | 700000.0 | Improving passenger flow | 3
4 | 2023-02-15 | 2023-03-01 | 800000.0 | Enhancing lighting and signage | 4
5 | 2023-03-01 | 2023-03-15 | 900000.0 | Redesigning gate areas | 5