| 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 |
| SeqFeature_Regions | BIGINT | NUMBER | Yes | Represents 1..n association between SeqFeature and SeqFeatureLocation Association to classes that describe the location with the sequence of the SeqFeature. |
| StrandType | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute SeqFeatureLocation.strandType Indicates the direction and/or type of the SeqFeature, i.e. whether it is in the 5' or 3' direction, is double stranded, etc. |
| SeqFeatureLocation_Subregions | BIGINT | NUMBER | Yes | Represents 1..n association between SeqFeatureLocation and SeqFeatureLocation Regions within the SeqFeature. |
| SeqFeatureLocation_Coordinate | BIGINT | NUMBER | Yes | Represents 1..1 association between SeqFeatureLocation and SequencePosition At which base pairs or amino acid this SeqFeature begins and ends. |
| Table | Column |
|---|---|
| SeqFeatureLocation | SeqFeatureLocation_Subregions |
| Name | Columns |
|---|---|
| SeqFeatureLocation1 | DataSetWID |
| SeqFeatureLocation2 | SeqFeature_Regions |
| SeqFeatureLocation3 | StrandType |
| SeqFeatureLocation4 | SeqFeatureLocation_Subregions |
| SeqFeatureLocation5 | SeqFeatureLocation_Coordinate |