Schema Version: 1.3

element


Description

Represents a feature of the array. This is typically a region of the array coated or bound to DNA.

Columns

Column Type Size Foreign Key Nullable Default Comments
element_id bigserial 19
nextval('chado.element_element_id_seq'::regclass)
feature_id int8 19
feature.feature_id element_feature_id_fkey N
√ null
arraydesign_id int8 19
arraydesign.arraydesign_id element_arraydesign_id_fkey C
null
type_id int8 19
cvterm.cvterm_id element_type_id_fkey N
√ null
dbxref_id int8 19
dbxref.dbxref_id element_dbxref_id_fkey N
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
element_pkey Primary key Asc element_id
element_c1 Must be unique Asc/Asc feature_id + arraydesign_id
element_idx1 Performance Asc feature_id
element_idx2 Performance Asc arraydesign_id
element_idx3 Performance Asc type_id
element_idx4 Performance Asc dbxref_id

Relationships

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

Show relationships within degrees of separation