24.03 DB Schema Changes

Added table(s)

tbl_Notification_Audit

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_Notification_Audit_Id_Nmbr]

INT

NO

[lng_Reservation_Nmbr]

INT

NO

[lng_Pax_Id_Nmbr]

INT

NO

[lng_Channel_Definition_Id]

INT

NO

[str_Contact_Info]

VARCHAR (255)

NO

[lng_Reservations_Alerts_Type_Id_Nmbr]

INT

NO

[str_Message]

NVARCHAR (MAX)

NO

[bit_Include_Itinerary]

BIT

NO

[lng_Audit_User_Id_Nmbr]

INT

NO

[dtm_Creation_Date]

SMALLDATETIME

YES

[lng_Creation_User_Id_Nmbr]

INT

NO

[dtm_Last_Mod_date]

SMALLDATETIME

YES

[lng_Last_Mod_User_Id_Nmbr]

INT

NO

Added column(s)

tbl_Res_ETicket_Assignments

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Fare_Calculation]

VARCHAR (271)

NO

tbl_Res_Passive_Legs

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Aircraft_Model_Code]

VARCHAR (7)

NO

tbl_Tickets

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Fare_Calculation]

VARCHAR (271)

NO

Modified column(s)

[tbl_Airport]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Ident]

VARCHAR (5)

NO