Subject Area : 360 - Survey
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 360 - Survey Additional tables used to support surveys. Details.. Details..
ER Diagram(s) of Subject Area "360 - Survey"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "360 - Survey"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 2
. 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. Details..
. survey_sent Survey Sent false A record of a survey sent to an application user. Details..
Attribute/Column(s) of Entity/Table "Definition Version"
# Physical Name Name Definition Physical Data Type
Total 5
. 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)
Attribute/Column(s) of Entity/Table "Survey Sent"
# Physical Name Name Definition Physical Data Type
Total 4
. 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