Subject Area : 360 - Survey
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