Table d47civi_0z3xa.civicrm_menu 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  √ 
domain_id int unsigned 10
civicrm_domain.id FK_civicrm_menu_domain_id R
Which Domain is this menu item for
path varchar 255  √  null Path Name
path_arguments text 65535  √  null Arguments to pass to the url
title varchar 255  √  null
access_callback varchar 255  √  null Function to call to check access permissions
access_arguments text 65535  √  null Arguments to pass to access callback
page_callback varchar 255  √  null function to call for this url
page_arguments text 65535  √  null Arguments to pass to page callback
breadcrumb text 65535  √  null Breadcrumb for the path.
return_url varchar 255  √  null Url where a page should redirected to, if next url not known.
return_url_args varchar 255  √  null Arguments to pass to return_url
component_id int unsigned 10  √  null
civicrm_component.id FK_civicrm_menu_component_id R
Component that this menu item belongs to
is_active tinyint 3  √  null Is this menu item active?
is_public tinyint 3  √  null Is this menu accessible to the public?
is_exposed tinyint 3  √  null Is this menu exposed to the navigation system?
is_ssl tinyint 3  √  null Should this menu be exposed via SSL if enabled?
weight int 10 1 Ordering of the menu items in various blocks.
type int 10 1 Drupal menu type.
page_type int 10 1 CiviCRM menu type.
skipBreadcrumb tinyint 3  √  null skip this url being exposed to breadcrumb

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
component_id Performance Asc FK_civicrm_menu_component_id
domain_id Performance Asc FK_civicrm_menu_domain_id
path + domain_id Must be unique Asc/Asc UI_path_domain_id

Close relationships  within of separation: