user_roles

718 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
users.id fk_user_roles_user_id C
prop_id int4 10 null
property.id fk_user_roles_prop_id C
group_id int4 10 null
user_group.id fk_user_roles_group_id C
active bool 1 true
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
user_roles_pkey Primary key Asc/Asc/Asc user_id + prop_id + group_id
idx_user_roles_group_id Performance Asc group_id
idx_user_roles_prop_user Performance Asc/Asc prop_id + user_id

Relationships

Close relationships within degrees of separation