group_permission_override

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

group_id

int4

10

null

user_group.id

fk_group_permission_override_group_id

C

prop_id

int4

10

null

property.id

fk_group_permission_override_prop_id

C

code

bpchar

5

null

permission.code

fk_group_permission_override_code

C

perm_id

int8

19

null

permission.id

fk_group_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)
group_permission_override_pkey	Primary key	Asc/Asc/Asc	group_id + prop_id + code
idx_group_permission_override_prop_group	Performance	Asc/Asc	prop_id + group_id

Check Constraints

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

group_permission_override

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation