Performitor

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