user_roles

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('user_roles_id_seq'::regclass)
user_id int4 10 null
users.user_id user_roles_user_id_fkey R
role_id int4 10 null
roles.role_id user_roles_role_id_fkey R
streamer_id int4 10 √ null
users.user_id user_roles_streamer_id_fkey N

Indexes

Constraint Name Type Sort Column(s)
user_roles_pkey Primary key Asc id
user_roles_user_id_role_id_streamer_id_key Must be unique Asc/Asc/Asc user_id + role_id + streamer_id

Relationships

Close relationships within degrees of separation