ID | LocationName |
---|---|
1 | Zone A |
2 | Zone B |
3 | Zone C |
4 | Zone D |
5 | Zone E |
AirlineID | Name | Code |
---|---|---|
1 | American | AA |
2 | United | UA |
3 | Delta | DL |
4 | Southwest | WN |
5 | Alaska | AS |
FlightNumber | DepartureTime | Destination | Origin | AirlineID |
---|---|---|---|---|
(→ Airlines.AirlineID) | ||||
101 | 2023-04-01 10:00:00 | New York | Los Angeles | 1 |
102 | 2023-04-01 11:00:00 | San Francisco | Chicago | 2 |
103 | 2023-04-01 12:00:00 | Dallas | Atlanta | 3 |
104 | 2023-04-01 13:00:00 | Seattle | Honolulu | 4 |
105 | 2023-04-01 14:00:00 | Miami | Boston | 5 |
PassengerID | FirstName | LastName | PhoneNumber | PickedUpFrom | |
---|---|---|---|---|---|
(→ Pick_Up_Locations.ID) | |||||
1 | John | Doe | +1234567890 | john.doe@example.com | None |
2 | Jane | Smith | +0987654321 | jane.smith@example.com | None |
3 | Michael | Johnson | +1112223333 | michael.johnson@example.com | None |
4 | Emily | Williams | +2223334444 | emily.williams@example.com | None |
5 | David | Brown | +3334445555 | david.brown@example.com | None |
RentalID | PickUpDate | DropOffDate | CarModel | CustomerID | PickUpLocationID |
---|---|---|---|---|---|
(→ Passengers.PassengerID) | (→ Pick_Up_Locations.ID) | ||||
1 | 2023-04-01 09:00:00 | 2023-04-01 18:00:00 | Toyota Camry | 1 | 1 |
2 | 2023-04-02 09:00:00 | 2023-04-02 18:00:00 | Ford Explorer | 2 | 2 |
3 | 2023-04-03 09:00:00 | 2023-04-03 18:00:00 | Chevrolet Malibu | 3 | 3 |
4 | 2023-04-04 09:00:00 | 2023-04-04 18:00:00 | Nissan Altima | 4 | 4 |
5 | 2023-04-05 09:00:00 | 2023-04-05 18:00:00 | Honda Accord | 5 | 5 |
ShuttleID | Schedule | Terminal | Capacity | PickUpLocationID |
---|---|---|---|---|
(→ Pick_Up_Locations.ID) | ||||
1 | 2023-04-01 07:00:00 | 1 | 10 | 1 |
2 | 2023-04-02 07:00:00 | 2 | 12 | 2 |
3 | 2023-04-03 07:00:00 | 3 | 8 | 3 |
4 | 2023-04-04 07:00:00 | 4 | 10 | 4 |
5 | 2023-04-05 07:00:00 | 5 | 12 | 5 |