| 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. |
| URI | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Contact.URI |
| Address | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Contact.address |
| Phone | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Contact.phone |
| TollFreePhone | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Contact.tollFreePhone |
| VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Contact.email |
|
| Fax | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Contact.fax |
| Parent | BIGINT | NUMBER | Yes | Represents n..1 association between Organization and Organization The containing organization (the university or business which a lab belongs to, etc.) |
| LastName | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Person.lastName |
| FirstName | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Person.firstName |
| MidInitials | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Person.midInitials |
| Affiliation | BIGINT | NUMBER | Yes | Represents n..1 association between Person and Organization The organization a person belongs to. |
| Table | Column |
|---|---|
| FlowCytometrySample | ManufacturerWID |
| Experiment | ContactWID |
| Contact | Parent |
| Contact | Affiliation |
| ArrayDesignWIDContactWID | ContactWID |
| ExperimentWIDContactWID | ContactWID |
| DatabaseWIDContactWID | ContactWID |
| ArrayManufactureWIDContactWID | ContactWID |
| BioSourceWIDContactWID | ContactWID |
| HardwareWIDContactWID | ContactWID |
| ProtocolApplWIDPersonWID | PersonWID |
| SoftwareWIDContactWID | ContactWID |
| RelatedTerm | OtherWID |
| CitationWIDOtherWID | OtherWID |
| CommentTable | OtherWID |
| CrossReference | OtherWID |
| CrossReference | CrossWID |
| Description | OtherWID |
| DBID | OtherWID |
| SynonymTable | OtherWID |
| ToolAdvice | OtherWID |
| Name | Columns |
|---|---|
| Contact1 | DataSetWID |
| Contact2 | MAGEClass |
| Contact3 | Identifier |
| Contact4 | Name |
| Contact5 | URI |
| Contact6 | Address |
| Contact7 | Phone |
| Contact8 | TollFreePhone |
| Contact9 | |
| Contact10 | Fax |
| Contact11 | Parent |
| Contact12 | LastName |
| Contact13 | FirstName |
| Contact14 | MidInitials |
| Contact15 | Affiliation |