## Airports

id | name | city | country
--- | --- | --- | ---
1 | JFK International | New York City | USA
2 | Los Angeles International | Los Angeles | USA
3 | Dubai International | Dubai | UAE
4 | Heathrow Airport | London | UK
5 | Charles de Gaulle Airport | Paris | France

## Runways

id | length | width | surfaceType | airportId
--- | --- | --- | --- | ---
|  |  |  | (→ Airports.id)
1 | 9876.5 | 150.0 | Asphalt | 1
2 | 10000.0 | 200.0 | Concrete | 2
3 | 8500.0 | 180.0 | Grass | 3
4 | 7500.0 | 160.0 | Concrete | 4
5 | 9999.0 | 210.0 | Asphalt | 5

## Taxiways

id | length | width | surfaceType | airportId
--- | --- | --- | --- | ---
|  |  |  | (→ Airports.id)
1 | 2000.0 | 150.0 | Asphalt | 1
2 | 2200.0 | 160.0 | Concrete | 2
3 | 1800.0 | 140.0 | Grass | 3
4 | 2500.0 | 170.0 | Concrete | 4
5 | 2100.0 | 180.0 | Asphalt | 5

## Infrastructures

id | type | constructionDate | description | airportId
--- | --- | --- | --- | ---
|  |  |  | (→ Airports.id)
1 | Runway | 2015-01-01 | This runway was built on January 1st, 2015. | 1
2 | Terminal Building | 2010-03-01 | This terminal building was constructed on March 1st, 2010. | 2
3 | Runway | 2018-06-01 | This runway opened on June 1st, 2018. | 3
4 | Taxiway | 2015-01-01 | This taxiway has been in operation since its opening date of January 1st, 2015. | 4
5 | Control Tower | 2013-02-01 | The control tower started operations on February 1st, 2013. | 5