Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkiCommunicateStatusID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each communication status |
|
| statusName | varchar | 50 | √ | null |
|
|
Status name - Name of the communication status (e.g., ‘Draft’, ‘Sent’, ‘Read’, ‘Archived’) |
|
| actionName | varchar | 300 | √ | null |
|
|
Action name - Name of the action associated with this status for workflow processing |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_iCommunicateStatus | Primary key | Asc | pkiCommunicateStatusID |
Relationships
Close relationships within degrees of separation
