GeneralMessage


Description

System-wide messaging - General messaging system for broadcasting announcements, alerts, and notifications to healthcare system users. This table manages system messages, billing-specific communications, and administrative announcements to support organizational communication, user notifications, and system-wide information distribution.

Columns

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

Message primary key - Unique identifier for each general message
Title varchar 50 √ null

Message title - Title or subject line of the message
Message varchar 500 √ null

Message content - Full text content of the message
BillingTypeid int 4 √ null

Billing type reference - Links to billing type for billing-specific messages
DateCreated datetime 16,3 √ (getdate())

Creation date - Date and time when the message was created

Indexes

Constraint Name Type Sort Column(s)
PK__GeneralMessage__3D5E1FD2 Primary key Asc MsgID

Relationships

Close relationships within degrees of separation