GUS Schema >> RAD::Treatment

Holds an ordered set of wet-lab treatments on BioMaterials

column nulls? type description
TREATMENT_ID no NUMBER(10,0) primary key Edit
ORDER_NUM no NUMBER(3,0) The ordering number for this treatment with respect to set of treatments Edit
BIO_MATERIAL_ID no Study::BioMaterial (NUMBER(8,0) )FK to the BioMaterial directly generated by this treatment or generated by a series of treaments to which this treatment belongs. Edit
TREATMENT_TYPE_ID no Study::OntologyEntry (NUMBER(10,0) )FK to an ontology of possible types of treatments Edit
PROTOCOL_ID RAD::Protocol (NUMBER(10,0) )FK to a structured protocol for this treatment Edit
NAME STRING(100) An optional name for the treatment 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:

Biomaterials
     RAD::BioMaterialMeasurement
     RAD::TreatmentParam

Subclasses: