GeneX Development Supported By
|
GeneX-2.0 DB: ArrayDesign Table
|
GeneX-2.0 DB: ArrayDesign Table
|
| Table Type | Inherits | Comment |
| DATA | Identifiable | The 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 Name | Full Name | Data Type | Not NULL | Comment |
| ad_pk | Accession Number | serial | false | |
| coating | Coating | char128 | false | specifies method used to bind DNA to array |
| default_spot_conc | Default Spot Concentration | float | false | used if the manufacturer has standardized the concentrations of the probes on the array series |
| default_spot_conc_error | Default Spot Concentration Error | char128 | false | |
| default_spot_conc_units | Default Spot Concentration Units | char128 | false | |
| identifier_code | Identifier Code | char128 | false | catalog number for series, as opposed to serial number of particular instance (see PhysicalBioAssay) |
| medium | Medium | char128 | false | further specification of technology_type, e.g. glass slide, nylon filter |
| provider_con_fk | Provider Contact | int | true | contact information for product manufacturer (not necessarily commercial...) |
| technology_type | Technology Type | char128 | true | The 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 Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| provider_con_fk | Contact | con_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| name provider_con_fk |
| Index Information |
| Name | Column Name |
| provider_con_fk | arraydesign_provider_con_fk |
|