Users_Roles

85 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
SystemUserBase.id Users_Roles_user_id_fkeyR
role_id int4 10 null
Roles.id Users_Roles_role_id_fkeyR
id serial 10 nextval('v1."Users_Roles_id_seq"'::regclass)

Indexes

Constraint Name Type Sort Column(s)
Users_Roles_pkey Primary key Asc/Asc user_id + role_id
Users_Roles_id_key Must be unique Asc id

Relationships