SUR_ITEM
Contents
1. classapps SelectSurveyASP Advanced Database Model Overview SUR_EMAIL_ADDRESS SUR_EMAIL_LIST SUR_EMAIL_MESSAGE SUR EMAIL SENT HISTORY SUR HIDDEN FIELD SUR ID GENERATION SUR IP ADDRESS SUR ITEM SUR ITEM ANSWER SUR ITEM ANSWER GROUP SUR ITEM TYPE SUR LIBRARY SUR LIBRARY TO ITEM MAPPING SUR OPERATOR SUR PAGE SUR PAGE CONDITION SUR FILTER SUR REPORT SHARE SUR RESPONSE SUR RESPONSE ANSWER SUR RESPONSE HIDDEN FIELD SUR ROLE SUR SUBITEM SUR SURVEY SUR SURVEY TO ITEM MAPPING SUR TEMPLATE SUR USER SUR USER TO ROLE MAPPING 0 AN NAA Ga amp R ND 4 co o o o bo N O O NOQA R NDB classapps Overview SelectSurveyASP uses a clean well designed relational database model The same data model is used for Microsoft Access SQL Server and MySQL databases All tables in the application have a prefix of SUR_ Having this prefix makes it very easy to install the tables in an existing database and to distinguish them from all other tables For all tables that have a single column defined as the primary key the naming convention used is the name of the table with the SUR_ prefix plus a suffix of ID Thus the SUR_SURVEY table has a primary key of SURVEY_ID and the SUR_EMAIL_ADDRESS table has a primary key of EMAIL ADDRESS 10 Foreign keys use the same naming convention as primary keys Therefore in all tables fo2. Foreign key to the SUR OPERATOR table 10 classa pps ANSWER Foreign key to the SUR ITEM ANSWER table representing the answer that this page condition is using for a filter ANSWER TEXT The text that is being used for the answer when applying this page condition to this item SUR REPORT FILTER This page contains report filters that are optionally used for filtering report data in the reporting section SUR W REPORT FILTER ID 2 SURVEY ID int init FILTER varchar FILTERED ITEM ID int USER ATTRIBUTE TYPE varchar START datetime rj datetime OPERATOR FIRST varchar OPERATOR SECOND varchar SUBITEM ID int ANSWER ID char ANSWER TEXT varchar 2 ACTIVE char ORDER NUMBER int SASS SSS PSAs REPORT FILTER ID Numeric primary key for this table SURVEY 10 Foreign key to the SUR SURVEY table USER 10 Foreign key to the SUR USER table FILTER TYPE The type of filter question date user attribute FILTERED ITEM 1 Foreign key to the SUR ITEM table representing the item that is being filtered on USER ATTRIBUTE TYPE For user attribute filters the specific user attribute START DATE For date filters the start date to filter on END DATE For date filters the end date to filter on OPERATOR FIRST The first part of the operator used to construct the report filter
3. OPERATOR SECOND The second part of the operator used to construct the report filter SUBITEM Foreign key to the SUR SUBITEM table representing the subitem that is being filtered on ANSWER 10 Foreign key to the SUR ITEM ANSWER table representing the answer that is being filtered on OTHER YN A flag indicating whether or not ANSWER TEXT The text of the answer that is being filtered on ACTIVE flag indicating whether or not this report filter is active ORDER NUMBER The numeric sequence number of this particular filter in the list of filters for the particular survey 11 classapps SUR REPORT SHARE This table contains report shares which are used for sharing data with others based on email addresses and granular permissions SUR REPURT SHARE _Golanntiene DataType Length ow Nuls W REPORT SHARE ID int 2 SURVEY ID I CREATED DATE smalldatetime REPORT SHARE URL ID warchar EMAIL ADDRESSES text LAST SENT DATE datetime EXPORT char REPORT FILTERIMG YN char EN VIEWABLE REPORTS varchar VIEW OPEM ENDED YM char 2 ACTIVE char REPORT SHARE 10 Numeric primary key for this table SURVEY 10 Foreign key to the SUR SURVEY table CREATED DATE The date the report share was created REPORT SHARE URL ID The unique encrypted ID that is used to represent this report share to a user EMAIL ADDRESSES The email address es that this
4. ITEM ANSWER GROUP o Cumae Leth Alo nas ITEM ANSWER GROUP ID ink mE ITEM AMSWER GROUP varchar varchar 2 ANSWER 2 varchar 2 ANSWER 3 varchar 2 ANSWER 4 varchar 2 ANSWER 5 varchar ITEM ANSWER GROUP Numeric primary key for this table ITEM ANSWER GROUP NAME The name of the answer group used for display purposes on the item page ANSWER 1 The second answer within an answer group ANSWER 2 The second answer within an answer group ANSWER 3 The second answer within an answer group ANSWER 4 The second answer within an answer group ANSWER 5 The second answer within an answer group SUR ITEM TYPE This table contains a list of all item types used in the application SUR ITEM TYPE teummeme Bata Type lengh Aew Nas S ITEM TYPE ID int TEM TYPE MAME varchar 2 QUESTION char ITEM TYPE ID Numeric primary key for this table ITEM TYPE NAME The name of the item type QUESTION YN A flag indicating whether or not this item is a question where a question is defined as an item that can receive a response SUR LIBRARY This table contains information about all libraries classapps SUR_LIBRARY teumeme Bata Type teeth Alow Nas ILIBRARY ID int 2 ACTIVE char LIBRARY varchar x int CREATED DATE datetime char LIBRARY 1 Numeric primary key for this table ACTIVE flag indicating whethe
5. SECOND The ending IP address in the IP range SUR ITEM This table contains data about each item question SUR ITEM ats Tre _ leng ow us ITEM TYPE ID ITEM SUB TEXT HTEM ALIAS REQUIRED RANMDOM ANSWER ORDER EMAIL ADDRESS 2 OTHER TEXT OTHER DISPLAY TYPE MAXIMLIM LENGTH 2 MINIMUM VALLIE MAXIMLIM VALLIE 2 ANSWER TOTAL MINIMUM_NUMBER_RESPONSES M amp XIMUM_NUMBER_RESPONSES ROW TEXT WIDTH DISPLAY FORMAT 2 DEFALILT VALLIE HMAGE PATH WIDTH HMAGE HEIGHT IMAGE ALIGNMENT 2 DATABASE SQL DATABASE int int text text text char char char char varchar varchar int varchar varchar int int int int varchar text varchar varchar varchar varchar text varchar classapps 5555555555 5555555 SUBITEM COLINT int ITEM ID Numeric primary key for this table ITEM TYPE ID Foreign key to the SUR ITEM TYPE table ITEM TEXT The actual text of the question item ITEM SUB TEXT The sub text of the question item which is the text that appears in smaller font just below the text ITEM ALIAS The alias for the question which is used for reporting and data export REQUIRED YN A flag indicating whether or not this question is required RANDOM ANSWER ORDER YN flag indicating whether or not the answers to this question should be displayed in rand
6. SECOND COLOR The background color of alternating rows in the matrix starting with the second row PROGRESS FIRST COLOR The background color of the progress bar PROGRESS SECOND COLOR The color used within the progress bar to display the amount of progress SURVEY NAME FONT COLOR The font color for the survey name SURVEY NAME FONT SIZE The font size for the survey name SURVEY NAME FONT WEIGHT The font weight for the survey name SURVEY NAME FONT FAMILY The font family for the survey name PAGE TITLE FONT COLOR The font color for the page title PAGE TITLE FONT SIZE The font size for the page title PAGE TITLE FONT WEIGHT The font weight for the page title PAGE TITLE FONT FAMILY The font family for the page title PAGE NUMBER FONT COLOR The font color for the page number PAGE NUMBER FONT SIZE The font size for the page number PAGE NUMBER FONT WEIGHT The font weight for the page number PAGE NUMBER FONT FAMILY The font family for the page number QUESTION TEXT FONT COLOR The font color for the question text QUESTION TEXT FONT SIZE The font size for the question text QUESTION TEXT FONT WEIGHT The font weight for the question text QUESTION TEXT FONT FAMILY The font family for the question text QUESTION SUBTEXT FONT COLOR The font color for the question subtext QUESTION SUBTEXT FONT SIZE The font size for the question subtext QUESTION SUBTEXT FONT WEIGHT The font weight for the question
7. email addresses are marked for deletion rather than actually deleted so that the email history functionality works correctly SUR EMAIL LIST This table contains information about each email list SUR EMAIL LIST LL cumteme Osta Type Leth lw Na EMAIL LIST ID int int 2 LIST NAME varchar LIST DESCRIPTION text CREATED_DATE datetime DEFAULT varchar EMAIL ADDRESS COUNT int EMAIL LIST ID Numeric primary key for this table USER ID Foreign key to the SUR USER table LIST NAME The name of the email list LIST DESCRIPTION A description of the email list CREATED DATE The date the email list was created DEFAULT YN A flag indicating whether or not this is the user s default email list EMAIL ADDRESS COUNT The number of email addresses in this list SUR EMAIL MESSAGE This table contains messages sent to email lists SUR _ MESSAGE LL cma Date Type Lenoth low ads W EMAIL MESSAGE ID EMAIL LIST ID EMAIL SUBJECT varchar EMAIL BODY text EMAIL CC ADDRESSES ADDRESSES text EMAIL FROM ADDRESS varchar E varchar 2 SURVEY ID int 2 SENT DATE datetime EMAIL SENT COUNT int EMAIL RESPONSE COUNT int EMAIL MESSAGE 10 Numeric primary key for this table EMAIL LIST ID Foreign key to the SUR EMAIL LIST table EMAIL SUBJECT The subject of the email assapps EMAIL BODY The
8. subtext QUESTION SUBTEXT FONT FAMILY The font family for the question subtext NAVIGATION LINK FONT COLOR The font color for the navigation links NAVIGATION LINK FONT SIZE The font size for the navigation links NAVIGATION LINK FONT WEIGHT The font weight for the navigation links NAVIGATION LINK FONT FAMILY The font family for the navigation links HTML TOP The HTML to display above the survey HTML BOTTOM The HTML to display below the survey NAVIGATION BACK BUTTON PATH The relative path to the Back button NAVIGATION BACK LINK TEXT The text to use as a link for the Back button NAVIGATION NEXT BUTTON PATH The relative path to the Next button 19 classa pps NAVIGATION NEXT LINK TEXT The text to use as a link for the Next button NAVIGATION CANCEL BUTTON PATH The relative path to the Cancel button NAVIGATION CANCEL LINK TEXT The text to use as a link for the Cancel button NAVIGATION DONE BUTTON PATH The relative path to the Done button NAVIGATION DONE LINK TEXT The text to use as a link for the Done button SUR USER This table contains all user information SUR USER DataType Length Allow Nuls int 4 varchar REGISTER DATE datetime USER PASSWORD varchar PASSWORD HINT varchar 5 NAME varchar LAST NAME varchar EMAIL ADDRESS varchar CURRENT POSITION varchar varchar varchar CUSTOM DATA 1 varchar CUSTOM DATA 2 varchar C
9. DDRESS The IP address of the respondent COMPLETED YN A flag indicating whether or not the respondent completed the entire survey SUR RESPONSE ANSWER This table contains each answer to each question submitted in response to a survey SUR RESPONSE ANSWER L Sommens Data Type tenth Alow Nas RESPONSE ID int int SUBITEM ID int ANSWER ID int ANSWER _TEXT text OTHER_TEXT text RESPONSE Numeric primary key for this table ITEM ID Foreign key to the SUR ITEM table representing the item that was answered SUBITEM Foreign key to the SUR SUBITEM table representing the subitem that was answered ANSWER 10 Foreign key to the SUR ITEM ANSWER representing the answer that was selected ANSWER TEXT The actual text of the answer for this particular question OTHER TEXT For other questions the actual text of the answer for the other question SUR RESPONSE HIDDEN FIELD This table contains all submitted values for hidden fields 13 classapps SUR_RESPONSE HIDDEN FIELD LL teumeme vata Type engh Howmas 2 w HIDDEM FIELD ID int RESPONSE ID int ANSWER TEXT varchar HIDDEN FIELD ID Numeric primary key for this table RESPONSE Foreign key to the SUR RESPONSE table representing the response to which this hidden field value is associated ANSWER TEXT The value contained within the hidden field SUR ROLE This table contains a list
10. ELD S HIDDEN FIELD ID int 2 SURVEY ID int mE ORDER int HIDDEM FIELD varchar E HIDDEM FIELD KEY varchar ES HIDDEM FIELD DISPLAY varchar HIDDEN FIELD ID Numeric primary key for this table SURVEY 10 Foreign key to the SUR SURVEY table classa pps ORDER NUMBER The numeric order of this hidden field for displaying in the desired order HIDDEN FIELD TYPE The hidden field type querystring session or cookie HIDDEN FIELD KEY The key for the hidden field HIDDEN FIELD DISPLAY NAME The display name for the hidden field SUR ID GENERATION This table is used as a sequencer to generate numeric primary keys for other tables Note that a few tables in the application use IDENTITY columns SUR ID GENER ATION L teumeme Data Type lerah Alw wus MEXT AVAILABLE ID int varchar NEXT AVAILABLE 10 The next available numeric ID for this sequence NAME The name of the sequence for generating primary keys SUR IP ADDRESS This table contains IP addresses that are optionally used for IP address validation for surveys SUR ADDRESS DataType _ Leath lw Na ADDRESS ID int 2 SURVEY ID int HP ADDRESS FIRST varchar P ADDRESS SECOND varchar IP ADDRESS Numeric primary key for this table SURVEY 10 Foreign key to the SUR SURVEY table IP ADDRESS FIRST The beginning IP address in the IP range IP ADDRESS
11. EPORTS EN RESPONSE EMAIL ADDRESSES m SURVEY REPORT SHARING ENABLED REPORT SECURITY HIGHLIGHT RESPONSES E EMAIL ADDREESS i RESPONSES LISER m MODIFY SURVEY WITHIN Day s RESPONDENT ACCESS LEVEL PAGE NUMBERING FORMAT I QUESTION NUMBERING FORMAT BACE BUTTON DISPLAY I CANCEL BUTTON DISPLAY m CANCEL BUTTON REDIRECT URL int varchar int datetime datetime datetime datetime datetime int int varchar text varchar char char char text varchar varchar char varchar char text varchar int int int varchar varchar varchar varchar varchar d ce coc coro co E SURVEY 1 Numeric primary key for this table TITLE The title of the survey TEMPLATE Foreign key to the SUR TEMPLATE representing the template this is associated with this survey CLOSED DATE The date the survey was closed CREATED DATE The date the survey was created LAUNCHED DATE The date the survey was launched 15 classa pps START DATE The scheduled start date of the survey END DATE The scheduled end date of the survey MAXIMUM RESPONSES FOR SURVEY The maximum number of responses that can be received for this survey RESPONSE COUNT The number of responses received for this survey COMPLETION ACTION Action to take upon completion of the survey SURVEY COMPLETE MESSAGE If the completion action includes displaying a me
12. USTOM DATA 3 varchar 2 ACTIVE char SSSA Ss USER Numeric primary key for this table USERNAME The username for this user REGISTER DATE The date this user registered USER_PASSWORD The user s password PASSWORD HINT A hint for the user s password FIRST NAME The first name of the user LAST NAME The last name of the user EMAIL ADDRESS The user s email address CURRENT POSITION The user s current position COMPANY The user s company LOCATION The user s location CUSTOM DATA 1 The first custom data field that can optionally be associated with this user CUSTOM DATA 2 The second custom data field that can optionally be associated with this user CUSTOM DATA 3 The third custom data field that can optionally be associated with this user ACTIVE YN A flag indicating whether or not this user is active SUR USER TO ROLE MAPPING This table maps users to roles 20 classapps SUR_USER_TO_ROLE_MAPPING Date Type USER ID Foreign key to the SUR USER table and part of the compound primary key for this table ROLE 10 Foreign key to the SUR ROLE table and part of the compound primary key for this table 21
13. body of the email EMAIL CC ADDRESSES The email addresses on the email s CC list EMAIL BCC ADDRESSES The email addresses on the email s BCC list EMAIL FROM ADDRESS The email address the email was sent from HTML YN A flag indicating whether or not the email was HTML SURVEY Foreign key to the SUR SURVEY table SENT DATE The date the message was sent EMAIL SENT COUNT The number of emails sent for this message EMAIL RESPONSE COUNT The number of responses to this message via the emails sent out SUR EMAIL SENT HISTORY This table contains a list of all individual emails sent out to email lists SUR EMAIL SENT HISTORY LL DataType _ length ow nus Sf EMAIL SENT HISTORY ID i I EMAIL ADDRESS ID int EMAIL MESSAGE ID int 2 URL UNIQUE ID varchar RESPONSE DATE datetime RESPONSE ID int m CURRENT STATLIS varchar EMAIL SENT HISTORY ID Numeric primary key for this table EMAIL ADDRESS Foreign key to the SUR EMAIL ADDRESS table EMAIL MESSAGE Foreign key to the SUR EMAIL MESSAGE table URL UNIQUE 1 The encrypted ID for accessing this survey via the email RESPONSE DATE The date for a response to this email invitation RESPONSE Foreign key to the SUR RESPONSE table CURRENT STATUS The current status of the email invitation SUR HIDDEN FIELD This table contains hidden fields that are optionally associated with surveys SUR FI
14. char varchar varchar ink varchar varchar varchar int varchar varchar varchar ink varchar varchar text text varchar varchar varchar varchar varchar varchar varchar varchar B TEES RETE E RETE ER RE 18 4 4 KIRA SASS lt lt 4 4 MX lt lt 42484 4 4 414 44 classapps TEMPLATE_ID Numeric primary key for this table ACTIVE YN A flag indicating whether or not this template is active TEMPLATE NAME The name of the template USER ID Foreign key to the SUR USER table representing the user who owns this template ALLOW USE YN A flag indicating whether or not users other than the owner can use this template LOGO PATH The path to the logo used by this template LOGO ALIGNMENT The alignment of the logo on the page SURVEY ALIGNMENT The alignment of the survey within the web browser DISPLAY BORDER YN A flag indicating whether or not a border should be displayed around the survey BORDER COLOR The color of the border if one is displayed BORDER WIDTH The width of the border if one is displayed SURVEY BACKGROUND COLOR The background color of the survey itself PAGE BACKGROUND COLOR The background color of the page the survey is on MATRIX HEADER COLOR The background color of the matrix header MATRIX FIRST COLOR The background color of alternating rows in the matrix starting with the first row MATRIX
15. ight of the image IMAGE ALIGNMENT For images the alignment of the image center left or right DATABASE SQL For database dropdown questions the SQL that is used to select the values DATABASE DSN For database dropdown questions the DSN information that is used to connect to the database SUBITEM COUNT If the question has subitems the number of subitems that are associated with this question SUR ITEM ANSWER This table contains answers for questions that have predefined answers such as dropdown checkbox option buttons etc SUR ITEM ANSVIER Columname DataType Length low uls i 4 SW ANSWER ID int int ANSWER TEXT varchar ANSWER VALLIE ORDER_NUMBER RANDOM ORDER NUMBER DEFALILT ANSWER 10 Numeric primary key for this table ITEM ID Foreign key to the SUR ITEM table ANSWER TEXT The actual text of the answer ANSWER VALUE For answers with point values the number of points or numeric value associated with this answer ORDER NUMBER The numeric sequence number of this specific within this group of answers RANDOM ORDER NUMBER Column used for displaying the answers in random order DEFAULT YN A flag indicating whether or not this answer is selected by default SUR ITEM ANSWER GROUP This table contains a list of predefined groups of values that can be selected from on the item page for creating sets of predefined answers classapps SGUR
16. ins optional additional information for each page within a survey SUR PARE LL DataType 9 SURVEY_ID int WPAGE NLIMBER PAGE TITLE varchar PAGE IMTRODLICTIONM text SURVEY Foreign key to the SUR SURVEY table and part of the compound primary key for this table PAGE NUMBER The page number within the survey for this entry and part of the compound primary key for this table PAGE TITLE The tile of the particular page PAGE INTRODUCTION The introductory text for the particular page SUR PAGE CONDITION This table contains page conditions that are optionally associated with each page in a survey SUR_PAGE_CONDITION Column Name DataType Length allow Nuls a VW PAGE CONDITION ID int 2 SURVEY ID int PAGE NLIMBER DEPEMDENT ITEM ID int 2 GROLIP NLIMBER int OPERATOR ID int ANSWER ID int TEXT varchar PAGE CONDITION ID Numeric primary key for this table SURVEY Foreign key to the SUR SURVEY table representing the survey that this page condition is associated with PAGE NUMBER The page number within the survey that this page condition is associated with DEPENDENT ITEM 10 Foreign key to the SUR ITEM table representing the item on which this page condition is dependent GROUP NUMBER The group number that this page condition belongs to All items within a group are evaluated us OH logic OPERATOR
17. of all roles used within the application SUR_ROLE a ARAM ee eee int ROLE varchar ROLE DESCRIPTION text ROLE ID Numeric primary key for this table ROLE NAME The name of the role ROLE DESCRIPTION The description of the role SUR SUBITEM This table contains all subitems used for questions Subitems are the row headings for questions such as matrix constant sum ranking etc SUR SUBITEM Sommens DataType 9 SUBITEM_ID SUBITEM TEXT ORDER NLIMBER ORDER SUBITEM 10 Numeric primary key for this table ITEM ID Foreign key to the SUR ITEM representing the item to which the subitem is associated SUBITEM TEXT The actual text of the subitem ORDER NUMBER The numeric sequence for the order in which this subitem will be displayed 14 assapps RANDOM ORDER NUMBER A field used for optionally displaying the subitems in random order SUR SURVEY This table contains all data that defines each survey SUR SURVET cHumName Type Length allow Nuls a S SURVEY ID TEMPLATE ID CLOSED DATE o CREATED DATE LALUINCHED DATE J START DATE EN RESPONSES FOR SURVEY RESPONSE COUNT E COMPLETION ac TIOM o SURVEY COMPLETE MESSAGE SURVEY COMPLETE REDIRECT URL EN SURVEY COMPLETE DISPLAY CLOSE E SURVEY COMPLETE DISPLAY CONTINUE S SURVEY COMPLETE DISPLAY R
18. om order EMAIL ADDRESS YN A flag indicating whether or not this question is an email address question OTHER YN A flag indicating whether or not this question has an other response This applies to option buttons and checkboxes OTHER TEXT If the question has an other option this is the text that prompts for the other response OTHER DISPLAY TYPE For other responses whether the input control should be displayed as a textbox or a textarea MAXIMUM LENGTH The maximum length of the text that can be input for this question MINIMUM VALUE The minimum value for rating scales questions classa pps MAXIMUM_VALUE The maximum value for rating scales questions ANSWER TOTAL The total number of answers for questions that have predefined answers such as checkboxes radio buttons etc MINIMUM NUMBER RESPONSES The minimum number of responses the user must select for this question MAXIMUM NUMBER RESPONSES The maximum number of responses the user must select for this question ROW TEXT WIDTH The width of the row text column for matrix constant sum ranking and one or more line questions DISPLAY FORMAT The display format for the question for dropdown option button for Yes No and True False questions DEFAULT VALUE The default value that should be displayed for this questions IMAGE PATH For images the path to the image on the server IMAGE WIDTH For images the width of the image IMAGE HEIGHT For images the he
19. or multi response surveys the maximum number of responses from a single user MODIFY SURVEY WITHIN DAYS For updateable surveys the number of days during which an update is allowed RESPONDENT ACCESS LEVEL The security level of the survey PAGE NUMBERING FORMAT The page numbering format numbers do page numbers graphic etc QUESTION NUMBERING FORMAT The question numbering format no question numbers per page for entire survey BACK BUTTON DISPLAY Indicates whether or not to display the Back button for this survey CANCEL BUTTON DISPLAY Indicates whether or not to display the Cancel button for this survey CANCEL BUTTON REDIRECT URL If the Cancel button is displayed this column contains the URL to redirect to when the user clicks the Cancel button SUR SURVEY TO ITEM MAPPING This table maps surveys to all of the items contained within each survey 16 classapps SUR_SURYVYEY_TO_TTEM_MAPPING __ColumnNane bata Type Length Alow Ns 9 SURVEY ID ORDER_NUMBER PAGE NLIMBEF SURVEY Foreign key to the SUR SURVEY table and part of the compound primary key for this table ITEM ID Foreign key to the SUR ITEM table and part of the compound primary key for this table ORDER NUMBER The numeric sequence number of the item s order within the specified survey PAGE NUMBER The page number that this item belongs on within the specified survey SUR TEMPLATE This table contains all tem
20. plate definitions 17 _ BORDER WIDTH SURVEY BACKGROLIND COLOR E PAGE BACKGROUND COLOR MATRIX HEADER COLOR MATRIX FIRST COLOR MATRIX SECOND COLOR PROGRESS FIRST COLOR PROGRESS SECOND COLOR SURVEY NAME FONT COLOR SURVEY FONT SIZE SURVEY NAME FONT WEIGHT SURVEY FONT FAMILY PAGE TITLE FONT COLOR PAGE TITLE FONT SIZE PAGE TITLE FONT WEIGHT TITLE FONT FAMILY PAGE FONT COLOR PAGE NUMBER FONT SIZE PAGE NLIMBER FONT WEIGHT PAGE NUMBER FONT FAMILY QUESTION TEXT FONT COLOR QUESTION TEXT FONT SIZE QUESTION TEXT FONT WEIGHT QUESTION TEXT FONT FAMILY QUESTION SUBTEXT FONT COLOR QUESTION SUBTEXT FONT SIZE QUESTION SUBTEXT FONT WEIGHT QUESTION SUBTEXT FONT FAMILY NAVIGATION LINK FONT COLOR NAVIGATIONM LINK FONT SIZE NAVIGATION LINK FONT WEIGHT _ NAVIGATION LINK FONT FAMILY HTML TOP HTML BOTTOM NAVIGATION BACK BLITTON PATH NAVIGATION BACK LIMK TEXT NAVIGATION NEXT BLITTON PATH NAVIGATION NEXT LINK TEXT _ NAVIGATION CANCEL BLTTOM PATH MAVIGATION CANCEL LINK TEXT _ NAVIGATION DOME BUTTON PATH __ MAVIGATION DONE LINK TEXT varchar varchar varchar char varchar int varchar varchar varchar varchar varchar varchar varchar varchar int varchar varchar varchar init varchar varchar varchar int var
21. r or not this library is active LIBRARY NAME The name of the library USER Foreign key to the SUR USER table representing the owner of the library CREATED DATE The date the library was created PUBLIC YN A flag indicating whether or not this library can be used by users other than the owner for inserting questions into a survey SUR LIBRARY TO ITEM MAPPING This table maps libraries to the individual items contained within each library SUR LIBRARY e were Data Type Length Aow Nuls W LIBRARY ID int int JORDER_NUMBER int LIBRARY_ID Foreign key to the SUR LIBRARY table and part of the compound primary key for this table ITEM ID Foreign key to the SUR ITEM table and part of the compound primary key for this table ORDER NUMBER The numeric sequence number of the item within the library SUR OPERATOR This table contains a list of all operators used for page conditions SUR_OPERATOR coum neme DataType _ length Atow nus W OPERATOR ID int OPERATOR TEXT SHORT OPERATOR TEXT LONG varchar ORDER NLIMBER int OPERATOR Numeric primary key for this table OPERATOR TEXT SHORT The short textual name of the operator classa pps OPERATOR TEXT LONG The long textual name of the operator ORDER NUMBER The numeric sequence number of each operator within the list of operators SUR PAGE This table conta
22. reign keys can easily be determined by their ID suffix and the table each foreign key refers to can be determined by the name of the key which corresponds to the name of the table The rest of this document contains a description of each table a snapshot of all columns in the table and a detailed description of each column in each table SUR EMAIL ADDRESS This table contains each individual email address contain within email lists which are located in the SUR EMAIL LIST table SUR EMAIL ADDRESS W EMAIL ADDRESS ID int EMAIL LIST ID int EMAIL ADDRESS varchar 5 NAME varchar 5 NAME varchar CUSTOM DATA 1 varchar CUSTOM 2 warchar CUSTOM 3 2 ACTIVE varchar J DELETED varchar EMAIL ADDRESS Numeric primary key for this table EMAIL LIST ID Foreign key to the SUR EMAIL LIST table EMAIL ADDRESS The actual email address FIRST NAME The first name of the person for this email address LAST NAME The last name of the person for this email address CUSTOM DATA 1 custom data field for any extra data CUSTOM DATA 2 custom data field for any extra data CUSTOM DATA 3 A custom data field for any extra data ACTIVE flag indicating whether or not this email address is active classa pps DELETED YN A flag indicating whether or not this email address has been deleted Note that deleted
23. report share is used by LAST SENT DATE The date this report share was last sent to the email addresses EXPORT DATA YN A flag indicating whether or not this report share has permission to export data REPORT FILTERING YN A flag indicating whether or not this report share has permission to filter reports VIEWABLE REPORTS The type of reports that are viewable overview only or both overview and individual VIEW OPEN ENDED YN A flag indicating whether or not this report share has permission to view open ended question answers ACTIVE A flag indicating whether or not this report share is active SUR RESPONSE This table contains general information about each submitted response 12 classapps SUR RESPONSE _ Data Type Length ow ts 4 V RESPONSE ID 2 SURVEY ID ANONYMOUS ID EMAIL ADDRESS ID USERNAME varchar RESPONSE START DATE datetime RESPONSE DATE datetime ADDRESS varchar 2 COMPLETED YN char RESPONSE Numeric primary key for this table SURVEY 10 Foreign key to the SUR SURVEY table ANONYMOUS ID For anonymous responses the randomly generated anonymous ID used for the respondent EMAIL ADDRESS Foreign key to the SUR EMAIL ADDRESS table USERNAME For logged in users the username of the respondent RESPONSE START DATE The date time the response was started RESPONSE END DATE The date time the response was ended IP A
24. ssage this is the text of the message to display SURVEY COMPLETE REDIRECT URL If the completion action includes a new URL this is the URL to redirect to SURVEY COMPLETE DISPLAY CLOSE If the completion action includes displaying a message this column indicates whether or not to display a Close button SURVEY COMPLETE DISPLAY CONTINUE If the completion action includes displaying message this column indicates whether or not to display a Continue button SURVEY COMPLETE DISPLAY REPORTS If the completion action includes displaying a message this column indicates whether or not to display a View Reports button RESPONSE EMAIL ADDRESSES Optional field for the email addresses that responses should be sent to SURVEY LANGUAGE The language that the survey is created in STATUS The current status of the survey Open Closed Design REPORT SHARING ENABLED YN A flag indicating whether or not reporting sharing has been enabled for this survey REPORT SECURITY If report sharing has been enabled this column contains the security level of the report sharing HIGHLIGHT RESPONSES YN A flag indicating whether or not the current user s responses should have a star next to them when the current user views the overview report OWNERS The owner or owners of the survey usernames from the SUR USER table each separated by a semi colon ADMIN EMAIL ADDRESS The email address es of the administrator of the survey MAXIMUM RESPONSES PER USER F
Download Pdf Manuals
Related Search
SUR_ITEM suri temperature sur_myevic