project_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_role_id int4 10 null
roles.id project_user_project_role_id_foreignR
user_id int4 10 null
users.id project_user_user_id_foreignC
project_id int4 10 null
projects.id project_user_project_id_foreignC
pinned bool 1 false

Indexes

Constraint Name Type Sort Column(s)
project_user_user_id_project_id_unique Must be unique Asc/Asc user_id + project_id

Relationships

Close relationships within degrees of separation