Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| domain_id | INT UNSIGNED | 10 | null |
|
|
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 |
|
|
Menu Title |
|||
| 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 |
|||
| 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 |
|
|
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 |
|||
| module_data | TEXT | 65535 | √ | null |
|
|
All other menu metadata not stored in other fields |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_menu_component_id | Performance | Asc | component_id |
| FK_civicrm_menu_domain_id | Performance | Asc | domain_id |
| UI_path_domain_id | Must be unique | Asc/Asc | path + domain_id |
Relationships
Close relationships within degrees of separation
