Table d44civi_9xzwf.civicrm_acl Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_acl_cache.acl_id FK_civicrm_acl_cache_acl_id C
Unique table ID
name varchar 64  √  null ACL Name.
deny tinyint 3 0 Is this ACL entry Allow (0) or Deny (1) ?
entity_table varchar 64 Table of the object possessing this ACL entry (Contact, Group, or ACL Group)
entity_id int unsigned 10  √  null ID of the object possessing this ACL
operation enum 6 What operation does this ACL entry control?
object_table varchar 64  √  null The table of the object controlled by this ACL entry
object_id int unsigned 10  √  null The ID of the object controlled by this ACL entry
acl_table varchar 64  √  null If this is a grant/revoke entry, what table are we granting?
acl_id int unsigned 10  √  null ID of the ACL or ACL group being granted/revoked
is_active tinyint 3  √  null Is this property active?

Table contained 65 rows at Wed Nov 11 17:14 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
acl_id Performance Asc index_acl_id

Close relationships  within of separation: