19.04 DB Schema Changes
- Nicolas Maillet (Unlicensed)
- Kenny Duffy
Owned by Nicolas Maillet (Unlicensed)
[tbl_Level_of_Service]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Level_of_Service_Rank] | INT | NO |
[tbl_FareHeader_GLSurcharge_Connecting_XRef]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_FareHeader_GLSurcharge_Connecting_Id_Nmbr] | INT | NO |
| [lng_FareHeader_GLSurcharge_Id_Nmbr] | INT | NO |
| [lng_Airport_Id_Nmbr] | 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_FareHeader_GLSurcharge_Non_Applicable_XRef]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_FareHeader_GLSurcharge_Non_Applicable_XRef_Id_Nmbr] | INT | NO |
| [lng_FareHeader_GLSurcharge_Id_Nmbr] | INT | NO |
| [lng_Fare_Class_Id_Nmbr] | 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_User_Settings]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_User_Setting_Id_Nmbr] | INT | NO |
| [lng_User_Id_Nmbr] | INT | NO |
| [str_Setting_Category] | VARCHAR (50) | NO |
| [str_Setting_Name] | VARCHAR (100) | NO |
| [str_Setting_Value] | VARCHAR (50) | 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 |