Message


Description

Internal messaging system - Communication platform for internal messages, notifications, and correspondence between healthcare system users. This table manages message content, delivery status, priority levels, and reply threading to support secure internal communication, task notifications, and collaborative workflows within the healthcare organization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
MessageID int identity 4 √ null
Message.ReplyTo FK_Message_Message R

Message primary key - Unique identifier for each message
Recipient int 4 √ null
AccessUser.UserID FK_Message_AccessUser R

Recipient user - UserID of the message recipient
Reciever int 4 √ null

Receiver user - Alternative receiver field (legacy spelling)
Subject varchar 100 √ null

Message subject - Subject line or title of the message
DateSent datetime 16,3 √ (getdate())

Send date - Date and time when the message was sent
Status char 10 √ null

Message status - Delivery and read status of the message
Priority char 10 √ null

Message priority - Priority level (High, Normal, Low) for message handling
Body text 2147483647 √ null

Message content - Full text content of the message
ReplyTo int 4 √ null
Message.MessageID FK_Message_Message R

Reply reference - Links to original message if this is a reply

Indexes

Constraint Name Type Sort Column(s)
PK_Message Primary key Asc MessageID

Relationships

Close relationships within degrees of separation