| 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 |
| ArrayDesign | BIGINT | NUMBER | Yes | Represents 1..n association between ArrayDesign and ProtocolApplication Describes the application of any protocols, such as the methodology used to pick oligos, in the design of the array. |
| ArrayManufacture | BIGINT | NUMBER | Yes | Represents 1..n association between ArrayManufacture and ProtocolApplication The protocols followed in the manufacturing of the arrays. |
| BioEvent_ProtocolApplications | BIGINT | NUMBER | Yes | Represents 1..n association between BioEvent and ProtocolApplication The applied protocols to the BioEvent. |
| SerialNumber | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute HardwareApplication.serialNumber Manufacturer's identifier for the Hardware. |
| Hardware | BIGINT | NUMBER | Yes | Represents n..1 association between HardwareApplication and Hardware The underlying hardware. |
| ActivityDate | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute ProtocolApplication.activityDate When the protocol was applied. |
| ProtocolApplication | BIGINT | NUMBER | Yes | Represents 1..n association between ProtocolApplication and HardwareApplication The use of hardware for the application of the protocol. |
| ProtocolApplication2 | BIGINT | NUMBER | Yes | Represents 1..n association between ProtocolApplication and SoftwareApplication The use of software for the application of the protocol. |
| Protocol | BIGINT | NUMBER | Yes | Represents n..1 association between ProtocolApplication and Protocol The protocol that is being used. |
| Version | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute SoftwareApplication.version The version of the software. |
| ReleaseDate | DATETIME | DATE | Yes | MAGE attribute SoftwareApplication.releaseDate When the software was released. |
| Software | BIGINT | NUMBER | Yes | Represents n..1 association between SoftwareApplication and Software The underlying software. |
| Table | Column |
|---|---|
| ParameterValue | ParameterizableApplication |
| ParameterizableApplication | ProtocolApplication |
| ParameterizableApplication | ProtocolApplication2 |
| ProtocolApplWIDPersonWID | ProtocolApplicationWID |
| Name | Columns |
|---|---|
| ParameterizableApplication1 | DataSetWID |
| ParameterizableApplication2 | MAGEClass |
| ParameterizableApplication3 | ArrayDesign |
| ParameterizableApplication4 | ArrayManufacture |
| ParameterizableApplication5 | BioEvent_ProtocolApplications |
| ParameterizableApplication6 | SerialNumber |
| ParameterizableApplication7 | Hardware |
| ParameterizableApplication8 | ActivityDate |
| ParameterizableApplication9 | ProtocolApplication |
| ParameterizableApplication10 | ProtocolApplication2 |
| ParameterizableApplication11 | Protocol |
| ParameterizableApplication12 | Version |
| ParameterizableApplication13 | ReleaseDate |
| ParameterizableApplication14 | Software |