| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | Warehouse identifier for this entity |
| SpotWID | BIGINT | NUMBER | No | The location record is for this spot. |
| Xcoord | FLOAT | NUMBER | Yes | The x-coordinate of the spot on the gel. |
| Ycoord | FLOAT | NUMBER | Yes | The y-coordinate of the spot on the gel. |
| refGel | VARCHAR | VARCHAR2(1) | Yes | Y or N. A spot can be identified across multiple gels, so this columnn. is used to indicate whether the X/Y coords of this particular gel was used to determine the molecular weight and isolectric point for the spot. |
| ExperimentWID | BIGINT | NUMBER | No | Experiment entity Describes the gel conditions for this particular record. |
| DatasetWID | BIGINT | NUMBER | No | The dataset the entity is from |