Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CriteriaExpression | Unknown | 0 | null |
|
|
Criteria expression - SQL WHERE clause or filter expression |
||
| CriteriaID | Unknown | 0 | null |
|
|
Primary key - DataSourceCriteria unique identifier for each criteria definition |
||
| CriteriaName | Unknown | 0 | null |
|
|
Criteria name - Name of the criteria or filter |
||
| fkDataSourceID | int | 4 | √ | null |
|
|
Data source reference - Reference to the data source |
|
| fkIncID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to Inc table for data relationships |
|
| IsDefault | Unknown | 0 | null |
|
|
Default flag - Whether this criteria is applied by default |
||
| pkDSCID | int identity | 4 | √ | null |
|
|
Primary key - DataSourceCriteria unique identifier for each record |
|
| OrderBy | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for DataSourceCriteria records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__DataSour__6F3AB82C7B3C2211 | Primary key | Asc | pkDSCID |