Data Warehouse Schema
“event” table
DEPRECATIONS:
ev_plant_idcontaining label values (e.g. “CAAF”) is deprecated, in January 2020 this field will switch to proper alphanumeric IDs, please plan a transition toev_plant_labelto access the label.ev_conditions_site_idcontaining label values (e.g. “MO7_SAL”) is deprecated, in January 2020 this field will switch to proper alphanumeric IDs, please plan a transition toev_conditions_site_value_stringto access the label.ev_unit_idfield is deprecated, it will be removed in January 2020, please plan a transition toev_device_labelto access the current valueev_observed_atfield is deprecated, it will be removed in March 2020, please plan a transition toev_assay_task_definition_observed_atto access the current value
| field name | data type | description | sample value |
|---|---|---|---|
| ev_created_at | timestamptz | Date/time of record creation | 2019-05-01T22:17:41.961Z |
| ev_observed_at | timestamptz | Deprecated! use ev_assay_task_definition_observed_at |
2019-05-01T22:17:41.961Z |
| ev_reading_observed_at | timestamptz | Date/time of sample reading | 2019-05-01T22:17:41.961Z |
| ev_plant_id | varchar | Farm ID | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_plant_label | varchar | Farm label | "CAAF" |
| ev_assay_definition_id | varchar | Experiment | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_assay_definition_label | varchar | ” | "ALBOUT_144" |
| ev_assay_task_definition_id | varchar | Experiment Task | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_assay_task_definition_observed_at | timestamptz | Date/time of observation | 2019-05-01T22:17:41.961Z |
| ev_conditions_site_id | varchar | Site | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_conditions_site_value_string | varchar | ” | "MP12" |
| ev_conditions_site_unit | varchar | ” | "" |
| ev_conditions_strain_id | varchar | Strain | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_conditions_strain_value_string | varchar | ” | "STR24191" |
| ev_conditions_strain_unit | varchar | ” | "" |
| ev_conditions_dilution_id | varchar | Dilution | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_conditions_dilution_value_float | float | ” | 10 |
| ev_conditions_dilution_unit | varchar | ” | "ratio" |
| ev_conditions_phase_id | varchar | Phase | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_conditions_phase_value_string | varchar | ” | "replete" |
| ev_conditions_phase_unit | varchar | ” | "" |
| ev_conditions_media_id | varchar | Media | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_conditions_media_value_string | varchar | ” | "PM153" |
| ev_conditions_media_unit | varchar | ” | "" |
| ev_conditions_filtration_id | varchar | Filtration | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| ev_conditions_filtration_value_string | varchar | ” | "0.45-um" |
| ev_conditions_filtration_unit | varchar | ” | "" |
| ev_conditions_*_* | … | future additional conditions | … |
| ev_attribute | varchar | Measurement name | "toc" |
| ev_value_string | varchar | Measurement value (if string) | "" |
| ev_value_float | float | Measurement value (if numeric) | 54.98 |
| ev_unit | varchar | Measurement unit | "mg/L" |
| ev_data_type | varchar | Measurement data type | "decimal" |
| ev_device_id | varchar | Sensor ID | "9e4b1234-84e0-4f98-b0e3-79068c128ecd" |
| ev_device_label | varchar | Sensor label | "PBR110M_PH_4_400" |
| ev_unit_id | varchar | Deprecated! use ev_device_label |
"PBR110M_PH_4_400" |
“assay” table
TARGET VERSION: This section describes
POND Insights V2.1which hasn’t been published yet
| field name | data type | description | sample value |
|---|---|---|---|
| as_id | varchar | ID | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| as_created_at | timestamptz | Date/time of record creation | 2019-05-01T22:17:41.961Z |
| as_plant_id | varchar | Farm | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| as_label | varchar | Experiment Code | "ALBOUT_144" |
| as_name | varchar | Experiment Name | "STR24194 growing/scaling up in IP1250" |
“assay_task” table
TARGET VERSION: This section describes
POND Insights V2.1which hasn’t been published yet
| field name | data type | description | sample value |
|---|---|---|---|
| at_id | varchar | ID | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| at_created_at | timestamptz | Date/time of record creation | 2019-05-01T22:17:41.961Z |
| at_plant_id | varchar | Farm | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| at_name | varchar | Experiment Step Name | "OD Measurement" |
| at_frequency_begins_at | timestamptz | Experiment Step Starting date/time | 2019-05-01T22:17:41.961Z |
| at_frequency_ends_at | timestamptz | Experiment Step Ending date/time | 2019-05-01T22:17:41.961Z |
| at_frequency_expression | varchar | Experiment Step Recurring Schedule (cron format) | "30 8,12,16 * * 1-5" |
| at_frequency_tolerance | integer | Maximum delay between collection and reading (s) | 86400 |
| at_queue_id | varchar | Data Collection Queue | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |
| at_assay_definition_id | ID | Experiment | "3e0b6139-84e0-4f98-b0e3-79068c128ecd" |