Table d47civi_0z3xa.civicrm_dashboard_contact Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
dashboard_id int unsigned 10
civicrm_dashboard.id FK_civicrm_dashboard_contact_dashboard_id C
Dashboard ID
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_dashboard_contact_contact_id C
Contact ID
column_no tinyint 3  √  0 column no for this widget
is_minimized tinyint 3  √  0 Is Minimized?
is_fullscreen tinyint 3  √  1 Is Fullscreen?
is_active tinyint 3  √  0 Is this widget active?
weight int 10  √  0 Ordering of the widgets.
content longtext 2147483647  √  null dashlet content
created_date datetime 19  √  null When was content populated

Table contained 12 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_dashboard_contact_contact_id
dashboard_id Performance Asc FK_civicrm_dashboard_contact_dashboard_id

Close relationships  within of separation: