project_internal_users

-1 rows


Description

Which users have which internal roles on a project.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_id int8 19 null
projects.id project_internal_users_project_id_fkey C
user_id int8 19 null
users.id project_internal_users_user_id_fkey R
project_internal_role_id int4 10 √ null
project_internal_roles.id project_internal_users_project_user_role_id_fkey R
role_name text 2147483647 √ null
created_time timestamptz 35,6 now()
modified_time timestamptz 35,6 now()
created_by int8 19 null
users.id project_internal_users_created_by_fkey R
modified_by int8 19 null
users.id project_internal_users_modified_by_fkey R

Indexes

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

Check Constraints

Constraint Name Constraint
project_internal_users_role_exclusive ((project_internal_role_id IS NULL) <> (role_name IS NULL))

Relationships

Close relationships within degrees of separation