22.05 DB Schema Changes
- Kalyn Galloway
Owned by Kalyn Galloway
May 02, 2022
1 min read
Loading data...
Deleted tables(s)
[tbl_Agency_User_Messages]
[tbl_User_Messages]
[tbl_User_Messages_Log]
Modified column(s)
[tbl_User_Settings]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Setting_Value] | VARCHAR (1000) | NO |
Added table(s)
[tbl_Document_Refund_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Document_Refund_Xref_Id_Nmbr] | INT | NO |
| [lng_Ticket_Id] | INT | NO |
| [lng_Emd_Id] | INT | NO |
| [mny_Amount] | MONEY | NO |
| [lng_GL_Payments_Refund_Id_Nmbr] | INT | NO |
| [lng_GL_Payments_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 |
[tbl_Gate_Pass]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Gate_Pass_Id_Nmbr] | INT | NO |
| [lng_Sked_Detail_Id_Nmbr] | INT | NO |
| [str_Last_Name] | VARCHAR (100) | NO |
| [str_First_Name] | VARCHAR (100) | NO |
| [str_Middle_Name] | VARCHAR (100) | NO |
| [str_Gender_Flag] | CHAR (1) | NO |
| [dtm_Date_Of_Birth] | SMALLDATETIME | YES |
| [str_Status_Flag] | 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_Gate_Pass_Vetting]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Gate_Pass_Vetting_Id_Nmbr] | INT | NO |
| [lng_Sked_Detail_Id_Nmbr] | INT | NO |
| [lng_Gate_Pass_Id_Nmbr] | INT | NO |
| [lng_Gate_Pass_Vetting_Result_Id_Nmbr] | INT | NO |
| [str_Airport_Code] | VARCHAR (5) | NO |
| [str_Last_Name] | VARCHAR (100) | NO |
| [str_First_Name] | VARCHAR (100) | NO |
| [str_Gender_Flag] | CHAR (1) | NO |
| [dtm_Date_Of_Birth] | SMALLDATETIME | 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_Gate_Pass_Vetting_History]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Gate_Pass_Vetting_History_Id_Nmbr] | INT | NO |
| [lng_Sked_Detail_Id_Nmbr] | INT | NO |
| [txt_Request] | NVARCHAR (MAX) | NO |
| [txt_Response] | NVARCHAR (MAX) | 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_Gate_Pass_Vetting_Result]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Gate_Pass_Vetting_Result_Id_Nmbr] | INT | NO |
| [str_Result_Value] | VARCHAR (10) | NO |
| [str_Result_Name] | VARCHAR (100) | NO |
| [bit_Print_Permitted] | BIT | NO |
| [bit_Selectee] | BIT | NO |
| [str_Selectee_Indicator] | VARCHAR (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 |