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. 


How did we do?


Powered by HelpDocs (opens in a new tab)