Schema Version: 1.3 Module: chado

assay


Description

An assay consists of a physical instance of an array, combined with the conditions used to create the array (protocols, technician information). The assay can be thought of as a hybridization.

Columns

Column Type Size Foreign Key Nullable Default Comments
assay_id bigserial 19
nextval('mage.assay_assay_id_seq'::regclass)
arraydesign_id int8 19
arraydesign.arraydesign_id assay_arraydesign_id_fkey C
null
protocol_id int8 19
protocol.protocol_id assay_protocol_id_fkey N
√ null
assaydate timestamp 29,6
√ now()
arrayidentifier text 2147483647
√ null
arraybatchidentifier text 2147483647
√ null
operator_id int8 19
contact.contact_id assay_operator_id_fkey C
null
dbxref_id int8 19
dbxref.dbxref_id assay_dbxref_id_fkey N
√ null
name text 2147483647
√ null
description text 2147483647
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
assay_pkey Primary key Asc assay_id
assay_c1 Must be unique Asc name
assay_idx1 Performance Asc arraydesign_id
assay_idx2 Performance Asc protocol_id
assay_idx3 Performance Asc operator_id
assay_idx4 Performance Asc dbxref_id

Relationships

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