project_relationship

Columns

Related columns Constraint Comments

Search:

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()

Showing 1 to 5 of 5 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation