Schema Version: 1.3

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

Show relationships within degrees of separation