24.08 DB Schema Changes
Added column(s)
tbl_Ticket_Sales_Record
Field | Data Type | NULLABLE |
---|---|---|
[str_Company_Identification_Number] | VARCHAR (3) | NO |
[str_InHouse_Identification] | VARCHAR (50) | NO |
[str_Provider_Type] | VARCHAR (3) | NO |
[str_Delivering_System_Identification] | VARCHAR (2) | NO |
[str_Delivering_System_Location] | VARCHAR (3) | NO |
[str_Originator_Location] | VARCHAR (3) | NO |
[str_Originator_Type_Code] | VARCHAR (1) | NO |
[str_Originator_Country_Code] | VARCHAR (3) | NO |
[str_Originator_Authority_Request_Code] | VARCHAR (6) | NO |
Added table(s)
tbl_Crew_APIS_Result
Field | Data Type | NULLABLE |
---|---|---|
[lng_Crew_APIS_Result_Id_Nmbr] | INT | NO |
[lng_Crew_Members_Sked_Detail_XRef_Id] | INT | YES |
[str_Country_Code] | VARCHAR (5) | YES |
[lng_Boarding_Security_Result_Types_Id_Nmbr] | INT | YES |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
tbl_PAXLST_City_Pair
Field | Data Type | NULLABLE |
---|---|---|
[lng_PAXLST_City_Pair_Id_Nmbr] | INT | NO |
[str_Departure_Airport] | VARCHAR (5) | NO |
[str_Arrival_Airport] | VARCHAR (5) | NO |
[str_Countries] | VARCHAR (500) | NO |
[str_Minutes_Before_Flight] | VARCHAR (500) | NO |
[str_Flight_Nmbrs] | VARCHAR (500) | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
tbl_Res_Header_Multi_City
Field | Data Type | NULLABLE |
---|---|---|
[lng_Res_Header_Multicity_Id_Nmbr] | INT | NO |
[lng_Reservation_Nmbr] | INT | YES |
[dtm_Creation_Date] | SMALLDATETIME | YES |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | YES |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |