| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7INMDLROS_DET | Table for Model Roster Details(Time independent) | 2 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
2 | T7INMDLROS_DETT | Text table for Time independent Model Roster table | 3 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
3 | T7INMDL_RSTR | Time Dependent Model Roster table | 4 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
4 | T7INRSTR_CTGRY | Percentage assignment of reservation categories in Roster | 2 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
5 | T7INRSTR_GRP | Mapping between Roster and Groups of Posts | 2 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
6 | T7INRSTR_PT | Category assignemnt to each Roster Point in a model Roster | 2 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
7 | T7INRSTR_REG | Table for maintaining regions per roster | 2 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |
8 | T7INRSTR_SPL | Replacement Matrix for Mini / L-Shaped Roster | 2 | MDL_RSTR_DET_ID | Model Roster Detail IDs (Time independent) | nvarchar | 3 | 0 | | |