Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
dashboard_id INT UNSIGNED 10 null FK_civicrm_dashboard_contact_dashboard_id C

Dashboard ID

contact_id INT UNSIGNED 10 null FK_civicrm_dashboard_contact_contact_id C

Contact ID

column_no TINYINT 3 0

column no for this widget

is_active TINYINT 3 0

Is this widget active?

weight INT 10 0

Ordering of the widgets.

Table contained 3 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_dashboard_contact_contact_id Performance Asc contact_id
FK_civicrm_dashboard_contact_dashboard_id Performance Asc dashboard_id
index_dashboard_id_contact_id Must be unique Asc/Asc dashboard_id + contact_id