iCommunicateProperties


Description

Communication message properties - User-specific properties and status tracking for iCommunicate messages including read status, delivery tracking, and user-specific message management. This table manages per-user message states, system status updates, and group-based message distribution to support comprehensive internal communication workflows and message lifecycle management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkiCommunicatePropertiesID int identity 4 √ null

Properties primary key - Unique identifier for each message property record
fkCommunicateID int 4 √ null
iCommunicate.pkCommunicateID FK_iCommunicatePropertiesID_iCommunicate R

Message reference - Links to iCommunicate table for the associated message
fkUserID int 4 √ null
AccessUser.UserID FK_iCommunicatePropertiesID_accessuser R

User reference - Links to AccessUser table for the message recipient
fkSystemStatusID int 4 √ null

System status reference - Links to system status for message delivery tracking
DateSystemStatusUpdated datetime 16,3 √ null

Status update date - Date when the system status was last updated
DateRead datetime 16,3 √ null

Read date - Date and time when the user read the message
DateDeleted datetime 16,3 √ null

Deletion date - Date when the user deleted the message
fkGroupID int 4 √ null

Group reference - Links to group for group-based message distribution

Indexes

Constraint Name Type Sort Column(s)
PK_iCommunicatePropertiesID Primary key Asc pkiCommunicatePropertiesID

Relationships

Close relationships within degrees of separation