| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | WGDSC_TI_ID_TYPE | table of trade item types | 2 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
2 | WGDSC_TI_ID_TY_T | Texts for trade item types | 2 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
3 | WGDS_D_MSG_ITEM | Items of a message | 4 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
4 | WGDS_D_TI_ERROR | Errors of Trade Item | 4 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
5 | WGDS_FISCHCATZON | Fish Catch zone details table | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
6 | WGDS_INSRCANIMAL | Ingredient Source Animal Details | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
7 | WGDS_TI_ALLERGEN | Pricat Storage for TI related Allergen Information | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
8 | WGDS_TI_ATTRIBUT | Pricat Storage for TI related Attributes | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
9 | WGDS_TI_INGREDIE | Pricat Storage for TI related Ingredient Information | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
10 | WGDS_TI_ITEM | Pricat Storage for TI related Simple Attributes | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
11 | WGDS_TI_NUTRIENT | Pricat Storage for TI related Nutrient Information | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
12 | WGDS_TI_PAC_MARK | contains all package marks | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |
13 | WGDS_TI_PREPARAT | Pricat Storage for TI related Preparation Information | 3 | TI_ID_TYPE | Type of Trade Item ID | nvarchar | 2 | 0 | | |