project_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_role int4 10 null
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

Check Constraints

Constraint Name Constraint
project_user_project_role_check (((project_role >= 1) AND (project_role <= 4))) NOT VALID

Relationships

Close relationships within degrees of separation