Table access_entry
ACL entries. Maps privileges to targets

Legend:
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 int8 19
acl_order int4 10
acl_priority int4 10
aggregate_ordering varchar 12
expiry timestamp 29,6  √  null
grant_revoke bpchar 1
privilege varchar 30  √  null
target_object varchar 80  √  null
expression_id int8 19
access_expression.id fk8b9a85d7817719f3 R
institution_id int8 19
institution.id fk8b9a85d7bc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc access_entry_pkey
expression_id Performance Asc accessentryexpression
institution_id Performance Asc accessentryinstitution
aggregate_ordering Performance Asc aggregateorderingindex
privilege Performance Asc privilegeindex
target_object Performance Asc targetobjectindex

Close relationships  within of separation: