Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | INT UNSIGNED | 10 | √ | null |
|
|
Unique table ID |
|||
contact_id | INT UNSIGNED | 10 | √ | null |
|
|
Foreign Key to Contact |
|||
acl_id | INT UNSIGNED | 10 | null |
|
|
Foreign Key to ACL |
||||
modified_date | TIMESTAMP | 19 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
FK_civicrm_acl_cache_contact_id | Performance | Asc | contact_id |
index_acl_id | Performance | Asc | acl_id |