| 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 |
| ArrayGroup_Fiducials | BIGINT | NUMBER | Yes | Represents 1..n association between ArrayGroup and Fiducial Association to the marks on the Array for alignment for the scanner. |
| Fiducial_FiducialType | BIGINT | NUMBER | Yes | Represents 1..1 association between Fiducial and OntologyEntry A descriptive string that indicates the type of a fiducial (e.g. the chrome border on an Affymetrix array, a laser ablation mark). |
| Fiducial_DistanceUnit | BIGINT | NUMBER | Yes | Represents 1..1 association between Fiducial and DistanceUnit The units the fiducial is measured in. |
| Fiducial_Position | BIGINT | NUMBER | Yes | Represents 1..1 association between Fiducial and Position The position, relative to the upper left corner, of the fiducial |
| Name | Columns |
|---|---|
| Fiducial1 | DataSetWID |
| Fiducial2 | ArrayGroup_Fiducials |
| Fiducial3 | Fiducial_FiducialType |
| Fiducial4 | Fiducial_DistanceUnit |
| Fiducial5 | Fiducial_Position |