CompleteRoute |
Concatenation of individual travel
legs. |
VARCHAR2 (255) |
DepartureDateTime |
First leg departure date and
time. |
Date |
JourneyType |
Type of travel. |
VARCHAR2 (32) |
Number |
Passenger number. |
|
PassengerFirstName |
Passenger’s first
name. |
VARCHAR2 (60) |
PassengerEmail |
Passenger's email address, including
the complete domain name. |
VARCHAR2 (1500) |
PassengerId |
Ticketed passenger
identifier. |
VARCHAR2 (32) |
PassengerLastName |
Passenger’s last
name. |
VARCHAR2 (60) |
PassengerPhone |
Passenger's phone number. |
VARCHAR2 (100) |
PassengerStatus |
Company's passenger classification,
such as frequent flyer program. |
VARCHAR2 (32) |
PassengerType |
Passenger classification associated
with the price of the ticket. |
VARCHAR2 (32) |