Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CaseRuleValueID | Unknown | 0 | null |
|
|
Primary key - CaseRuleInValue unique identifier for each rule-value association |
|||||
| pkCRVID | int identity | 4 | √ | null |
|
|
Primary key - CaseRuleInValue unique identifier for each record |
||||
| fkCaseRuleID | int | 4 | √ | null |
|
|
Case rule reference - Reference to the business rule |
||||
| fkCaseRuleValID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to CaseRuleVal table for data relationships |
||||
| fkValueID | Unknown | 0 | null |
|
|
Value reference - Reference to the associated value or parameter |
|||||
| ValueType | Unknown | 0 | null |
|
|
Value type - Type of value (Constant, Variable, Lookup, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CaseRuleInValue | Primary key | Asc | pkCRVID |