id | Airport | CustomOfficerName | CustomOfficePhoneNumber | OpeningHours |
---|---|---|---|---|
1 | Gatwick | John Doe | 1234567890 | 06:00 - 22:00 |
2 | Heathrow | Jane Smith | 0987654321 | 06:30 - 21:30 |
3 | Stansted | Alice Brown | 1122334455 | 07:00 - 21:00 |
4 | Luton | Bob Johnson | 2233445566 | 06:00 - 22:00 |
5 | Manchester | Charlie White | 3344556677 | 06:30 - 21:30 |
id | Airport | ImmigrationOfficerName | ImmigrationOfficePhoneNumber | OpeningHours |
---|---|---|---|---|
1 | Gatwick | Michael Black | 1357924680 | 06:00 - 22:00 |
2 | Heathrow | Emma Green | 0987654321 | 06:30 - 21:30 |
3 | Stansted | David Blue | 1122334455 | 07:00 - 21:00 |
4 | Luton | Nathan Red | 2233445566 | 06:00 - 22:00 |
5 | Manchester | Simon Yellow | 3344556677 | 06:30 - 21:30 |
id | Airport | Length | Width | SurfaceType |
---|---|---|---|---|
1 | Gatwick | 3000.0 | 45.0 | Asphalt |
2 | Heathrow | 3200.0 | 60.0 | Concrete |
3 | Stansted | 2800.0 | 40.0 | Asphalt |
4 | Luton | 2500.0 | 35.0 | Asphalt |
5 | Manchester | 3100.0 | 50.0 | Concrete |
id | Airport | Name | NumberOfDoors | Facilities |
---|---|---|---|---|
1 | Gatwick | Terminal A | 10 | Shops, Restaurants, Baggage Claim |
2 | Heathrow | Terminal 2 | 15 | Duty Free Shops, Lounge, Currency Exchange |
3 | Stansted | Terminal 1 | 8 | Cafes, Information Desk, Baby Changing Rooms |
4 | Luton | Main Terminal | 6 | ATMs, Lost & Found, Car Rental |
5 | Manchester | Terminal 1 | 12 | WiFi, Parking, Disabled Access |
id | DepartureTime | ArrivalTime | DestinationAirport | PlaneId |
---|---|---|---|---|
(→ Aircraft.id) | ||||
1 | 2023-04-01 08:00:00 | 2023-04-01 11:00:00 | New York | 1 |
2 | 2023-04-01 10:00:00 | 2023-04-01 13:00:00 | Los Angeles | 2 |
3 | 2023-04-01 12:00:00 | 2023-04-01 15:00:00 | Paris | 3 |
4 | 2023-04-01 14:00:00 | 2023-04-01 17:00:00 | Tokyo | 4 |
5 | 2023-04-01 16:00:00 | 2023-04-01 19:00:00 | Rome | 5 |
id | Model | Capacity | RegistrationNumber | Manufacturer |
---|---|---|---|---|
1 | Boeing 747-400 | 400 | G-BNAC | Boeing |
2 | Airbus A380 | 800 | G-KBJS | Airbus |
3 | Bombardier CRJ-1000 | 100 | EI-EEE | Bombardier |
4 | Embraer E190 | 100 | PS-AMZ | Embraer |
5 | AIRBUS A320 | 180 | VQ-BEA | Airbus |