GUS Schema >> RAD::Element

Holds information about the element

column nulls? type description
ELEMENT_ID no NUMBER(10,0) primary key Edit
COMPOSITE_ELEMENT_ID RAD::CompositeElement (NUMBER(10,0) )FK to CompositeElement Edit
ARRAY_DESIGN_ID no RAD::ArrayDesign (NUMBER(4,0) ) Edit
DESIGN_ELEMENT_TYPE_ID Study::OntologyEntry (NUMBER(10,0) ) Edit
EXTERNAL_DATABASE_RELEASE_ID SRes::ExternalDatabaseRelease (NUMBER(10,0) )FK to SRES.ExternalDatabaseRelease. Identifies the version of the external database. Edit
SOURCE_ID STRING(50) unique identifier of the entry in the external database Edit
SUBCLASS_VIEW no STRING(27) name of the view Edit
PHYSICAL_BIOSEQUENCE_TYPE_ID Study::OntologyEntry (NUMBER(10,0) ) Edit
POLYMER_TYPE_ID Study::OntologyEntry (NUMBER(10,0) ) 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:

Platform
     RAD::ElementAnnotation
Quantified Data
     RAD::ElementResult

Subclasses:

RAD::SAGETagMapping
RAD::ShortOligo
RAD::Spot