Subject Area Name
|
Definition
|
360 - Survey
|
Additional tables used to support surveys.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Logical
|
Column
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
defn_ver
|
Definition Version
|
|
false
|
A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
defn_ver_id
|
Definition Version Id
|
The automatically generated primary key of the defn_ver table.
|
bigint
|
|
|
defn_ver_name
|
Definition Version Name
|
The name of the Definition Version.
|
nvarchar(4000)
|
|
|
defn_ver_status_id
|
Definition Version Status Id
|
A Foreign Key to the Definition Version Status table.
|
int
|
|
|
defn_ver_guid
|
Definition Version GUID
|
A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data.
|
varchar(50)
|
|
survey_sent
|
Survey Sent
|
|
false
|
A record of a survey sent to an application user.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
survey_sent_id
|
Survey Sent Id
|
The automatically generated primary key of the survey_sent table.
|
bigint
|
|
|
survey_sent_email
|
Survey Sent Email
|
Email address of recipient.
|
varchar(50)
|
|
|
date_sent
|
Date Sent
|
Date sent.
|
datetime
|
|
|
item_defn_id
|
Item Definition Id
|
A Foreign Key to the Definition Version table.
|
bigint
|