Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| bin_id | int8 | 19 | null |
|
|
Unique bin ID for the summary bin-frequency class |
||||
| bin_class | int4 | 10 | null |
|
|
Sequential numeric bin class identifier |
||||
| min_value | float8 | 17,17 | null |
|
|
Value of minimum/lower bound of bin interval |
||||
| max_value | float8 | 17,17 | null |
|
|
Value of maximum/upper bound of bin interval |
||||
| 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_data table |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| data_histogram_bin_info_pkey | Primary key | Asc/Asc/Asc | variable_id + bin_id + bin_class |
| data_histogram_bin_info_bin_id_bin_class_key | Must be unique | Asc/Asc | bin_id + bin_class |