^ 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). |