EN
Español
English
Português
    AFW_CHAT_MESSAGE

    A table that stores messages sent by chat users.

    Data model

    Fields

    Field Type Description
    fileid INT Attachment ID
    id* INT Unique identifier
    isagent* INT Indicates whether the message is sent by an agent, 0 - No, 1 - Yes.
    isfile INT Indicates whether the message is an attachment. 0 - N0, 1 - Yes.
    message* VARCHAR (MAX) Text of the message sent
    msgdate DATETIME Date the message was sent
    personid* INT User code sending the message
    sessionid* INT Session code to which the sent message belongs, Foreign Key AFW_CHAT_SESSION. Id
    viewed* INT Indicates whether the message has already been read. 0 - N0, 1 - Yes.

    Primary Key

    PK_AFW_CHAT_MESSAGE
    id

    References

    Column Referenced Table Referenced column Name
    sessionid* dbo.AFW_CHAT_SESSION id FK01_AFW_CHAT_MESSAGE