Performitor

Sr.No	Name	Type	Comments
1	id	Primary int
2	qid	Index varchar(50)
3	menuid	Index int
4	qdetailid	tinytext
5	tcqdetailids	text	Respective qdetailids separated by	for tagclouds.
6	bqdetailid	varchar(250)	Saves comma-separated qdetailids for bubblegraph.
7	sparkleqdetailid	varchar(250)	Saves comma-separated qdetailids for new driver NPS graph (Sparkle graph).
8	colorstripqdetailid	varchar(250)	Used for color strip or image for specific questions.
9	extralineqdetailid	varchar(250)
10	graphoptionsparam	text	Query forming options for the graph.
11	filtercondition	text	Default condition applied on graph data when it loads.
12	pageno	int	Stores page number to which each entry belongs.
13	ord	int	Order in which the graphs appear in dashboard.
14	maakrapportord	int	Order for graphs/tagclouds in the “maak rapport”.
15	defaulttype	varchar(250)	Defines the default data type for tiles.
16	type	varchar(50)	Graph or tagcloud.
17	linegraph	int	Defines whether to show linegraph (0=normal, 1=linegraph).
18	extralinegraph	int
19	bgvariableid	int	Used for plotting graph regardless of background filter.
20	othersoptionbarsettings	varchar(20)	Max % value for others option bar and min number of bars.
21	status	int	1=active, 0=inactive.
22	exportstatus	int	0=exclude from export, 1=include, -1=show open answers.
23	useoptionscore	int	0 (default).