Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CriteriaExpression | Unknown | 0 | null |
|
|
Criteria expression - SQL or logical expression that defines the criteria |
||
| CriteriaID | Unknown | 0 | null |
|
|
Primary key - Criteria unique identifier for each criteria definition |
||
| CriteriaName | Unknown | 0 | null |
|
|
Criteria name - Descriptive name of the criteria |
||
| CriteriaType | Unknown | 0 | null |
|
|
Criteria type - Classification of the criteria (Filter, Search, Validation, etc.) |
||
| pkIncID | int identity | 4 | √ | null |
|
|
Primary key - Criteria unique identifier for each record |
|
| IncFileName | varchar | 100 | √ | null |
|
|
Name field - Descriptive name or identifier for Criteria records |
|
| IncFileFrontEndName | varchar | 50 | √ | null |
|
|
Name field - Descriptive name or identifier for Criteria records |
|
| IncFileMVCName | nvarchar | 1000 | √ | null |
|
|
Name field - Descriptive name or identifier for Criteria records |
|
| IsReusable | Unknown | 0 | null |
|
|
Reusable flag - Whether this criteria can be reused across multiple contexts |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Criteria__505BE8D359DB2E46 | Primary key | Asc | pkIncID |