EN
Español
English
Português
    AFW_SURVEY_QUESTION

    Table representing the question that is part of a survey template

    Data model

    Fields

    Field Type Description
    choicemandatory* INT When the question type is true or false, you can choose whether to show the justification when you select Yes (1), No (8) or any option (-1) is integer
    createdby* INT Identifier of the user who created the question is integer
    creationdate* DATETIME Date the question was created is of type datetime
    helptext NVARCHAR (400) Complementary text to the question to guide the user who is going to answer it in nvarchar type
    id* INT Unique identifier of the question, it is a primary key of integer type
    includedtoreport* INT It applies to quantitative questions, where it is marked which questions should enter (1) or not (0) in the count and average level of satisfaction, this field is of integer type
    isdeleted INT Determines whether the question is deleted (1) or not (0) integer
    justificationlabel NVARCHAR (400) As you are enabled to request justification, this field stores the label of the question to request justification, it is of type nvarchar
    justificationmandatory* INT As you are enabled to request justification, this field registers whether or not that justification is mandatory, it is of integer type
    justificationrequired* INT It applies to quantitative, true or false or selection questions, where (1) or not (0) the option to fill out the answer is enabled, it is of the whole type
    mandatory* INT Determine whether (1) or not (0) is required nvarchar question
    maxvalue INT It applies to quantitative questions, where the numerical option is capped (between 2 and 10), it is of the whole type
    modificationdate DATETIME Date the question was updated is of type datetime
    modifiedby INT Identifier of the user who updated the question is integer
    questionorder* INT Order in which the fields in the integer survey template are presented
    questiontypeid* INT Identifier of the type of question it represents, reference to the AFW_SURVEY_QUESTION_TYPE.id table of integer type
    surveyid* INT Identifier of the survey template that is part of it, reference to the table AFW_SURVEY.id of integer type
    title* NVARCHAR (8000) Content of the nvarchar question

    Primary Key

    PK_AFW_QUESTION
    id

    References

    Column Referenced Table Referenced column Name
    questiontypeid* dbo.AFW_SURVEY_QUESTION_TYPE id FK_QUESTION_TYPE
    surveyid* dbo.AFW_SURVEY id FK_QUESTION_SURVEY