id | name | country | city |
---|---|---|---|
1 | Heathrow | UK | London |
2 | Schiphol | Netherlands | Amsterdam |
id | name | headquartered_at |
---|---|---|
(→ Airports.id) | ||
1 | BA | 1 |
2 | KLM | 2 |
id | model | max_passengers | max_range | airline_id |
---|---|---|---|---|
(→ Airlines.id) | ||||
1 | Boeing 787 Dreamliner | 300 | 7639 | 1 |
2 | Airbus A380 | 525 | 8000 | 2 |
id | service_name | description | aircraft_id |
---|---|---|---|
(→ Aircrafts.id) | |||
1 | Meal Service | A variety of meals served on board. | 1 |
2 | Snack Service | Light snacks available for purchase. | 2 |
id | entertainment_name | description | aircraft_id |
---|---|---|---|
(→ Aircrafts.id) | |||
1 | Movie Selection | Wide range of movies available for viewing. | 1 |
2 | Games Library | Variety of games available for play. | 2 |