## Customs

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

## Immigration

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

## Runway

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

## Terminal

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

## Flight

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

## Aircraft

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