| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | Warehouse identifier for this entity |
| ExperimentWID | BIGINT | NUMBER | No | Experiment entity |
| Data | LONGTEXT | CLOB | Yes | Data associated with experiment, in an unspecified format.
May be specified instead of or along with MageData.
|
| MageData | BIGINT | NUMBER | Yes | Data associated with experiment using MAGE structure.
May be specified instead of or along with Data.
|
| Role | VARCHAR | VARCHAR2(50) | No | Describes how data is used in experiment ex: 'green intensity', 'forward scatter', 'filter wavelength' |
| Kind | CHAR(1) | CHAR(1) | No | Characterizes relationship of data to experiment Enumerated Values:
O - Data is an observation C - Data is computed from an observation P - Data is a parameter to a procedure or compuatation M - Data is metadata describing other data |
| DateProduced | DATETIME | DATE | Yes | When the observation was taken, the computation was performed, etc. |
| OtherWID | BIGINT | NUMBER | Yes | WID of entity this experiment data is associated with.
If Kind='O', it is typically the sample or specimen being observed.
If Kind='P', it is typically another ExperimentData or ParameterizableApplication
that is parameterized by this entity. |
| DataSetWID | BIGINT | NUMBER | No | The data set this entity came from or is associated with |
| Table | Column |
|---|---|
| RelatedTerm | OtherWID |
| CitationWIDOtherWID | OtherWID |
| CommentTable | OtherWID |
| CrossReference | OtherWID |
| CrossReference | CrossWID |
| Description | OtherWID |
| DBID | OtherWID |
| SynonymTable | OtherWID |
| ToolAdvice | OtherWID |
| Name | Columns |
|---|---|
| EXPDATA_ExperimentWID | ExperimentWID |
| EXPDATA_Kind | Kind |
| EXPDATA_MageData | MageData |
| EXPDATA_OtherWID | OtherWID |
| EXPDATA_DS | DATASETWID |