civicrm_dashboard_contact - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

INT UNSIGNED

10

√

null

dashboard_id

INT UNSIGNED

10

null

civicrm_dashboard.id

FK_civicrm_dashboard_contact_dashboard_idC

Dashboard ID

contact_id

INT UNSIGNED

10

null

civicrm_contact.id

FK_civicrm_dashboard_contact_contact_idC

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.

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees