20.03 DB Schema Changes

Owned by Thao Nguyen
Last updated: Feb 28, 2020
1 min read


Contents

Added Table(s)

[tbl_AviatorExport_Config]

Field1

Data Type

NULLABLE

[lng_Aviator_ExportFares_Config_Id_Nmbr]INTNO
[lng_Hour]INTNO
[lng_Minute]INTNO
[lng_Days_Next]INTNO
[lng_Days_Per_Chunk]INTNO
[str_Active]CHAR(1)NO
tsp_TimestampROWVERSIONNO
dtm_Creation_DateSMALLDATETIMENO
lng_Creation_User_Id_NmbrINTNO
dtm_Last_Mod_DateSMALLDATETIMENO
lng_Last_Mod_User_Id_NmbrINTNO

[tbl_Predefined_Weight_Definition]

Field1

Data Type

NULLABLE

[lng_Predefined_Weight_Id_Nmbr]INTNO
[str_Description]VARCHAR (128)NO
[mny_Male_Weight]MONEYNO
[mny_Female_Weight]MONEYNO
[mny_Child_Weight]MONEYNO
[mny_Infant_Weight]MONEYNO
[str_Active_Flag]CHAR(1)NO
tsp_TimestampROWVERSIONNO
dtm_Creation_DateSMALLDATETIMENO
lng_Creation_User_Id_NmbrINTNO
dtm_Last_Mod_DateSMALLDATETIMENO
lng_Last_Mod_User_Id_NmbrINTNO

Modified Table(s)

[tbl_Communication_Channel_Definition]

Field

Data Type

NULLABLE

[bit_Channel_Default]BITNO
lng_Last_Mod_User_Id_NmbrINTNO

[tbl_PNL]

Field

Data Type

NULLABLE

[str_Aeroplan_Nmbr]VARCHAR (20)NOT NULL
[str_Loyalty_Description]VARCHAR (30)NOT NULL

[tbl_Res_Pax_Group]

Field

Data Type

NULLABLE

[lng_Free_Name_Correction_Count]INTNOT NULL

[tbl_Sked_Detail_Weight]

Field

Data Type

NULLABLE

[mny_Adult_Female_Weight]MONEYNOT NULL
[lng_Predefined_Weight_Id_Nmbr]INTNOT NULL

Deleted Table(s)

[tbl_JazPlus_Charges_Sked_Xref]