^ Sr.No ^ **Name** ^ Type ^ Comments ^
| 1     | **id**               | Primary int       |              |
| 2     | **clientid**         | Index int         |              |
| 3     | **moduleid**         | Index varchar(150) |              |
| 4     | **field**            | varchar(200)      |              |
| 5     | **type**             | varchar(200)      |              |
| 6     | **typevalues**       | varchar(200)      |              |
| 7     | **mandatory**        | int               |              |
| 8     | **uniqueness**       | int               |              |
| 9     | **minlength**        | int               | defines minimum length of field value. |
| 10    | **ignoremailvalidation** | int           | 0=validate email, 1=check but don't stop invitation insert |
| 11    | **validatemail**     | int               | this is to be applied for text type of fields and if set will check for email validation in corresponding field value |
| 12    | **dontshowinimport** | int              |              |
| 13    | **showininvitations** | int             |              |
| 14    | **showinoverview**   | int               | 1=Show, 0=Don't show |
| 15    | **nullreplacementval** | varchar(200)    | value to be stored in invitations when the column value is given with empty value |
| 16    | **usedformap**       | int               | 0=not used for map, 1=used for map |
| 17    | **usedforsearch**    | int               | fields which are used for search in invitations overview page. |
| 18    | **usedforextracs**   | int               | used to show extra clientsheets based on this field. |
| 19    | **usedasphone**      | int               | 1=This field is used as Phone(saves columnname as 'phone'), 0=not used as phone(normal field) |
| 20    | **invitationlabel**  | varchar(300)      |              |
| 21    | **inputval**         | varchar(200)      |              |
| 22    | **columnname**       | varchar(200)      |              |
| 23    | **orderval**         | int               |              |
| 24    | **connectedfieldid** | int               | stores the related invitationfieldid. For example APP1 is related to CC1 in prorail. |
| 25    | **appfieldname**     | varchar(250)      | value in this column is used as field name in mobile app if it is set. |
| 26    | **hideonanonymous**  | int               | used especially at 'Search' tab in app. 1=when respondent is anonymous then apply anonymous condition to get the search results, 0=do not apply anonymous condition. |
| 27    | **defaultvalue**     | varchar(250)      | define default value of the field for demo access of client entry in app. rand() = random value from the list. |
| 28    | **status**           | int               |              |
| 29    | **editable**         | int               | if set then Client Entry Operator can edit this field |
| 30    | **importdataunique** | int               | 0              |
| 31    | **anonimize**        | int               | 0              |
| 32    | **usedforAPIsearch** | int               | 0              |
| 33    | **createdby**        | int               |              |
| 34    | **createdon**        | datetime          |              |
| 35    | **modifiedby**       | int               |              |
| 36    | **modifiedon**       | datetime          |              |