Schema Version: 1.3

quantification_relationship


Description

There may be multiple rounds of quantification, this allows us to keep an audit trail of what values went where.

Columns

Column Type Size Foreign Key Nullable Default Comments
quantification_relationship_id bigserial 19
nextval('chado.quantification_relationship_quantification_relationship_id_seq'::regclass)
subject_id int8 19
quantification.quantification_id quantification_relationship_subject_id_fkey C
null
type_id int8 19
cvterm.cvterm_id quantification_relationship_type_id_fkey C
null
object_id int8 19
quantification.quantification_id quantification_relationship_object_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
quantification_relationship_pkey Primary key Asc quantification_relationship_id
quantification_relationship_c1 Must be unique Asc/Asc/Asc subject_id + object_id + type_id
quantification_relationship_idx1 Performance Asc subject_id
quantification_relationship_idx2 Performance Asc type_id
quantification_relationship_idx3 Performance Asc object_id

Relationships