Schema Version: 1.3 Module: chado

analysis_relationship


Columns

Column Type Size Foreign Key Nullable Default Comments
analysis_relationship_id bigserial 19
nextval('companalysis.analysis_relationship_analysis_relationship_id_seq'::regclass)
subject_id int8 19
analysis.analysis_id analysis_relationship_subject_id_fkey C
null

analysis_relationship.subject_id i s the subject of the subj-predicate-obj sentence.
object_id int8 19
analysis.analysis_id analysis_relationship_object_id_fkey C
null

analysis_relationship.object_id is the object of the subj-predicate-obj sentence.
type_id int8 19
cvterm.cvterm_id analysis_relationship_type_id_fkey C
null

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.

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

Relationships

The following entity relationship (ER) diagram shows the relationships involving the analysis_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