20.04 DB Schema Changes

Owned by Thao Nguyen

Last updated: Apr 10, 2020

1 min read

Contents

Added Table(s)

[tbl_Pax_Gender]

Field1	Data Type	NULLABLE
[lng_Pax_Gender_Id]	INT	NO
[str_Gender_Code]	NVARCHAR (100)	NO
[str_Gender_Description]	NVARCHAR (100)	YES

[tbl_Pax_Gender_Prefix]

Field1	Data Type	NULLABLE
[lng_Pax_Gender_Prefix_Id]	INT	NO
[str_Gender_Prefix]	NVARCHAR (100)	NO
[str_Gender_Prefix_Abbreviation]	NVARCHAR (100)	NO
[str_Age_Category]	NVARCHAR (100)	NO
[lng_Pax_Gender_Id]	INT	YES

[tbl_Pax_Gender_Prefix_XRef]

Field1	Data Type	NULLABLE
[lng_Pax_Gender_Prefix_XRef_Id]	INT	NO
[lng_Pax_Id_Nmbr]	INT	NO
[lng_Pax_Gender_Prefix_Id]	INT	NO
[tsp_Timestamp]	ROWVERSION	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

[tbl_PseudoCity_Blacklist]

Field1	Data Type	NULLABLE
[lng_PseudoCity_Blacklist_Id]	INT	NO
[str_IATA_Nmbr]	VARCHAR (8)	NO
[str_Pseudo_City]	VARCHAR (9)	NO
[str_Agency_Name]	VARCHAR (50)	NO
[str_Description]	VARCHAR (50)	NO
[str_Status]	CHAR(1)	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

Modified Table(s)

[tbl_SSR_Definition]

Field	Data Type	NULLABLE
[str_Queue]	CHAR(1)	NO

[tbl_Seat_Assignment_Template_Header]

Field	Data Type	NULLABLE
[chr_Open_Seating]	CHAR (1)	NOT NULL

[tbl_Res_Header]

Field	Data Type	NULLABLE
[str_GDS_Group_Name]	VARCHAR (60)	NOT NULL

[tbl_Insurance_Provider]

Field	Data Type	NULLABLE
[bit_Can_Cancel]	BIT	NOT NULL
[bit_Can_Reserve]	BIT	NOT NULL

[tbl_Res_CheckIn]

Field	Data Type	NULLABLE
[lng_Seat_Assignment_Template_Header_Id_Nmbr]	INT	NOT NULL