Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each announcement |
|
| fkCommunicateID | int | 4 | √ | null |
|
|
Communication reference - Links to the base communication record |
|
| ToTeamIDs | varchar | 2147483647 | √ | null |
|
|
Target teams - Comma-separated list of team IDs that should receive this announcement |
|
| ToRoleIDs | varchar | 2147483647 | √ | null |
|
|
Target roles - Comma-separated list of role IDs that should receive this announcement |
|
| ToAllActiveUsers | bit | 1 | √ | null |
|
|
All users flag - Boolean indicating if the announcement should be sent to all active users |
|
| iCentralICommunicateId | int | 4 | √ | null |
|
|
iCentral communication ID - Reference to iCentral communication system for cross-system messaging |
|
| AnnouncementPriority | varchar | 100 | √ | null |
|
|
Priority level - Priority classification for the announcement (High, Medium, Low, Urgent) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Announce__3214EC277BF4D202 | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
