23.11 DB Schema Changes
- Kalyn Galloway
Added column(s)
[tbl_Auto_CheckIn_City_Pair]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Airline_Codes_Ident] | CHAR (2) | NO |
[tbl_Ticket_Sales_Record]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Fare_Amount] | VARCHAR (12) | NO |
[str_Total_Amount] | VARCHAR (12) | NO |
Added table(s)
[tbl_Meal_Code_Rules]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Rule_Id_Nmbr] | INT | NO |
[str_Airline_Code] | VARCHAR (5) | NO |
[str_City_Pair] | VARCHAR (10) | NO |
[dtm_Dep_Time_From] | DATETIME | NO |
[dtm_Dep_Time_To] | DATETIME | NO |
[lng_Flight_Number_Range_From] | INT | NO |
[lng_Flight_Number_Range_To] | INT | NO |
[dtm_Flight_Date_From] | DATETIME | NO |
[dtm_Flight_Date_To] | DATETIME | NO |
[str_Meal_Code] | VARCHAR (300) | 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_Pax_Infant_Passive_Leg_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Infant_Passive_Leg_Xref_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Infant_Id_Nmbr] | INT | NO |
[lng_Res_Passive_Legs_Id_Nmbr] | INT | NO |
[str_Partner_Response] | VARCHAR (2) | NO |
[str_SSR_Text] | VARCHAR (100) | 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 |
[tbl_SSR_Res_Leg_Booking_Lifecycle_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_SSR_Res_Leg_Booking_Lifecycle_Xref_Id_Nmbr] | INT | NO |
[lng_SSR_Res_Leg_Xref_Id_Nmbr] | INT | NO |
[lng_Pax_Booking_Lifecycle_Id_Nmbr] | INT | 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_Terminal_Rules]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Rule_Id] | INT | NO |
[str_City_Pair] | VARCHAR (10) | NO |
[str_Airline_Code] | VARCHAR (5) | NO |
[dtm_Flight_Date_From] | SMALLDATETIME | NO |
[dtm_Flight_Date_To] | SMALLDATETIME | NO |
[lng_Flight_Number_Range_From] | INT | NO |
[lng_Flight_Number_Range_To] | INT | NO |
[str_Departure_Terminal] | VARCHAR (2) | NO |
[str_Arrival_Terminal] | VARCHAR (2) | 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 |