project_relationship

27 rows


Description

A project can be composed of several smaller scale projects

Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_relationship_id serial 10 √ nextval('project_relationship_project_relationship_id_seq'::regclass)
subject_project_id int4 10 null
project.project_id project_relationship_subject_project_id_fkey C
object_project_id int4 10 null
project.project_id project_relationship_object_project_id_fkey C
type_id int4 10 null
cvterm.cvterm_id project_relationship_type_id_fkey R

The type of relationship being stated, such as “is part of”.
create_date timestamp 29,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
project_relationship_pkey Primary key Asc project_relationship_id
project_relationship_c1 Must be unique Asc/Asc/Asc subject_project_id + object_project_id + type_id

Relationships

Close relationships within degrees of separation