Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date_time | timestamptz | 35,6 | null |
|
|
Date/time stamp of the tag data record |
||||||
| variable_id | int8 | 19 | null |
|
|
Unique variable identifier for the data record from the source eTUFF file ingested. The variable_id is based on observation or measurment variables listed in the observation_types table |
||||||
| variable_value | float8 | 17,17 | null |
|
|
Geophysical value of the observed tag variable record |
||||||
| submission_id | int8 | 19 | null |
|
|
Unique numeric ID assigned upon submission of a tag eTUFF data file for ingest/importation into Tagbase |
||||||
| tag_id | int8 | 19 | null |
|
|
Unique numeric Tag ID associated with the ingested tag data file |
||||||
| position_date_time | timestamptz | 35,6 | √ | null |
|
|
Date/time stamp of nearest matched associated positional record |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| data_time_series_pkey | Primary key | Asc/Asc/Asc/Asc | submission_id + tag_id + variable_id + date_time |
| data_time_series_date_time_index | Performance | Asc | date_time |
| data_time_series_pos_date_time_index | Performance | Asc | position_date_time |