EN
Español
English
Português
    AFW_SURVEY_ANSWERS

    Table representing responses to an invitation sent to an end user

    Data model

    Fields

    Field Type Description
    id* INT Unique Response Identifier, Integer Type Primary Key
    questionid* INT Question ID, reference to the AFW_SURVEY_QUESTION.id table of integer type
    responsechoiceid* INT Identifier of the answer when the question is closed with the option to select one or more options, reference to the table AFW_SURVEY_QRESP_CHOICE.id of integer type
    responsevalue NVARCHAR (8000) Content of the answer when the question is open or closed if it is of the “Ranking” or “Mixed” type the question of the nvarchar type
    token* NVARCHAR (200) Unique identifier of the survey invitation generated and sent to the end-user of the integer type

    Primary Key

    PK_AFW_SURVEY_ANSWERS
    id

    References

    Column Referenced Table Referenced column Name
    questionid* dbo.AFW_SURVEY_QUESTION id FK_ANSWERS_QUESTION
    token* dbo.AFW_SURVEY_USER token FK_ANSWERS_SURVEY_USER