^ Sr.No ^ **Name** ^ Type ^ Comments ^ | 1 | **id** | Primary int | | | 2 | **moduleid** | varchar(100) | stores comma separated moduleids | | 3 | **variable** | varchar(200) | stores the pattern that is to be replaced in questionnaire | | 4 | **fieldidtype** | varchar(200) | defines whether the value given in 'fieldid' belongs to fw_invitaitonfields(invitation) or fw_questionniredetails(question) | | 5 | **fieldid** | varchar(150) | id from either fw_invitationfields or fw_questionnairedetails | | 6 | **fieldvalue** | varchar(1000) | value in this column is optional. If set, the column id given in fieldid is to have the value in this column | | 7 | **replacementtext** | varchar(8000) | Value is set in this column only when value is set in fieldvalue. Replaces 'variable' with value in this column if 'fieldid' column's field is matched with fieldvalue | | 8 | **replacementparams** | text | the query part which will replace the pattern with the outcome of the query | | 9 | **showintestinv** | int | whether to consider in test invitation or not |