Table that stores the data of the connections of the different chat users.
Data model
Fields
| Field |
Type |
Description |
| agentid |
INT |
Id of the agent connecting to the chat, Foreign Key AFW_CHAT_PERSON. Id |
| customparameters |
NVARCHAR (4000) |
Json containing additional connection data |
| enddate |
DATETIME |
Connection End Date |
| id* |
VARCHAR (200) |
Identify the user’s connection |
| projectclientid |
INT |
Id of the client connecting to the chat, Foreign key AFW_CHAT_PROJECT_CLIENT. Id |
| startdate* |
DATETIME |
Connection Start Date |
| status* |
INT |
Indicates whether the user’s connection is active, 0 - No, 1 - Yes. |
| urllocation |
NVARCHAR (4000) |
Url where the user makes the connection |
Primary Key
| PK_AFW_CHAT_CONNECTION |
| id |
References
