^ #  ^ **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 |