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 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 |
|
|
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
Close relationships within degrees of separation
