^ Sr.No ^ Name ^ Type ^ Comments ^
| 1 | **id** | Primary int | AUTO_INCREMENT |
| 2 | **clientid** | Index int |  |
| 3 | **branchid** | Index int |  |
| 4 | **moduleid** | Index varchar(150) |  |
| 5 | **qid** | Index varchar(150) |  |
| 6 | **waveid** | Index int |  |
| 7 | **languageid** | Index int |  |
| 8 | **projectid** | Index int |  |
| 9 | **surveytype** | int | 1=textual, 2=multimedia |
| 10 | **invitationtype** | int | 0=Telephone, 1=Email, 2=SMS, 3=Paper, 4=WhatsApp |
| 11 | **status** | Index int | 0=inactive, 1=active, 2=self-inactive, -1=testinvitation, -2=test vrajenlijst invitation |
| 12 | **invalidinv** | int | 0=valid, 1=reset failed, 2=email format error |
| 13 | **consultationdate** | date |  |
| 14 | **orgstructure** | varchar(300) |  |
| 15 | **consultationwith** | int |  |
| 16 | **email** | Index varchar(150) |  |
| 17 | **phone** | varchar(50) |  |
| 18 | **klantnr** | varchar(20) |  |
| 19 | **salutation** | varchar(50) |  |
| 20 | **initials** | varchar(150) |  |
| 21 | **familyname** | varchar(150) |  |
| 22 | **lastname** | varchar(150) |  |
| 23 | **urlval** | varchar(50) |  |
| 24 | **shorturl** | varchar(250) |  |
| 25 | **longitude** | varchar(200) | Stores longitude value |
| 26 | **latitude** | varchar(200) | Stores latitude value |
| 27 | **weightage** | double | Stores respondent weight |
| 28 | **username** | varchar(250) |  |
| 29 | **password** | varchar(250) |  |
| 30 | **emotionprob** | varchar(250) |  |
| 31 | **intensityprob** | varchar(250) |  |
| 32 | **multifeedback** | int | 0=first feedback, 1=multiple feedback |
| 33 | **completeddate** | datetime |  |
| 34 | **sentdate** | datetime | Latest sent date stored here |
| 35 | **alertdate** | datetime | Latest reminder stored here |
| 36 | **createdby** | int |  |
| 37 | **createdon** | datetime |  |
| 38 | **modifiedby** | int |  |
| 39 | **modifiedon** | datetime |  |
| 40 | **processedon** | datetime | Invitation processing status |
| 41 | **selfinactivatedon** | datetime |  |
| 42 | **surveystarttime** | datetime |  |
| 43 | **extractedflag** | int | 1=Exported by weekly telephonic cron |
| 44 | **invemailsettingsid** | Index int |  |
| 45 | **invremindersettingsid** | varchar(200) |  |
| 46 | **pid** | varchar(20) |  |
| 47 | **cid** | varchar(20) |  |
| 48 | **respondenttype** | int |  |
| 49 | **addtnluserid** | varchar(30) |  |
| 50 | **field1** | longtext |  |
| 51 | **field2** | longtext |  |
| 52 | **field3** | longtext |  |
| 53 | **field4** | longtext |  |
| 54 | **field5** | longtext |  |
| 55 | **field6** | longtext |  |
| 56 | **field7** | longtext |  |
| 57 | **field8** | longtext |  |
| 58 | **field9** | longtext |  |
| 59 | **field10** | longtext |  |
| 60 | **field11** | longtext |  |
| 61 | **field12** | longtext |  |
| 62 | **field13** | longtext |  |
| 63 | **field14** | longtext |  |
| 64 | **field15** | longtext |  |
| 65 | **field16** | longtext |  |
| 66 | **field17** | longtext |  |
| 67 | **field18** | longtext |  |
| 68 | **field19** | longtext |  |
| 69 | **field20** | longtext |  |
| 70 | **field21** | longtext |  |
| 71 | **field22** | longtext |  |
| 72 | **field23** | longtext |  |
| 73 | **field24** | longtext |  |
| 74 | **oldid** | int |  |
| 75 | **field25** | longtext |  |
| 76 | **field26** | longtext |  |
| 77 | **requestid** | varchar(250) | Unique ID for API invitations |
| 78 | **connectedinvitationid** | int | Related invitation ID for same respondents |
| 79 | **shortreviewurl** | varchar(250) |  |
| 80 | **relatedinvid** | int |  |
| 81 | **anonymized** | int | 0=default, Data anonymized after 2 years |
| 82 | **anonymizedon** | datetime |  |
| 83 | **importinvid** | int |  |
| 84 | **locationclosed** | int | 1=Closed, 0=Open |