24.12 DB Schema Changes
- Kalyn Galloway
Added table(s)
tbl_Auto_CheckIn_City_Pair_Flight
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Auto_CheckIn_City_Pair_Flight_Id_Nmbr] | INT | NO |
[lng_Auto_CheckIn_City_Pair_Id_Nmbr] | INT | NO |
[str_Flight_Nmbr] | VARCHAR (20) | 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_Auto_CheckIn_City_Pair_SSR
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Auto_CheckIn_City_Pair_SSR_Id_Nmbr] | INT | NO |
[lng_Auto_CheckIn_City_Pair_Id_Nmbr] | INT | NO |
[str_SSR_Code] | VARCHAR (20) | 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_Auto_CheckIn_City_Pair_Timing
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Auto_CheckIn_City_Pair_Timing_Id_Nmbr] | INT | NO |
[lng_Auto_CheckIn_City_Pair_Id_Nmbr] | INT | NO |
[lng_Minutes_Before_Flight] | 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_GL_Charges_Insurance_Xref
Field | Data Type | NULLABLE |
|---|---|---|
[lng_GL_Charges_Insurance_Xref_Id_Nmbr] | BIGINT | NO |
[lng_GL_Charges_Id_Nmbr] | BIGINT | NO |
[lng_Res_Insurance_Policy_Id] | INT | NO |
[str_Active_Flag] | CHAR (1) | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[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_Currency
Field | Data Type | NULLABLE |
|---|---|---|
[bit_Active] | BIT | NO |
tbl_GDS_Msg_Detail
Field | Data Type | NULLABLE |
|---|---|---|
[str_Amelia_Record_Locator] | VARCHAR (6) | NO |
tbl_Auto_CheckIn_City_Pair
Field | Data Type | NULLABLE |
|---|---|---|
[chr_Send_Boarding_Pass] | CHAR (1) | NO |
[chr_Use_Serverless_Boarding_Pass] | CHAR (1) | NO |
tbl_PAXLST_City_Pair
Field | Data Type | NULLABLE |
|---|---|---|
[chr_Send_On_Flight_Closed] | VARCHAR (1) | NO |
[chr_Skip_Thru_Pax] | VARCHAR (1) | NO |
tbl_Res_Insurance_Policy
Field | Data Type | NULLABLE |
|---|---|---|
[str_Services_Provider] | VARCHAR (100) | YES |
Updated column(s)
tbl_Res_Insurance_Policy
Field | Data Type | NULLABLE |
|---|---|---|
[str_Password] | VARCHAR (256) | NO |
Deleted column(s)
tbl_Auto_CheckIn_City_Pair
Field | Data Type | NULLABLE |
|---|---|---|
[str_Flight_Nmbrs] | VARCHAR (MAX) | NO |