Table d47civi_0z3xa.civicrm_navigation Generated by
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_navigation.parent_id FK_civicrm_navigation_parent_id C
civicrm_report_instance.navigation_id FK_civicrm_report_instance_navigation_id N
domain_id int unsigned 10 FK_civicrm_navigation_domain_id R
Which Domain is this navigation item for
label varchar 255  √  null Navigation Title
name varchar 255  √  null Internal Name
url varchar 255  √  null url in case of custom navigation link
permission varchar 255  √  null Permission for menu item
permission_operator varchar 3  √  null Permission Operator
parent_id int unsigned 10  √  null FK_civicrm_navigation_parent_id C
Parent navigation item, used for grouping
is_active tinyint 3  √  null Is this navigation item active?
has_separator tinyint 3  √  null If separator needs to be added after this menu item
weight int 10  √  null Ordering of the navigation items in various blocks.

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

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
domain_id Performance Asc FK_civicrm_navigation_domain_id
parent_id Performance Asc FK_civicrm_navigation_parent_id

Close relationships  within of separation: