Database – Dashboard Widget Entity (dashboardwidget_entity)
Description
Dashboard Widgets provide snippets of information from LoanPro to populate a user dashboard with a preview of the company standing and related information saved in LoanPro.
Common Uses
Table Fields
Column | Data Type | Column Info | Value Notes |
id | int(11) | The ID or identifier of the dashboard widget entity. | |
title | varchar(255) | The identifying name of the dashboard widget. | |
active | tinyint(1) | Specifies whether the dashboard widget is active or not. | 1 - yes, 0 - no |
chart_type | enum(...) | Specifies the type of chart used for the dashboard widget. | Example: "pie", "bar", "table" |
columns | varchar(255) | Specifies specific columns for graph related widgets. | Example: "id", "active", "displayId" |
group_by | varchar(255) | Determines what specific widgets information is grouped by. | Example: "id" |
date_field | varchar(255) | Specifies what date variable is used if included in widget. | |
max_records | tinyint(1) | Specifies the amount of records to display related to the widget. | |
query_type | varchar(255) | Specifies where to query the information from. | |
query | text | The specific query. | |
query_filters | text | Filters related to the query. | |
lastUpdated | timestamp | Specifies when the entity was last updated. | |
deleted | tinyint(1) | Specifies whether the dashboard widget is deleted or not. | 1 - yes, 0 - no |
created | timestamp | Specifies when the entity was created. | |
created_by | int(11) | Specifies what user created the entity. |