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

View of ElementImp. View gives coordinate information for elements on a spotted array.

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
ARRAY_ROW STRING(5) Subarray row position for an element. Usually this is 1. Edit
ARRAY_COLUMN STRING(5) Subarray column position for an element. Usually this is 1. Edit
GRID_ROW STRING(5) Grid row position for an element. This is also known as Meta-row position. Edit
GRID_COLUMN STRING(5) Grid column position for an element. This is also known as Meta-column position. Edit
SUB_ROW STRING(5) Row position of the element within the grid. Edit
SUB_COLUMN STRING(5) Column position of the element within the grid. Edit
SEQUENCE_VERIFIED NUMBER(3,0) Flag to determine if the clone has been sequence verified. "1" if true, "0" if false. Edit
NAME STRING(500) text descriptor for the entry Edit
DESCRIPTION STRING(500) text description of the entry Edit

Child tables:

Subclasses: