23.08 DB Schema Changes
- Kalyn Galloway
Added table(s)
[tbl_Pax_Manifest_Auto_Send_Config]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Pax_Manifest_Auto_Send_Config_Id_Nmbr] | INT | NO |
[lng_Arr_Airport_Id_Nmbr] | INT | NO |
[lng_Minutes_Before_STD] | INT | NO |
[str_Email_Recipient] | VARCHAR (1000) | NO |
[str_Active] | CHAR (1) | 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_Pax_Manifest_Auto_Send_Detail]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Pax_Manifest_Auto_Send_Detail_Id_Nmbr] | INT | NO |
[lng_Sked_Detail_Id_Nmbr] | INT | NO |
[dtm_Send_Date] | SMALLDATETIME | NO |
[str_Send_Status] | CHAR (1) | NO |
[dtm_Last_Sent_Date] | SMALLDATETIME | YES |
[lng_Retry_Attempt] | INT | NO |
[str_Email_Recipient] | VARCHAR (1000) | NO |
[str_Last_Sent_Message] | VARCHAR (1000) | 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_Res_Modification_Audit]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Modification_Audit_Id_Nmbr] | BIGINT | NO |
[lng_Reservation_Nmbr] | INT | NO |
[lng_Change_Count] | 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 |
Added column(s)
[tbl_Res_Pax_Fare_Component]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Fare_Rules_Raw] | NVARCHAR (2000) | NO |
[str_Bag_Allowances_Raw] | NVARCHAR (2000) | NO |
[str_Bag_Policies_Raw] | NVARCHAR (2000) | NO |
[tbl_Res_Pax_Infant_Fare_Component]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Fare_Rules_Raw] | NVARCHAR (2000) | NO |
[str_Bag_Allowances_Raw] | NVARCHAR (2000) | NO |
[str_Bag_Policies_Raw] | NVARCHAR (2000) | NO |
[tbl_SSR_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
[str_SSR_Refundable_Flag] | CHAR (1) | NO |