21.04 DB Schema Changes

Owned by Thao Nguyen
Apr 08, 2021
1 min read


Added Table(s)

[dbo].[tbl_Flight_Type_IATA_Service_Type_XRef]

Field

Data Type

NULLABLE

[lng_Flight_Type_IATA_Service_Type_XRef_ID_Nmbr]INTNO
[lng_Flight_Type_Id_Nmbr]INTNO
[lng_IATA_Service_Type_Id_Nmbr]INTNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_ID_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_ID_Nmbr]INTNO

[dbo].[tbl_IATA_Service_Type_Definition]

Field

Data Type

NULLABLE

[lng_IATA_Service_Type_Id_Nmbr]INTNO
[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]SMALLDATETIMEYES
[lng_Creation_User_ID_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_ID_Nmbr]INTNO

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