19.12 DB Schema Changes

Owned by Thao Nguyen

Last updated: Nov 25, 2019 by Kristian Luck

1 min read

Contents

Added Field(s)

[tbl_Flight_PNL_Status]

Field1	Data Type	NULLABLE
lng_Last_Send_Minutes_Prior	INT	NO

New Tables

[tbl_Communication_Channel_Definition]

Field1	Data Type	NULLABLE
lng_Channel_Definition_Id	INT	NO
str_Channel_Ident	VARCHAR (255)	NO
str_Channel_Name	NVARCHAR (255)	NO
str_Channel_Settings	VARCHAR (MAX)	NO
bit_Channel_Active	BIT	NO
tsp_Timestamp	ROWVERSION	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_Communication_Channel_XRef]

Field1	Data Type	NULLABLE
lng_Channel_XRef_Id	INT	NO
lng_Reservation_Nmbr	INT	NO
lng_Pax_Id_Nmbr	INT	NO
lng_User_Profile_Id_Nmbr	INT	NO
tsp_Timestamp	ROWVERSION	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