Schema Version: 1.3 Module: chado

project_relationship


Description

Linking table for relating projects to each other. For example, a given project could be composed of several smaller subprojects

Columns

Column Type Size Foreign Key Nullable Default Comments
project_relationship_id bigserial 19
nextval('project.project_relationship_project_relationship_id_seq'::regclass)
subject_project_id int8 19
project.project_id project_relationship_subject_project_id_fkey C
null
object_project_id int8 19
project.project_id project_relationship_object_project_id_fkey C
null
type_id int8 19
cvterm.cvterm_id project_relationship_type_id_fkey R
null

The cvterm type of the relationship being stated, such as "part of".

Table contained -1 rows

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

The following entity relationship (ER) diagram shows the relationships involving the project_relationship table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation