^ Sr.No ^ **Name**                ^ Type            ^ Comments                                                            ^
| 1     | **id**                   | Primary int     |                                                                  |
| 2     | **filtertypeid**          | Index int       |                                                                  |
| 3     | **displayparams**         | text            | Stores the query in such a format so as to return id and name for the filter. This is used when the filter options are dynamic or not straightforward |
| 4     | **value**                 | varchar(200)    | the value that is to be matched when this option is chosen         |
| 5     | **valueparams**           | text            | value in terms of query, that is to be matched when this option is chosen |
| 6     | **reportparam**           | text            | this column holds the query which helps in splitting the chosen filter data into individual options |
| 7     | **filteroptionsord**      | int             | the order in which filter options are to be appeared within a category('filtertypeid') |
| 8     | **clickability**          | int             | 0=unclickable, 1=clickable                                         |
| 9     | **parentfilteroptionid**  | int             | id of fw_filteroptions itself, to which this option is a sub branch |
| 10    | **carryforwarddisplaytext** | int          | if set, this displaytext is forwarded to the 'rel' option text of its successor option |
| 11    | **firstviewfilteroptionid** | int           | used to store the filteroptionid which is used for first view dashboard (Ex: filteroptionid of Laatste 4 metingen) |
| 12    | **status**                | int             | 0=inactive, 1=active                                               |