GUS Schema >> RAD::CompositeElementResult

Implementation table. Holds a summary value for the composite element view, i.e. if the composite element is a set of duplicate spots on the array, this might be the average intensity; or if the composite element is a set of affy probes in one probe set this might be the affy summary intensity for that probe set.

column nulls? type description
COMPOSITE_ELEMENT_RESULT_ID no NUMBER(10,0) primary key Edit
SUBCLASS_VIEW no STRING(27) Edit
COMPOSITE_ELEMENT_ID no RAD::CompositeElement (NUMBER(10,0) )FK to CompositeElement, the corresponding entry in the composite element view this result is referring to. Edit
QUANTIFICATION_ID no RAD::Quantification (NUMBER(8,0) )FK to quantification. There can be CompositeElementResult values without corresponding ElementResult's, as can be the case in summary values for Affy probe sets. 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:

Quantified Data
     RAD::ElementResult

Subclasses:

RAD::AffymetrixMAS4
RAD::SAGETagResult
RAD::RMAExpress
RAD::ProbeProfiler
RAD::MOIDResult
RAD::AffymetrixMAS5