Schema Version: 1.3

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('chado.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.

Show relationships within degrees of separation