Keyfax - Dataview Menu Table [dbm_drop_menu]
Database Management Table: [dbm_drop_menu]
The dbm_drop_menu table contains details on menu bar 'drop menus'. Each item can give access to a sub menu, via a search input.
The following list represents the table fields (columns) their data-type and brief usage instructions/description:
| Field Name | Data Type | Usage |
|---|---|---|
| DropMenuItemID | int | Unique ID: used internally and cannot be edited via the application. |
| DropMenuID | int | Group number of a collection of menu items to be associated to a particular dbm_top_menu item. |
| MenuCaption | nvarchar(255) | Text displayed in the top menu bar. |
| MenuOrder | smallint | Order in which the drop menu items are to be displayed. |
| SearchHTML | ntext | HTML markup to allow text search inputs within drop menus, generating various querystring keys including st, wildcard=start/end etc. |
| SearchType | int | Search: Related Search menu to display (dbm_search.SearchTypeID) when top menu item selected. |
| Visible | tinyint | Menu visibility: 1 = MenuCaption is visible, 0 = MenuCaption is hidden. |