Which database tables should I review to understand how dashboards and viewlets are structured in the system? – meshIQ

To understand the relationships and data structures behind dashboards and viewlets, we recommend reviewing the following key tables:

wmmf_dashboard:
Contains core dashboard metadata. Each dashboard is linked by id to:
- wmmf_dashboard_viewlet:
  Maps dashboards to viewlets using keys such as favorite_id, search_id, and external_id.
These keys further connect to specific types of viewlets:
- wmmf_external_resource_viewlet
- wmmf_favorites_folder
- wmmf_search_folder
logins:
Identifies the owner of dashboards and viewlets through the login_id.
Unfortunately, timestamp fields (creation/update times) are not available, so it's not possible to determine when these records were last modified.

wmmf_search_folder → linked to wmmf_search_data via folder_id for detailed search configurations.
wmmf_search_attribute_filter → connects to wmmf_attribute_filter to store viewlet filter criteria.
wmmf_shortcut_object and wmmf_shortcut_attributes:
Store shortcut viewlets and their associated attributes.
wmmf_viewlet_display_schema:
Defines display schema settings such as sorting and schema usage per viewlet_id.
These tables collectively provide insight into how dashboards, viewlets, filters, and display schemas are organized within the system.