review_assignment_assigner_join

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('review_assignment_assigner_join_id_seq'::regclass)
assigner_id int4 10 √ null
user.id review_assignment_assigner_join_assigner_id_fkeyR
organisation_id int4 10 √ null
organisation.id review_assignment_assigner_join_organisation_id_fkeyR
review_assignment_id int4 10 √ null
review_assignment.id review_assignment_assigner_join_review_assignment_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
review_assignment_assigner_join_pkey Primary key Asc id
unique_review_assignment_assigner_no_org Must be unique Asc/Asc assigner_id + review_assignment_id
unique_review_assignment_assigner_with_org Must be unique Asc/Asc/Asc assigner_id + organisation_id + review_assignment_id

Relationships

Close relationships within degrees of separation