| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | Warehouse identifier for this entity |
| DataSetWID | BIGINT | NUMBER | No | Reference to the data set from which the entity came from |
| MAGEClass | VARCHAR | VARCHAR2(100) | No | Discriminator column specifies type of object this row represents |
| Start_ | SMALLINT | NUMBER | Yes | MAGE attribute SequencePosition.start The location of the base, for nucleotides, that the SeqFeature starts. |
| End | SMALLINT | NUMBER | Yes | MAGE attribute SequencePosition.end The location of the base, for nucleotides, that the SeqFeature ends. |
| CompositeCompositeMap | BIGINT | NUMBER | Yes | Represents 1..n association between CompositeCompositeMap and CompositePosition Association to the CompositeSequences that compose this CompositeSequence and where those CompositeSequences occur. |
| Composite | BIGINT | NUMBER | Yes | Represents n..1 association between CompositePosition and CompositeSequence A source CompositeSequence that is part of a target CompositeSequence |
| ReporterCompositeMap | BIGINT | NUMBER | Yes | Represents 1..n association between ReporterCompositeMap and ReporterPosition Association to the reporters that compose this CompositeSequence and where those reporters occur. |
| Reporter | BIGINT | NUMBER | Yes | Represents n..1 association between ReporterPosition and Reporter A reporter that comprises part of a CompositeSequence. |
| Table | Column |
|---|---|
| SeqFeatureLocation | SeqFeatureLocation_Coordinate |
| MismatchInformation | CompositePosition |
| MismatchInformation | ReporterPosition |
| Name | Columns |
|---|---|
| SequencePosition1 | DataSetWID |
| SequencePosition2 | MAGEClass |
| SequencePosition3 | Start_ |
| SequencePosition4 | End |
| SequencePosition5 | CompositeCompositeMap |
| SequencePosition6 | Composite |
| SequencePosition7 | ReporterCompositeMap |
| SequencePosition8 | Reporter |