| 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 |