user_role


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
user.id fk_ur_user C
role_id int4 10 null
role.id fk_ur_role C

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
pk_user_role Primary key Asc/Asc user_id + role_id

Relationships

Close relationships within degrees of separation