Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| IsConstant | Unknown | 0 | null |
|
|
Constant flag - Whether this value is a constant or can be modified |
|||||
| pkCaseRuleValID | int identity | 4 | √ | null |
|
|
Primary key - CaseRuleValues unique identifier for each record |
||||
| caseRuleValName | varchar | 50 | √ | null |
|
|
Name field - Descriptive name or identifier for CaseRuleValues records |
||||
| caseRuleValColumn | varchar | 50 | √ | null |
|
|
Text field - caseRuleValColumn text information for CaseRuleValues records |
||||
| ValueData | Unknown | 0 | null |
|
|
Value data - The actual value or data content |
|||||
| ValueID | Unknown | 0 | null |
|
|
Primary key - CaseRuleValues unique identifier for each rule value |
|||||
| ValueName | Unknown | 0 | null |
|
|
Value name - Descriptive name of the value or parameter |
|||||
| ValueType | Unknown | 0 | null |
|
|
Value type - Data type of the value (String, Number, Date, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CaseRuleValues | Primary key | Asc | pkCaseRuleValID |