Table representing the invitation to answer a satisfaction survey
Data model
Fields
| Field |
Type |
Description |
| conceptitemid |
INT |
Optional identifier of the concept that can be associated with the survey (e.g., Case in ASMS or work order in AFLS) of integer type |
| creationdate |
DATETIME |
Date when the datetime invitation is registered |
| dataconcept |
NVARCHAR (MAX) |
Text that corresponds to a JSON object that can contain information related to the concept it refers to, for example the identifier of a case with title and description, this field is of type nvarchar |
| email |
NVARCHAR (200) |
Email to which a nvarchar survey invitation is sent |
| finishedat |
DATETIME |
Date that allows you to identify that the user has answered the datetime survey |
| id* |
INT |
Unique identifier of the survey invitation integer type primary key |
| invitationsent |
INT |
Flag that allows you to identify whether the invitation has already been sent or not (0 has not been sent, 1 has been sent) to the integer end user |
| surveyid* |
INT |
Identifier of the survey template associated with the integer invitation |
| token* |
NVARCHAR (200) |
Unique and unrepeatable code to identify the nvarchar invitation |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| surveyid* |
dbo.AFW_SURVEY |
id |
FK_SURVEY |
