20.06 DB Schema Changes

Owned by Thao Nguyen
May 25, 2020
1 min read


[tbl_Cargo_Tracking_Passive]Added Table(s)

Field1

Data Type

NULLABLE

[lng_Cargo_Tracking_Passive_Id_Nmbr]INTNO
[lng_Baggage_Id_Nmbr]INTNO
[dtm_Flight_Date]SMALLDATETIMENO
[str_Flight_Nmbr]VARCHAR (8)NO
[str_Dep_Airport_Code]VARCHAR (3)NO
[str_Arr_Airport_Code]VARCHAR (3)NO
tsp_TimestampROWVERSIONNO
dtm_Creation_DateSMALLDATETIMENO
lng_Creation_User_Id_NmbrINTNO
dtm_Last_Mod_DateSMALLDATETIMENO
lng_Last_Mod_User_Id_NmbrINTNO

[tbl_Res_Pax_Infant_Leg_Route_Xref]

Field1

Data Type

NULLABLE

[lng_Res_Pax_Infant_Leg_Route_Id_Nmbr]INTNO
[lng_Res_Pax_Infant_Id_Nmbr]VARCHAR (128)NO
[lng_Leg_Route_Id_Nmbr]MONEYNO
tsp_TimestampROWVERSIONNO
dtm_Creation_DateSMALLDATETIMENO
lng_Creation_User_Id_NmbrINTNO
dtm_Last_Mod_DateSMALLDATETIMENO
lng_Last_Mod_User_Id_NmbrINTNO

Modified Table(s)

[tbl_CRS]

Field

Data Type

NULLABLE

[str_Settings]VARCHAR (500)NO

[tbl_EMD_Coupon_Associations]

Field

Data Type

NULLABLE

[lng_GL_Charges_Id_Nmbr]BIGINTNOT NULL

[tbl_EMD_Coupon_Associations_Audit]

Field

Data Type

NULLABLE

[lng_GL_Charges_Id_Nmbr]BIGINTNULL

[tbl_Fare_Allocation]

Field

Data Type

NULLABLE

[str_Avs_Status_Code]VARCHAR (2)NOT NULL

[tbl_GDS_AVS]

Field

Data Type

NULLABLE

[str_Existing_Status_Code]VARCHAR (2)NOT NULL
[lng_Availability]INTNOT NULL

[tbl_GDS_AVS_History]

Field

Data Type

NULLABLE

[lng_Availability]INTNOT NULL

[tbl_Res_ETicket_Assignments]

Field

Data Type

NULLABLE

[lng_GL_Payments_Id_Nmbr]INTNOT NULL