chat_message table - SuperOffice

chat_message Table (333)

This table contains messages in a chat session.

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
session_id	The reference to the associated chat session.	FK chat_session	No
message	The message.	Clob	Yes
when_posted	When the message was posted (UTC timestamp).	DateTime	Yes
special_type	Enum indicating if it is a special message, such as an URL redirection, etc.	Enum ChatMessageSpecialType	Yes
special_param	Special parameter for the special_type.	String(255)	Yes
read_by_customer	Whether the message has been read by the customer or not.	Bool	Yes
type	The type of the message.	Enum ChatMessageType	Yes
author	The author of the message.	String(255)	Yes
created_by	The user agent who wrote the message. -1 if customer	FK ejuser	Yes

Indexes

Fields	Types	Description
session_id	FK	Index

Relationships

Table	Description
chat_session	This table contains chat sessions.
ejuser	This table contains entries for the users of the system.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Enum values for ChatMessageType Enum values for ChatMessageSpecialType Enum ChatMessageType Trigger chat_session table Enum ChatMessageSpecialType

⌘I