user_permission_override

8226 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
users.id fk_user_permission_override_user_id C
prop_id int4 10 null
property.id fk_user_permission_override_prop_id C
code bpchar 5 null
permission.code fk_user_permission_override_code C
perm_id int8 19 null
permission.id fk_user_permission_override_perm_id C
action_type text 2147483647 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
user_permission_override_pkey Primary key Asc/Asc/Asc user_id + prop_id + code
idx_user_permission_override_action Performance Asc/Asc/Asc user_id + prop_id + action_type
idx_user_permission_override_perm_id Performance Asc perm_id

Check Constraints

Constraint Name Constraint
user_permission_override_action_type_check (action_type = ANY (ARRAY['allow'::text, 'deny'::text]))

Relationships

Close relationships within degrees of separation