Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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 | null |
|
|
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 | VARCHAR | 8 | null |
|
|
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? |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| index_acl_id | Performance | Asc | acl_id |
Relationships
Close relationships within degrees of separation
