GeneX-2.0 DB: Array Table
GeneX-2.0 DB: Array Table
Table TypeInheritsComment
DATAIdentifiableThe Array table describes the physical instantiation of an ArrayDesign

Column Information
Column NameFull NameData TypeNot NULLComment
ad_fkArray DesigninttrueThe design on which this array is based
array_identifierArray Identifierchar128false the serial number or barcode for this chip or array
array_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)
manufacture_dateManufacture datedatetimefalse when this chip or array was manufactured.
mediumMediumchar128falsefurther specification of technology_type, e.g. glass slide, nylon filter
provider_con_fkProvider Contactinttruecontact information for product manufacturer (not necessarily commercial...)
spotter_hw_fkSpotter Hardwareintfalsespotter hardware used to create layout
spotter_hw_paramsSpotter Hardware Parameterstextfalseparameters given to spotter hardware to create layout
spotter_sw_fkSpotter Softwareintfalsespotter software used to create layout
spotter_sw_paramsSpotter Software Parameterstextfalseparameters given to spotter software to create layout
technology_typeTechnology Typechar128trueThe choice of technology type will determine the way the curation tool expects the data to be structured.
toleranceTolerancefloatfalse

Primary Key Information
Column Name
array_pk

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
ad_fkArrayDesignad_pkMANY_TO_ONE
provider_con_fkContactcon_pkMANY_TO_ONE
spotter_hw_fkHardwareparam_pkMANY_TO_ONE
spotter_sw_fkSoftwareparam_pkMANY_TO_ONE

Unique Column Information
Column Names

Index Information
NameColumn Name