^ Sr.No ^ **Name**                     ^ Type         ^ Comments  ^
| 1     | **id**                       | Primary int  |           |
| 2     | **moduleid**                 | int          |           |
| 3     | **menuname**                 | varchar(250) |           |
| 4     | **menuimage**                | blob         |           |
| 5     | **menupath**                 | text         |           |
| 6     | **menubgcolor**              | varchar(6)   |           |
| 7     | **menutextcolor**            | varchar(6)   |           |
| 8     | **parentid**                 | int          |           |
| 9     | **mainmenuid**               | int          |           |
| 10    | **clickabilitymenuid**       | int          |           |
| 11    | **userlevelmenu**            | int          |           |
| 12    | **showfilters**              | int          | 1=assign menuwise filters to this menu or show filter to this menu, 0=vice-versa to 1 |
| 13    | **staticmenu**               | int          |           |
| 14    | **menuorder**                | int          |           |
| 15    | **urlvalue**                 | text         |           |
| 16    | **rememberfilterids**        | varchar(250) | used to store the ids from fw_filtertypes table which filters are to be remembered. |
| 17    | **rememberbgvariableids**    | varchar(250) | used to store the ids from fw_bgvariables table which background variables are to be remembered. |
| 18    | **considermoduleids**        | varchar(250) | saves the moduleids for which this menu is to be considered. |
| 19    | **status**                   | int          |           |