GeneX Development Supported By
|
GeneX-2.0 DB: Array Table
|
GeneX-2.0 DB: Array Table
|
| Table Type | Inherits | Comment |
| DATA | Identifiable | The Array table describes the physical instantiation of an ArrayDesign |
| Column Information |
| Column Name | Full Name | Data Type | Not NULL | Comment |
| ad_fk | Array Design | int | true | The design on which this array is based |
| array_identifier | Array Identifier | char128 | false | the serial number or barcode for this chip or array |
| array_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) |
| manufacture_date | Manufacture date | datetime | false | when this chip or array was manufactured. |
| 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...) |
| spotter_hw_fk | Spotter Hardware | int | false | spotter hardware used to create layout |
| spotter_hw_params | Spotter Hardware Parameters | text | false | parameters given to spotter hardware to create layout |
| spotter_sw_fk | Spotter Software | int | false | spotter software used to create layout |
| spotter_sw_params | Spotter Software Parameters | text | false | parameters given to spotter software to create layout |
| technology_type | Technology Type | char128 | true | The choice of technology type will determine the way the curation tool expects the data to be structured. |
| tolerance | Tolerance | float | false | |
| Primary Key Information |
| Column Name |
| array_pk |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| ad_fk | ArrayDesign | ad_pk | MANY_TO_ONE |
| provider_con_fk | Contact | con_pk | MANY_TO_ONE |
| spotter_hw_fk | Hardware | param_pk | MANY_TO_ONE |
| spotter_sw_fk | Software | param_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| Index Information |
| Name | Column Name |
|