/
21.04 DB Schema Changes
21.04 DB Schema Changes
- Thao Nguyen
Owned by Thao Nguyen
Apr 08, 2021
Loading data...
Added Table(s)
[dbo].[tbl_Flight_Type_IATA_Service_Type_XRef]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Flight_Type_IATA_Service_Type_XRef_ID_Nmbr] | INT | NO |
| [lng_Flight_Type_Id_Nmbr] | INT | NO |
| [lng_IATA_Service_Type_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 |
[dbo].[tbl_IATA_Service_Type_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_IATA_Service_Type_Id_Nmbr] | INT | NO |
| [str_IATA_Service_Type_Code] | CHAR (1) | NO |
| [str_IATA_Service_Type_Application] | VARCHAR (25) | NO |
| [str_IATA_Service_Type_Operation] | VARCHAR (25) | NO |
| [str_IATA_Service_Type_Description] | VARCHAR (100) | NO |
| [str_Deleted_Flag] | CHAR (1) | 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 |
Modified Table(s)
[dbo].[tbl_EMDs]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_EMD_Document_Number] | VARCHAR (13) | NO |
[dbo].[tbl_Ticket_GL_Charges_XRef]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Active_Xref] | CHAR (1) | NO |
[dbo].[tbl_Tickets]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Ticket_Document_Number] | VARCHAR (13) | NO |