EN
Español
English
Português
    AFW_CHAT_SESSION

    Table where the sessions created in the chat are saved.

    Data model

    Fields

    Field Type Description
    active* INT Indicates if the connection is active, 0 - No, 1 - Yes.
    agentchatuserid INT ID of the agent who creates the session
    comment VARCHAR (200) Message from the customer about the service received
    connectionidagent* VARCHAR (200) Id of the agent connected to the session, Foreign key, AFW_CHAT_CONNECTION. Id
    connectionidclient* VARCHAR (200) Client ID connected to the session, Foreign key, AFW_CHAT_CONNECTION. Id
    duration FLOAT Time in seconds that the session remained active
    id* INT Unique identifier
    isagentchat* INT Indicates if the chat session consists of two agents, 0 - No, 1 - Yes
    istransfer* INT Indicates whether the session was transferred from another agent, 0 - No, 1 - Yes
    score TINYINT Rating given by the client to the service provided by the agent, between 0 and 5

    Primary Key

    PK_AFW_CHAT_SESSION
    id

    References

    Column Referenced Table Referenced column Name
    connectionidagent* dbo.AFW_CHAT_CONNECTION id FK_AFW_CHAT_SESSION_AFW_CHAT_CONNECTION_AGENT
    connectionidclient* dbo.AFW_CHAT_CONNECTION id FK_AFW_CHAT_SESSION_AFW_CHAT_CONNECTION_CLIENT