| 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 |
| Identifier | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Identifiable.identifier An identifier is an unambiguous string that is unique within the scope (i.e. a document, a set of related documents, or a repository) of its use. |
| Name | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Identifiable.name The potentially ambiguous common identifier. |
| FeatureGroup_Features | BIGINT | NUMBER | Yes | Represents 1..n association between FeatureGroup and Feature The features that belong to this group. |
| DesignElement_ControlType | BIGINT | NUMBER | Yes | Represents 1..1 association between DesignElement and OntologyEntry If the design element represents a control, the type of control it is (normalization, deletion, negative, positive, etc.) |
| Feature_Position | BIGINT | NUMBER | Yes | Represents 1..1 association between Feature and Position The position of the feature on the array, relative to the top, left corner. |
| Zone | BIGINT | NUMBER | Yes | Represents n..1 association between Feature and Zone A reference to the zone this feature is in. |
| Feature_FeatureLocation | BIGINT | NUMBER | Yes | Represents 1..1 association between Feature and FeatureLocation Location of this feature relative to a grid. |
| FeatureGroup | BIGINT | NUMBER | Yes | Represents n..1 association between Feature and FeatureGroup The features that belong to this group. |
| Reporter_WarningType | BIGINT | NUMBER | Yes | Represents 1..1 association between Reporter and OntologyEntry Similar to failType but indicates a warning rather than a failure. |
| Table | Column |
|---|---|
| FeatureDefect | Feature |
| ManufactureLIMS | Feature |
| SequencePosition | Composite |
| SequencePosition | Reporter |
| FeatureInformation | Feature |
| BioEvent | CompositeSequence |
| BioEvent | Reporter |
| BioEvent | CompositeSequence2 |
| DesignElementTuple | DesignElement |
| ComposGrpWIDComposSequenceWID | CompositeSequenceWID |
| ReporterGroupWIDReporterWID | ReporterWID |
| CompositeSeqWIDBioSeqWID | CompositeSequenceWID |
| ComposSeqWIDRepoComposMapWID | CompositeSequenceWID |
| ComposSeqWIDComposComposMapWID | CompositeSequenceWID |
| FeatureWIDFeatureWID | FeatureWID1 |
| FeatureWIDFeatureWID | FeatureWID2 |
| FeatureWIDFeatureWID2 | FeatureWID1 |
| FeatureWIDFeatureWID2 | FeatureWID2 |
| ReporterWIDBioSequenceWID | ReporterWID |
| ReporterWIDFeatureReporMapWID | ReporterWID |
| ComposSeqDimensWIDComposSeqWID | CompositeSequenceWID |
| FeatureDimensionWIDFeatureWID | FeatureWID |
| ReporterDimensWIDReporterWID | ReporterWID |
| Name | Columns |
|---|---|
| DesignElement1 | DataSetWID |
| DesignElement2 | MAGEClass |
| DesignElement3 | Identifier |
| DesignElement4 | Name |
| DesignElement5 | FeatureGroup_Features |
| DesignElement6 | DesignElement_ControlType |
| DesignElement7 | Feature_Position |
| DesignElement8 | Zone |
| DesignElement9 | Feature_FeatureLocation |
| DesignElement10 | FeatureGroup |
| DesignElement11 | Reporter_WarningType |