21.07 DB Schema Changes
- Kalyn Galloway
Owned by Kalyn Galloway
Jul 21, 2021
1 min read
Loading data...
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] | BIGINT | NO |
| [lng_Segment_Allocation_Status_Id_Nmbr] | INT | NO |
| [lng_Segment_Checkin_Status_Id_Nmbr] | INT | NO |
[tbl_Leg_Route_Allocation_Hold]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Segment_Allocation_Status_Id_Nmbr] | INT | NO |
[tbl_Leg_Route_Allocation_Hold_History]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Segment_Allocation_Status_Id_Nmbr] | INT | NO |
[tbl_Sked_Segment_Fare_Allocation]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Max_Availability_Display] | INT | YES |
| [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] | INT | YES |
| [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] | INT | NO |
[tbl_SSR_Definition_Price_Override]
Field | Data Type | NULLABLE |
|---|---|---|
| [dtm_Applicable_From] | DATETIME2 | YES |
| [dtm_Applicable_To] | DATETIME2 | YES |