GUS Schema >> RAD::ShortOligo (subclass of RAD::Element )

View of ElementImp. View gives co-ordinate information for oligos on arrays manufactured using photo lithography.

Light yellow rows indicate columns provided from the superclass.

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
NAME STRING(500) text descriptor for the entry Edit
MATCH NUMBER(3,0) indicates whether the element is the match or mis-match probe (0 for mismatch, 1 for match) Edit
X_POSITION STRING(50) the position of the element in the array grid for the x-axis Edit
Y_POSITION STRING(50) the position of the element in the array grid for the y-axis Edit
SEQUENCE STRING(100) the sequence of the oligo Edit
DESCRIPTION STRING(500) description of the entry Edit

Child tables: