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 |