/
25.03 DB Schema Changes

25.03 DB Schema Changes

Added column(s)

tbl_Carriers

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Locator_Code]

VARCHAR (10)

YES

tbl_Ticket_Sales_Record

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[bit_Voided]

BIT

NO

Updated column(s)

tbl_SSM_Sequence_Nmbr

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Sequence_Address]

VARCHAR (128)

YES

Added table(s)

tbl_Custom_Charge_Type

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Custom_Charge_Type]

VARCHAR (5)

NO

[lng_Sort_Order]

INT

NO

[str_Desc]

VARCHAR (50)

NO

[dtm_Creation_Date]

SMALLDATETIME

NO

[lng_Creation_User_Id_Nmbr]

INT

NO

[dtm_Last_Mod_Date]

SMALLDATETIME

NO

[lng_Last_Mod_User_Id_Nmbr]

INT

NO

tbl_Seat_Allocation_Template_Audit

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_Seat_Allocation_Template_Audit_Id_Nmbr]

INT

NO

[lng_Seat_Allocation_Template_Header_Id_Nmbr]

INT

NO

[lng_Sked_Detail_Id_Nmbr]

INT

NO

[str_Flight_Nmbr]

VARCHAR (10)

NO

[str_Overwrite_Flag]

CHAR (1)

NO

[dtm_Creation_Date]

SMALLDATETIME

NO

[lng_Creation_User_Id_Nmbr]

INT

NO