Database – View Widget (view_widget_entity)

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

name

varchar(255)

Entity name

description

varchar(255)

The description of the entity instance

type

enum

widget type

• view.widget.amountPastDueTile
• view.widget.contextVar
• view.widget.daysPastDueTile
• view.widget.feesAndInterest
• view.widget.notes
• view.widget.paidBreakdownChart
• view.widget.payoff
• view.widget.percentPaidOffChart
• view.widget.principalBalanceChart

data_source

text

data source

display_order

tinyint(1)

Sort order used when displaying on the UI

1 - yes, 0 - no

view_module_id

int(11)

view moduel ID

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated