Table d45civi_b72v5.civicrm_dashboard 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  √ 
civicrm_dashboard_contact.dashboard_id FK_civicrm_dashboard_contact_dashboard_id C
domain_id int unsigned 10
civicrm_domain.id FK_civicrm_dashboard_domain_id R
Domain for dashboard
name varchar 64  √  null Internal name of dashlet.
label varchar 255  √  null dashlet title
url varchar 255  √  null url in case of external dashlet
permission varchar 255  √  null Permission for the dashlet
permission_operator varchar 3  √  null Permission Operator
column_no tinyint 3  √  0 column no for this dashlet
is_minimized tinyint 3  √  0 Is Minimized?
fullscreen_url varchar 255  √  null fullscreen url for dashlet
is_fullscreen tinyint 3  √  1 Is Fullscreen?
is_active tinyint 3  √  0 Is this dashlet active?
is_reserved tinyint 3  √  0 Is this dashlet reserved?
weight int 10  √  0 Ordering of the dashlets.

Table contained 12 rows at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
domain_id Performance Asc FK_civicrm_dashboard_domain_id

Close relationships  within of separation: