FlightID | Origin | Destination | DepartureTime |
---|---|---|---|
1 | JFK | LAX | 2023-04-01 08:00:00 |
2 | ORD | ATL | 2023-04-02 10:00:00 |
3 | SEA | DEN | 2023-04-03 12:00:00 |
4 | IAH | MIA | 2023-04-04 14:00:00 |
5 | DFW | PHX | 2023-04-05 16:00:00 |
PassengerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Smith | johnsmith@email.com | 555-123-4567 |
2 | Jane | Doe | janedoe@email.com | 555-987-6543 |
3 | Alice | Johnson | alicejohnson@email.com | 555-432-1234 |
4 | Bob | Williams | bobwilliams@email.com | 555-654-3219 |
5 | Emma | Brown | emmabrown@email.com | 555-111-2222 |
AssistantID | Name | ContactInfo |
---|---|---|
1 | Clare Allen | clareallen@assistant.com; +1-234-567-8900 |
2 | David Johnson | davidjohnson@assistant.com; +1-345-678-9012 |
UMID | PassengerID | AssistantID |
---|---|---|
(→ Passenger.PassengerID) | (→ Assistant.AssistantID) | |
1 | 1 | 1 |
2 | 2 | 2 |
SNPID | PassengerID | AssistantID |
---|---|---|
(→ Passenger.PassengerID) | (→ Assistant.AssistantID) | |
1 | 3 | 1 |
2 | 4 | 2 |
BookingID | FlightID | PassengerID | UMID | SNPID |
---|---|---|---|---|
(→ Flight.FlightID) | (→ Passenger.PassengerID) | (→ UnaccompaniedMinor.UMID) | (→ SpecialNeedsPassenger.SNPID) | |
1 | 1 | 1 | 1 | None |
2 | 2 | 2 | None | 1 |
3 | 3 | 3 | 2 | 2 |
4 | 4 | 4 | 1 | None |
5 | 5 | 5 | None | 1 |