GeneX-2.0 DB: ArrayDesign Table
GeneX-2.0 DB: ArrayDesign Table
Table TypeInheritsComment
DATAIdentifiableThe ArrayDesign table describes the template or model from which any number of physically distinct (but conceptually identical) instances of Arrays (e.g. glass slide or chip) are derived. Each of its individual spots is described by a row in the ArrayDesignSpots table, while a physical instance of the ArrayDesign that has been used in an experiment is described by a row in the PhysicalBioAssay table. The ArrayDesign and ArrayDesignSpots tables are built from the information contained in the GOD file.

Column Information
Column NameFull NameData TypeNot NULLComment
ad_pkAccession Numberserialfalse
coatingCoatingchar128falsespecifies method used to bind DNA to array
default_spot_concDefault Spot Concentrationfloatfalseused if the manufacturer has standardized the concentrations of the probes on the array series
default_spot_conc_errorDefault Spot Concentration Errorchar128false
default_spot_conc_unitsDefault Spot Concentration Unitschar128false
identifier_codeIdentifier Codechar128falsecatalog number for series, as opposed to serial number of particular instance (see PhysicalBioAssay)
mediumMediumchar128falsefurther specification of technology_type, e.g. glass slide, nylon filter
provider_con_fkProvider Contactinttruecontact information for product manufacturer (not necessarily commercial...)
technology_typeTechnology Typechar128trueThe choice of technology type will determine the way the curation tool expects the data to be structured.

Primary Key Information
Column Name
ad_pk

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
provider_con_fkContactcon_pkMANY_TO_ONE

Unique Column Information
Column Names
name provider_con_fk

Index Information
NameColumn Name
provider_con_fkarraydesign_provider_con_fk