Surveys |
Store the surveys.
Name | Type | Description |
|---|---|---|
Id | INT [auto-generated] NOT NULL | ID of the survey |
Guid | UNIQUEIDENTIFIER NOT NULL | GUID of the survey |
Name | NVARCHAR(255) NOT NULL | Name of the survey |
Description | NVARCHAR(MAX) NULLABLE | Description of the survey |
State | INT NOT NULL | State of survey:
|
CreatedBy | INT FOREIGN KEY NOT NULL | Id of the user who has created the survey |
CreatedAt | DATETIME NOT NULL | Date of creation |
CreatedFrom | UNIQUEIDENTIFIER NOT NULL | GUID of the module that create the survey |
UpdatedBy | INT FOREIGN KEY NOT NULL | Id of the latest user who has updated the survey |
UpdatedAt | DATETIME NOT NULL | Date of the latest update |
UpdatedFrom | UNIQUEIDENTIFIER NOT NULL | GUID of the module that latest update the survey |
IsDeleted | BIT NOT NULL | Indicates if the survey is deleted |
DeletedBy | INT FOREIGN KEY NULLABLE | Id of the user who has deleted the survey |
DeletedAt | DATETIME NULLABLE | Date of deletion |
DeletedFrom | UNIQUEIDENTIFIER | GUID of the module that delete the survey |
See Also