/
20.04 DB Schema Changes
20.04 DB Schema Changes
- Thao Nguyen
Owned by Thao Nguyen
| 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 |
, multiple selections available,
Related content
20.06 DB Schema Changes
20.06 DB Schema Changes
More like this
20.09 DB Schema Changes
20.09 DB Schema Changes
More like this
20.08 DB Schema Changes
20.08 DB Schema Changes
More like this
22.05 DB Schema Changes
22.05 DB Schema Changes
More like this
19.10 DB Schema Changes
19.10 DB Schema Changes
More like this
24.08 DB Schema Changes
24.08 DB Schema Changes
More like this