Schema Version: 1.3 Module: chado

arraydesign


Description

General properties about an array. An array is a template used to generate physical slides, etc. It contains layout information, as well as global array properties, such as material (glass, nylon) and spot dimensions (in rows/columns).

Columns

Column Type Size Foreign Key Nullable Default Comments
arraydesign_id bigserial 19
nextval('mage.arraydesign_arraydesign_id_seq'::regclass)
manufacturer_id int8 19
contact.contact_id arraydesign_manufacturer_id_fkey C
null
platformtype_id int8 19
cvterm.cvterm_id arraydesign_platformtype_id_fkey C
null
substratetype_id int8 19
cvterm.cvterm_id arraydesign_substratetype_id_fkey N
√ null
protocol_id int8 19
protocol.protocol_id arraydesign_protocol_id_fkey N
√ null
dbxref_id int8 19
dbxref.dbxref_id arraydesign_dbxref_id_fkey N
√ null
name text 2147483647
null
version text 2147483647
√ null
description text 2147483647
√ null
array_dimensions text 2147483647
√ null
element_dimensions text 2147483647
√ null
num_of_elements int4 10
√ null
num_array_columns int4 10
√ null
num_array_rows int4 10
√ null
num_grid_columns int4 10
√ null
num_grid_rows int4 10
√ null
num_sub_columns int4 10
√ null
num_sub_rows int4 10
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
arraydesign_pkey Primary key Asc arraydesign_id
arraydesign_c1 Must be unique Asc name
arraydesign_idx1 Performance Asc manufacturer_id
arraydesign_idx2 Performance Asc platformtype_id
arraydesign_idx3 Performance Asc substratetype_id
arraydesign_idx4 Performance Asc protocol_id
arraydesign_idx5 Performance Asc dbxref_id

Relationships

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