EN
Español
English
Português
    ASMS_STAR_RATING

    Represents the rating given by the user to a process

    Data model

    Fields

    Field Type Description
    comments NVARCHAR (1000) Rating Comment
    data NVARCHAR (MAX) Information about the process being scored
    date_created* DATETIME Record creation date
    id* INT Registry ID
    item_id* NVARCHAR (200) Identifier of the process being scored, case id, trackid of the conversation with the bot, among others
    item_type_id* INT Related item type
    origin* INT Place where the rating was made 1 -> teams, 2 whatsapp
    score* DECIMAL User-Rated Process
    user_id* INT It is the identifier of the user who scored the process

    Primary Key

    PK_ASMS_STAR_RATING
    id

    References

    Column Referenced Table Referenced column Name
    item_type_id* dbo.ASMS_TYPES id FK01_ASMS_STAR_RATING
    user_id* dbo.AFW_USERS user_id FK02_ASMS_STAR_RATING