20.09 DB Schema Changes

Owned by Thao Nguyen
Oct 05, 2020
1 min read

Added Table(s)

[tbl_Document_Providers]

Field

Data Type

NULLABLE

[lng_Document_Provider_Id]INTNO
[str_Document_Provider_Code]VARCHAR (2)NO
[str_Document_Provider_Name]VARCHAR (20)NO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO

[tbl_ETicket_Free_Baggage_Allowance]

Field

Data Type

NULLABLE

[lng_ETicket_Free_Baggage_Allowance_Id_Nmbr]INTNO
[str_ETicketAndCoupon_Nmbr]VARCHAR (20)YES
[lng_ETCoupon_FreeBaggage_TotalWeight]INTNO
[str_ETCoupon_FreeBaggage_MeasureUnitQualifier]VARCHAR (3)NO
[lng_ETCoupon_FreeBaggage_TotalNumberOfPieces]INTNO
[tsp_Timestamp]ROWVERSIONNO
[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)

[tbl_Carriers]

Field

Data Type

NULLABLE

[lng_Response_Wait_Minutes]INTNO

[tbl_EMDs]

Field

Data Type

NULLABLE

[lng_Document_Provider_Id]INTNO

[tbl_Res_Header]

Field

Data Type

NULLABLE

[lng_Document_Provider_Id]INTNO

[tbl_Tickets]

Field

Data Type

NULLABLE

[lng_Document_Provider_Id]INTNO

[tbl_Accountable_Document_Form_Codes]

Field

Data Type

NULLABLE

[lng_Document_Provider_Id]INTNO

[tbl_Datamart_Users]

Field

Data Type

NULLABLE

[str_User_Logon_Name]VARCHAR (50)NO