Table 5.
Results table data fields: this table was used to record the results of an assay. Each row in results referenced an assay by DOI and ID. Since an assay could have multiple results, each row in results was given an incrementing ID to serve as the primary key. The ResultName field specified what kind of result, or endpoint, was being reported (e.g., size, pH, mortality, LD50, etc.). ResultDetails included any additional information that ResultName could not capture. Finally, the seven fields used to capture raw and processed measurement data from the material table were used here to describe the result measurement or assessment
| Results table | Description |
|---|---|
| ResultID | Unique (within publication) numerical identifier for the result data |
| ResultType | Type of results reported (e.g., viability) |
| ResultDetails | Any optional notes about the result |
| ResultValue | Numeric value of the reported result |
| ResultApproxSymbol | Used to note when a measurement is above or below the physical detection limits of the methods or machinery used (e.g., >, <, =) |
| ResultUnit | The units of the reported value |
| ResultUncertainty | States what uncertainty type is reported with the value, such as standard deviation or a range |
| ResultLow | Holds the values described by result uncertainty. For ranges, this field holds the lower endpoint. If the uncertainty only reports one value (such as standard deviation), this field holds that value |
| ResultHigh | Holds the upper endpoint for values described by result uncertainty. It is left blank for uncertainties with only one value reported |
| assay_AssayID | Reference to the assay ID of the assay this result came from |
| assay_publication_DOI | Reference to DOI of the assay’s source publication |