22.06 DB Schema Changes

Owned by Kalyn Galloway
Jun 13, 2022
1 min read

Deleted tables(s)

[tbl_Pricing_Channel]

[tbl_Agency_User_Messages]

[tbl_User_Messages]

[tbl_User_Messages_Log]

Added column(s)

[tbl_Carriers]

Field

Data Type

NULLABLE

[bit_Interline]BIT

NO

[tbl_SSR_Definition_Price_Override]

Field

Data Type

NULLABLE

[lng_Pax_Booking_Lifecycle_Id_Nmbr]INT

NO

Deleted column(s)

[tbl_SSR_Definition_Price_Override]

Field

Data Type

NULLABLE

[lng_Pricing_Channel_Id_Nmbr]INT

NO

Added table(s)

[tbl_APIS_Aircraft_Model]

Field

Data Type

NULLABLE

[lng_APIS_Aircraft_Model_Id_Nmbr]INT

NO

[lng_Aircraft_Model_Id_Nmbr]INTNO
[str_Country_Code]CHAR (3)NO
[dtm_Creation_Date]SMALLDATETIMENO
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Modified_Date]SMALLDATETIMENO
[lng_Last_Modified_User_Id_Nmbr]INTNO

[tbl_Pax_Booking_Lifecycle]

Field

Data Type

NULLABLE

[lng_Pax_Booking_Lifecycle_Id_Nmbr]INT

NO

[str_Pax_Booking_Lifecycle_Code]VARCHAR (10)NO
[lng_Pax_Booking_Lifecycle_Minutes]INTNO
[str_Pax_Booking_Lifecycle_Type]CHAR 91)NO
[dtm_Creation_Date]DATETIME2NO
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Modified_Date]DATETIME2NO
[lng_Last_Modified_User_Id_Nmbr]INTNO