analysis_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.
value
text
2147483647
√
null
analysis_relationship.value is for additional notes or comments.
rank
int4
10
0
analysis_relationship.rank is the ordering of subject analysiss with respect to the object analysis may be important where rank is used to order these; starts from zero.
Showing 1 to 6 of 6 entries
Table contained -1 rows
Indexes
Constraint Name
Type
Sort
Column(s)
analysis_relationship_pkey
Primary key
Asc
analysis_relationship_id
analysis_relationship_c1
Must be unique
Asc/Asc/Asc/Asc
subject_id + object_id + type_id + rank
analysis_relationship_idx1
Performance
Asc
subject_id
analysis_relationship_idx2
Performance
Asc
object_id
analysis_relationship_idx3
Performance
Asc
type_id
Showing 1 to 5 of 5 entries
Relationships
The following entity relationship (ER) diagram shows the relationships involving the analysis_relationship table.