Performitor

#	Name	Type	Comments
1	id	int	AUTO_INCREMENT
2	moduleid	varchar(150)
3	languageid	int
4	defaultlanguage	int	1=Yes, 0=No
5	salutationoptions	varchar(200)	'^' separated salutation options used while creating invitations
6	respondentnamefields	text	stores set of column names of fw_invitations table
7	surveyhyperlinktext	varchar(200)	Text for email invitation's hyperlink. Clicking which questionnaire opens
8	surveybuttontext	varchar(250)	Button text for email invitation's hyperlink. Clicking which questionnaire opens
9	surveybuttontextcolor	varchar(100)	Start survey button text color.
10	surveybuttoncolor	varchar(100)	Start survey button color.
11	selfinactivatehyperlink	varchar(200)	Text to be shown in the email body, which represents link to inactivate an invitation by respondent himself
12	selfinactivatetext	varchar(500)	Text to be shown to respondent when he doesn't want to fill in questionnaire and inactivates it
13	invexpiredtext	varchar(300)
14	invnotsenttext	varchar(300)
15	vraagtext	varchar(500)	to save vraag text in survey.
16	progressbartext	varchar(200)	used only when 'progressbartype' value in module settings is chosen with 'Number based' option
17	buttontext	varchar(200)	'^' separated texts to be shown against 'previous' and 'next' buttons respectively
18	mandatoryalerttext	varchar(300)	alert text to notify respondent that a question cannot be left empty
19	limitedoptionsalerttext	varchar(300)	alert text shown when attempting to answer options more than specified limit for that question
20	invalidoptionalerttext	varchar(300)	alert text shown when value entered by respondent is not of existing records
21	phonealert	varchar(300)	alert message text when given phone no is invalid
22	emailalert	varchar(300)	alert message text when given email is invalid
23	lastqnotificationtext	varchar(500)	text to be shown in questionnaire to notify respondent that the current question is last question of survey
24	savebuttontext	varchar(200)	text to be shown on save button in single page survey
25	restartbuttontext	varchar(200)	text shown on restart button of single page survey
26	restartconfirmtext	varchar(300)	Text to be shown in confirm dialog box when attempted to restart questionnaire
27	startquestionnairebuttontext	varchar(200)	text shown on button at single questionnaire end screen, to start fresh questionnaire
28	branchbenchmarkingtext	varchar(200)
29	benchmarkingtext	varchar(200)
30	surveyendtext	text	text to be displayed on questionnaire end screen
31	reopenedendpagetext	text
32	optoutsurveyendtext	text	text to be shown at the end when a respondent chooses an option which drives to end of questionnaire
33	copyrightinfotext	text	text shown as overlay in dashboard if copyright settings are set at roles page
34	staticdata	text	define layout text when a module is not assigned to manager
35	selectionemptytiletxt	varchar(200)	displayed when settileemptytxt in questionnaire header is set and tile has 0 n count only for a filter selection
36	overallemptytiletxt	varchar(200)	displayed when settileemptytxt in questionnaire header is set and there is no data for all tiles
37	numberbetween1and9999text	varchar(250)	Vul een waarde in van 1 - 9999
38	endpageaudiofile	longblob
39	status	int	1=active, 0=inactive