Subject Area : 360 - Survey |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 360 - Survey | Additional tables used to support surveys. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | 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.. |
# | 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) |
# | 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 |