civicrm_acl_contact_cache

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

primary key

user_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_acl_contact_cache_user_idC

FK to civicrm_contact (could be null for anon user)

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_acl_contact_cache_contact_idC

FK to civicrm_contact

operation VARCHAR 8 null

What operation does this user have permission on?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_acl_contact_cache_contact_id Performance Asc contact_id
UI_user_contact_operation Must be unique Asc/Asc/Asc user_id + contact_id + operation

Relationships