Schema Version: 1.3

elementresult


Description

An element on an array produces a measurement when hybridized to a biomaterial (traceable through quantification_id). This is the base data from which tables that actually contain data inherit.

Columns

Column Type Size Foreign Key Nullable Default Comments
elementresult_id bigserial 19
nextval('chado.elementresult_elementresult_id_seq'::regclass)
element_id int8 19
element.element_id elementresult_element_id_fkey C
null
quantification_id int8 19
quantification.quantification_id elementresult_quantification_id_fkey C
null
signal float8 17,17
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
elementresult_pkey Primary key Asc elementresult_id
elementresult_c1 Must be unique Asc/Asc element_id + quantification_id
elementresult_idx1 Performance Asc element_id
elementresult_idx2 Performance Asc quantification_id
elementresult_idx3 Performance Asc signal

Relationships

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

Show relationships within degrees of separation