GUS Schema >> RAD::StudyFactorValue

Holds information on the value of the factor being examined within a study design. This factor value can be either numerical or a term from the MGED Ontology (e.g. if comparing mouse strains then the factor value would be strain_or_line).

column nulls? type description
STUDY_FACTOR_VALUE_ID no NUMBER(8,0) Primary key Edit
STUDY_FACTOR_ID no Study::StudyFactor (NUMBER(5,0) )Foreign key to RAD3.StudyFactor Edit
ASSAY_ID no RAD::Assay (NUMBER(8,0) )Foreign key to RAD3.Assay Edit
VALUE_ONTOLOGY_ENTRY_ID Study::OntologyEntry (NUMBER(10,0) )Foreign key to RAD3.OntologyEntry Edit
STRING_VALUE STRING(100) The value of the measurement. Edit
MEASUREMENT_UNIT_OE_ID Study::OntologyEntry (NUMBER(10,0) )Foreign key to RAD3.OntologyEntry. Edit
MEASUREMENT_TYPE STRING(10) Attribute from MAGE-OM. Refers to the type of measurement, either "absolute" or "change". Edit
MEASUREMENT_KIND STRING(20) Attribute from MAGE-OM. Used to describe whether the measurement is a time, distance, temperature, quantity, mass, volume, concentration, or other measurement. Edit
CHANNEL_ID Study::OntologyEntry (NUMBER(10,0) )FK to RAD3.Channel. This provides a mechanism to associate a study factor value to a particular channel. 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:

Subclasses: