EN
Español
English
Português
    AFW_CHAT_PROJECT_AGENT

    Agent authorization table in projects.

    Data model

    Fields

    Field Type Description
    active* INT Indicates whether the authorization is active, 0 - No, 1 - Yes
    id* INT Unique identifier
    levelattention* INT Authorized level of care for the agent
    personid* INT ID of the agent user who will be authorized to provide service in the project, Foreign key AFW_CHAT_PERSON. Id
    projectid* INT Id of the project that the agent will be able to service, Foreign Key AFW_CHAT_PROJECT. Id

    Primary Key

    PK_AFW_CHAT_PROJECT_AGENT
    id

    References

    Column Referenced Table Referenced column Name
    personid* dbo.AFW_CHAT_PERSON id FK02_AFW_CHAT_PROJECT_AGENT
    projectid* dbo.AFW_CHAT_PROJECT id FK01_AFW_CHAT_PROJECT_AGENT