Table representing the data metadata of a survey template
Data model
Fields
| Field | Type | Description |
|---|---|---|
| applicationid* | INT | Aranda App ID that owns this integer survey template |
| categoryid | INT | Integer Type Category Identifier |
| companyid | INT | Identifier of a company that can be associated with this integer survey template |
| conceptid | INT | Identifier of the business concept Integer type Aranda |
| createdby* | INT | Identifier of the user who created the integer survey template |
| creationdate* | DATETIME | Date of creation of the survey template of type datetime |
| description | NVARCHAR (4000) | Description of the survey that is visible to the nvarchar customer |
| enddate | DATETIME | End date when the survey is no longer available to datetime end users |
| exitpage | NVARCHAR (1000) | Option to add output page when nvarchar survey is answered |
| id* | INT | Unique identifier of the survey template is an integer primary key |
| isdeleted | INT | Determines whether the survey template is deleted (1) or not (0) of integer type |
| modificationdate | DATETIME | Date of update of the survey template of type datetime |
| modifiedby | INT | Identifier of the user who modified the integer survey template |
| name* | NVARCHAR (2000) | Survey title that is visible to the nvarchar customer |
| observations | NVARCHAR (200) | nvarchar Survey Template Supplemental Text |
| projectid | INT | Project ID that can be associated with this integer survey template |
| startdate | DATETIME | Start date when the survey is available to datetime end users |
| status* | INT | Determines whether the survey template is published (2) or not (3) of integer type |
| title* | NVARCHAR (2000) | Name of the survey template that is visible only within the nvarchar administration |
Primary Key
| PK_SURVEY |
|---|
| id |