Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
||||||
| bin_id | int8 | 19 | null |
|
|
Unique bin ID for the summary bin-frequency class |
||||||
| bin_class | int4 | 10 | null |
|
|
Sequential numeric bin class identifier |
||||||
| date_time | timestamptz | 35,6 | null |
|
|
Date/time stamp of the tag summarized bin-frequency data record |
||||||
| variable_value | float8 | 17,17 | null |
|
|
Aggregate measure for the given bin-interval of the geophysical value of the observed tag variable record |
||||||
| position_date_time | timestamptz | 35,6 | √ | null |
|
|
Date/time stamp of nearest matched associated positional 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. Note that records in this table are NOT expected to be equivalent to those in the variable_id column of the data_histogram_bin_info table |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| data_histogram_bin_data_pkey | Primary key | Asc/Asc/Asc/Asc/Asc/Asc | submission_id + tag_id + bin_id + bin_class + date_time + variable_id |
| data_histogram_bin_data_date_time_index | Performance | Asc | date_time |
| data_histogram_bin_data_pos_date_time_index | Performance | Asc | position_date_time |