20.01 DB Schema Changes
- Thao Nguyen
Owned by Thao Nguyen
| Contents |
|---|
New Tables
[tbl_Agency_Free_Penalty_Limits]
Field1 | Data Type | NULLABLE |
|---|---|---|
| [lng_Agency_Free_Penalty_Limits_Id_Nmbr] | INT | NO |
| [lng_Agency_Id_Nmbr] | INT | NO |
| [str_Penalty_Fee_Type] | char(1) | NO |
| [str_Reset_Apply_Flag] | char(1) | NO |
| [dtm_Reset_Date] | SMALLDATETIME | NO |
| [lng_Free_Limit] | INT | NO |
| [lng_Free_Used] | INT | |
| [tsp_Timestamp] | ROWVERSION | |
| 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_Agency_Free_Penalty_Tracking]
Field1 | Data Type | NULLABLE |
|---|---|---|
| [lng_Agency_Free_Penalty_Tracking_Id_Nmbr] | INT | NO |
| [lng_Agency_Id_Nmbr] | INT | NO |
| [str_Penalty_Fee_Type] | CHAR(1) | NO |
| [lng_Res_Legs_Id_Nmbr] | INT | NO |
| tsp_Timestamp | ROWVERSION | NO |
| dtm_Creation_Date | SMALLDATETIME | NO |
| lng_Creation_User_Id_Nmbr | INT | NO |
[tbl_Fare_Class_Penalty_Applicability]
Field1 | Data Type | NULLABLE |
|---|---|---|
| [lng_Fare_Class_Penalty_Applicability_Id_Nmbr] | INT | NO |
| [lng_Fare_Class_Id_Nmbr] | INT | NO |
| [str_Penalty_Fee_Type] | CHAR(1) | NO |
| [str_Book_After_Apply_Flag] | CHAR(1) | NO |
| [lng_Book_After] | INT | |
| [str_Travel_Prior_Apply_Flag] | CHAR(1) | |
| [lng_Travel_Prior] | INT | |
| 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 |