id | name | |
---|---|---|
1 | John Doe | john.doe@example.com |
2 | Jane Smith | jane.smith@example.com |
3 | Michael Johnson | michael.johnson@example.com |
4 | Emily Davis | emily.davis@example.com |
5 | William Brown | william.brown@example.com |
id | name | location |
---|---|---|
1 | New York JFK | New York City, USA |
2 | Los Angeles LAX | Los Angeles, USA |
3 | London Heathrow | London, UK |
4 | Paris CDG | Paris, France |
5 | Tokyo Narita | Tokyo, Japan |
id | airport_id | terminal_name | capacity |
---|---|---|---|
(→ Airports.id) | |||
1 | 1 | Terminal 1 | 20 |
2 | 1 | Terminal 2 | 30 |
3 | 2 | Terminal 4 | 40 |
4 | 3 | Terminal 2 | 50 |
5 | 4 | Terminal A | 60 |
id | architecture_firm | architect | airport_terminal |
---|---|---|---|
(→ Terminals.terminal_name) | |||
1 | Studio A | John Doe | Terminal 1 |
2 | Studio B | Jane Smith | Terminal 2 |
3 | Studio C | Michael Johnson | Terminal 4 |
4 | Studio D | Emily Davis | Terminal A |
5 | Studio E | William Brown | Terminal 2 |
id | flight_number | departure_airport | arrival_airport |
---|---|---|---|
(→ Airports.name) | (→ Airports.name) | ||
1 | AA123 | New York JFK | London Heathrow |
2 | DL456 | Los Angeles LAX | Paris CDG |
3 | BA789 | London Heathrow | New York JFK |
4 | AF101 | Paris CDG | Tokyo Narita |
5 | LH234 | Frankfurt FRA | New York JFK |