Table representing the general configuration of the survey module
Data model
Fields
| Field | Type | Description |
|---|---|---|
| applicationid | INT | Identifier of the Aranda application that owns this configuration, reference to the AFW_APPLICATIONS.id table of integer type |
| externalmonitors | VARCHAR (MAX) | Text string that saves JSON arrangement with external user notification emails of type varchar |
| frecuencytype | INT | Period in which the measurement of the whole-type satisfaction surveys will be carried out |
| id* | INT | Unique identifier of the general configuration, primary key of integer type |
| internalmonitors | VARCHAR (MAX) | Text string that keeps internal user data in JSON format for reporting varchar surveys |
| projectid* | INT | The ID of the project (optional) that owns this integer configuration |
| satisfactionlevel | FLOAT | Minimum expected level of satisfaction (value between 1 and 10) in surveys when they have quantitative float questions |
Primary Key
| PK_CONFIGURATION |
|---|
| id |