EN
Español
English
Português
    AFW_CHAT_PROJECT_CLIENT

    Table that associates customers to projects.

    Data model

    Fields

    Field Type Description
    active* INT Indicates whether the authorization is active, 0 - No, 1 - Yes
    id* INT Unique identifier
    personid* INT ID of the client user who will be authorized to request service in the project, Foreign key AFW_CHAT_PERSON. Id, composite key UX_AFW_CHAT_PROJECT_CLIENT
    projectid* INT Id of the project to which the customer may request service, Foreign key AFW_CHAT_PROJECT. Id, composite key UX_AFW_CHAT_PROJECT_CLIENT
    roleid* INT Role assigned to the customer, Composite key UX_AFW_CHAT_PROJECT_CLIENT

    Primary Key

    PK_AFW_CHAT_PROJECT_CLIENT
    id

    References

    Column Referenced Table Referenced column Name
    personid* dbo.AFW_CHAT_PERSON id FK02_AFW_PROJECT_CLIENT
    projectid* dbo.AFW_CHAT_PROJECT id FK01_AFW_PROJECT_CLIENT