Message table - SuperOffice

Message Table (242)

Definition of a message, corresponding to the header of a protocol

Fields

Name	Description	Type	Nullable
Message_id	Primary key	PK	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
associateId	The associate that is the target of this message	FK associate	No
onlineapp_id	The online app that owns this message	FK OnlineApp	No
systemMessageId	Message identifier, used for message update or removal	String(255)	No
markdownMessage	Markdown message to be displayed to user	String(4000)	No
expire	The date and time the message expires	UtcDateTime	No
type	Type of message, example: info, warning, error	Enum SystemMessageType	No

Message table relationship diagram

Indexes

Fields	Types	Description
associateId, systemMessageId, onlineapp_id	FK, String(255), FK	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
OnlineApp	Echo and track information about Online Apps and their usage

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ej_message table chat_message table outgoing_message table System Messages Send Messages Send Messages With Config

⌘I