EN
Español
English
Português
    ASMS_SURVEY

    Represents survey settings

    Data model

    Fields

    Field Type Description
    canceled_status_id INT Model state identifier, which determines the state where the survey ends
    description NVARCHAR (500) Description of the survey
    id* INT Survey ID
    is_active BIT Determine whether the survey is active or not
    item_type_id* INT Concept ID for the survey
    model_id INT Associated model identifier
    name* NVARCHAR (100) Survey Name
    project_id INT Survey Project ID
    schedule_id INT Identifier of the associated connection schedule
    server_id INT Mail server ID for sending the survey
    solved_status_id INT The status identifier of the model, which determines the state where the survey starts
    survey_id INT Base Survey Identifier
    template_id INT Identifier of the email template to send the survey

    Primary Key

    PK_ASMS_SURVEY
    id

    References

    Column Referenced Table Referenced column Name
    canceled_status_id dbo.ASMS_STATUS stat_id FK03_ASMS_SURVEY
    item_type_id* dbo.ASMS_TYPES id FK07_ASMS_SURVEY
    model_id dbo.ASMS_MODEL id FK01_ASMS_SURVEY
    project_id dbo.ASMS_PROJECTS proj_id FK08_ASMS_SURVEY
    schedule_id Bod. AFW_SCHEDULER sche_id FK04_ASMS_SURVEY
    server_id Bod. AFW_MAIL_ACCOUNT maac_id FK09_ASMS_SURVEY
    solved_status_id dbo.ASMS_STATUS stat_id FK02_ASMS_SURVEY
    survey_id dbo.AFW_SURVEY id FK05_ASMS_SURVEY
    template_id dbo.ASMS_MAIL_TEMPLATE id FK06_ASMS_SURVEY