civicrm_navigation

295 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_navigation.parent_id FK_civicrm_navigation_parent_idC
civicrm_report_instance.navigation_id FK_civicrm_report_instance_navigation_idN
domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_navigation_domain_idR

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
civicrm_navigation.id FK_civicrm_navigation_parent_idC

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.

icon VARCHAR 255 null

CSS class name for an icon

Indexes

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

Relationships