Schema Version: 1.3

nd_reagent_relationship


Description

Relationships between reagents. Some reagents form a group. i.e., they are used all together or not at all. Examples are adapter/linker/enzyme experiment reagents.

Columns

Column Type Size Foreign Key Nullable Default Comments
nd_reagent_relationship_id bigserial 19
nextval('chado.nd_reagent_relationship_nd_reagent_relationship_id_seq'::regclass)
subject_reagent_id int8 19
nd_reagent.nd_reagent_id nd_reagent_relationship_subject_reagent_id_fkey C
null

The subject reagent in the relationship. In parent/child terminology, the subject is the child. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object.
object_reagent_id int8 19
nd_reagent.nd_reagent_id nd_reagent_relationship_object_reagent_id_fkey C
null

The object reagent in the relationship. In parent/child terminology, the object is the parent. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object.
type_id int8 19
cvterm.cvterm_id nd_reagent_relationship_type_id_fkey C
null

The type (or predicate) of the relationship. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
nd_reagent_relationship_pkey Primary key Asc nd_reagent_relationship_id
nd_reagent_relationship_idx1 Performance Asc subject_reagent_id
nd_reagent_relationship_idx2 Performance Asc object_reagent_id
nd_reagent_relationship_idx3 Performance Asc type_id

Relationships

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

Show relationships within degrees of separation