GUS Schema >> RAD::Assay

Holds information about an individual hybridization (in the case of array platforms) or a single SAGE run. For array platforms, there is one assay per hybridization (whether single or multi-channel).

column nulls? type description
ASSAY_ID no NUMBER(8,0) primary key Edit
ARRAY_DESIGN_ID no RAD::ArrayDesign (NUMBER(4,0) ) Edit
PROTOCOL_ID RAD::Protocol (NUMBER(10,0) )FK to Protocol. Hybridization protocol. Edit
ASSAY_DATE DATEDate in which this assay was performed. Edit
ARRAY_IDENTIFIER STRING(100) For array platforms, the id of the array used in this assay within its batch. Edit
ARRAY_BATCH_IDENTIFIER STRING(100) For array platforms, the production batch to which the array used in this assay belongs. Edit
OPERATOR_ID no SRes::Contact (NUMBER(12,0) )FK to SRes::Contact. Person or lab who performed this assay. Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) ) Edit
SOURCE_ID STRING(50) the unique identifier of the entry in the external database Edit
NAME STRING(100) text descriptor for the entry Edit
DESCRIPTION STRING(500) text description of the entry Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Data Transformations and Analyses
     RAD::AssayAnalysis
Assay
     RAD::Acquisition
     RAD::AssayControl
     RAD::AssayParam
Experimental Design
     RAD::StudyAssay
     RAD::StudyDesignAssay
     RAD::StudyFactorValue
Biomaterials
     RAD::AssayBioMaterial
     RAD::AssayLabeledExtract

Subclasses: