Table that stores emails sent by chat users.
Data model
Fields
| Field |
Type |
Description |
| assignedtoid |
INT |
ID of the agent to whom the case is assigned. Foreign key AFW_CHAT_PERSON. Id |
| creationdate* |
DATETIME |
Email creation date |
| email* |
VARCHAR (200) |
Email of the sending user |
| id* |
INT |
Unique identifier |
| message* |
VARCHAR (MAX) |
Email Message |
| name* |
VARCHAR (100) |
Name of the contact person sending the email |
| personid* |
INT |
Id of the user who sends the Email, Foreign Key AFW_CHAT_PROJECT_CLIENT. Id |
| subject* |
VARCHAR (400) |
Email Subject |
| viewed* |
INT |
Indicates whether the email has already been read by the assigned agent. 0 - No, 1 - Yes |
Primary Key
| PK_AFW_CHAT_MESSAGE_MAIL |
| id |
References
