Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClientCaseRuleID | Unknown | 0 | null |
|
|
Primary key - ClientCaseRules unique identifier for each rule assignment |
||
| fkClientID | Unknown | 0 | null |
|
|
Client reference - Reference to the client |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this rule is currently applied to the client |
||
| pkClientRule | int identity | 4 | √ | null |
|
|
Data field - pkClientRule information for ClientCaseRules business operations |
|
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClientCaseRules | Primary key | Asc | pkClientRule |