| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInformation Consistency |
1 | SIC_NORM_ANORMRR | Attribute Normalization Rules: Rules | 4 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
2 | SIC_NORM_ANORMRV | Assignment of Variables in Attribute Normalizing Rules | 4 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
3 | SIC_NORM_CASECON | Rules for Case Conversion | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
4 | SIC_NORM_CASECOT | Descriptions for Rules for Case Conversion | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
5 | SIC_NORM_CONDRUR | Conditional Rules | 5 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
6 | SIC_NORM_CONDRUV | Variables Assignment of Conditional Rules | 5 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
7 | SIC_NORM_QUACON | Rules for Quantitiy Conversions (C_SIC_NORM_QUANTITIY_C...) | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
8 | SIC_NORM_QUACONR | Rules for Quantity Conversions | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
9 | SIC_NORM_QUACONT | Descriptions to Rules for Quantity Conversions | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
10 | SIC_NORM_REGEX | Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX) | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
11 | SIC_NORM_REGEXR | Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX) | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
12 | SIC_NORM_REGEXT | Descriptions for Regular Expressions | 3 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
13 | SIC_NORM_TOKEN0 | Rules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE) | 2 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
14 | SIC_NORM_TOKEN0R | Rules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE) | 2 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |
15 | SIC_NORM_TOKEN0T | Descriptions to Rules for Simple Tokenization | 2 | BASIC_RULE | Basic Normalizing Rule | nvarchar | 30 | 0 | | |