24.03 DB Schema Changes
Added table(s)
tbl_Notification_Audit
Field | Data Type | NULLABLE |
---|---|---|
[lng_Notification_Audit_Id_Nmbr] | INT | NO |
[lng_Reservation_Nmbr] | INT | NO |
[lng_Pax_Id_Nmbr] | INT | NO |
[lng_Channel_Definition_Id] | INT | NO |
[str_Contact_Info] | VARCHAR (255) | NO |
[lng_Reservations_Alerts_Type_Id_Nmbr] | INT | NO |
[str_Message] | NVARCHAR (MAX) | NO |
[bit_Include_Itinerary] | BIT | NO |
[lng_Audit_User_Id_Nmbr] | INT | NO |
[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 |
Added column(s)
tbl_Res_ETicket_Assignments
Field | Data Type | NULLABLE |
---|---|---|
[str_Fare_Calculation] | VARCHAR (271) | NO |
tbl_Res_Passive_Legs
Field | Data Type | NULLABLE |
---|---|---|
[str_Aircraft_Model_Code] | VARCHAR (7) | NO |
tbl_Tickets
Field | Data Type | NULLABLE |
---|---|---|
[str_Fare_Calculation] | VARCHAR (271) | NO |
Modified column(s)
[tbl_Airport]
Field | Data Type | NULLABLE |
---|---|---|
[str_Ident] | VARCHAR (5) | NO |