tdis_user_project_role


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
tdis_user.contact_id tdis_user_project_role_user_fkC
project_id int4 10 null
tdis_project.id tdis_user_project_role_project_fkC
role_id int4 10 null
tdis_user_role.id tdis_user_project_role_role_fkC

Indexes

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

Relationships

Close relationships within degrees of separation