/
21.07 DB Schema Changes

21.07 DB Schema Changes

Owned by Kalyn Galloway
Jul 21, 2021


Deleted Table(s)

[tbl_GDS_AVS_Sked_Segment_OneToRuleThemAll]

[tbl_Leg_Route_Allocation_Hold_History_OneToRuleThemAll]

[tbl_Leg_Route_Allocation_Hold_OneToRuleThemAll]

[tbl_Leg_Route_Allocation_OneToRuleThemAll]

[tbl_Res_Guid_Xref]

[tbl_Sked_Segment_Fare_Allocation_Audit_OneToRuleThemAll]

[tbl_Sked_Segment_Fare_Allocation_OneToRuleThemAll]

Modified table(s)

[tbl_Leg_Route_Allocation]

Field

Data Type

NULLABLE

[lng_Sked_Segment_Level_of_Service_Id_Nmbr]BIGINTNO
[lng_Segment_Allocation_Status_Id_Nmbr]INT

NO

[lng_Segment_Checkin_Status_Id_Nmbr]INTNO

[tbl_Leg_Route_Allocation_Hold]

Field

Data Type

NULLABLE

[lng_Segment_Allocation_Status_Id_Nmbr]INTNO

[tbl_Leg_Route_Allocation_Hold_History]

Field

Data Type

NULLABLE

[lng_Segment_Allocation_Status_Id_Nmbr]INTNO

[tbl_Sked_Segment_Fare_Allocation]

Field

Data Type

NULLABLE

[lng_Max_Availability_Display]INTYES
[str_GDS_Flag]CHAR (1)YES
[str_AVS_Status_Code]VARCHAR (2)YES

[tbl_Sked_Segment_Fare_Allocation_Audit]

Field

Data Type

NULLABLE

[lng_Max_Availability_Display]INTYES
[str_GDS_Flag]CHAR (1)YES
[str_AVS_Status_Code]VARCHAR (2)YES

[tbl_Sked_Segment_Level_of_Service]

Field

Data Type

NULLABLE

[lng_LOS_Available_Amt]INTNO

[tbl_SSR_Definition_Price_Override]

Field

Data Type

NULLABLE

[dtm_Applicable_From]DATETIME2YES
[dtm_Applicable_To]DATETIME2YES

Related content