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