/
19.12 DB Schema Changes
19.12 DB Schema Changes
- Thao Nguyen
- Kristian Luck
Owned by Thao Nguyen
| 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 |
Related content
19.10 DB Schema Changes
19.10 DB Schema Changes
More like this
19.04 DB Schema Changes
19.04 DB Schema Changes
More like this
24.03 DB Schema Changes
24.03 DB Schema Changes
More like this
23.08 DB Schema Changes
23.08 DB Schema Changes
More like this
20.03 DB Schema Changes
20.03 DB Schema Changes
More like this
20.09 DB Schema Changes
20.09 DB Schema Changes
More like this