Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| group_name | VARCHAR | 32 | null |
|
|
group name for cache element, useful in cleaning cache elements |
||||
| path | VARCHAR | 255 | √ | null |
|
|
Unique path name for cache element |
|||
| data | LONGTEXT | 2147483647 | √ | null |
|
|
data associated with this path |
|||
| component_id | INT UNSIGNED | 10 | √ | null |
|
|
Component that this menu item belongs to |
|||
| created_date | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
When was the cache item created |
||||
| expired_date | TIMESTAMP | 19 | √ | null |
|
|
When should the cache item expire |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_cache_component_id | Performance | Asc | component_id |
| UI_group_path_date | Must be unique | Asc/Asc/Asc | group_name + path + created_date |
Relationships
Close relationships within degrees of separation
