chat_message Table (333)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains messages in a chat session.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| session_id | The reference to the associated chat session. | FK chat_session | |
| message | The message. | Clob | ● |
| when_posted | When the message was posted (UTC timestamp). | DateTime | ● |
| special_type | Enum indicating if it is a special message, such as an URL redirection, etc. | Enum ChatMessageSpecialType | ● |
| special_param | Special parameter for the special_type. | String(255) | ● |
| read_by_customer | Whether the message has been read by the customer or not. | Bool | ● |
| type | The type of the message. | Enum ChatMessageType | ● |
| author | The author of the message. | String(255) | ● |
| created_by | The user agent who wrote the message. -1 if customer | FK ejuser | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.