Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| variable_id | bigserial | 19 | √ | nextval('observation_types_variable_id_seq'::regclass) |
|
|
Unique variable identifier based on the eTUFF tag data file specification |
|||||||||||
| variable_name | varchar | 255 | null |
|
|
Variable name based on the eTUFF tag data file specification |
||||||||||||
| standard_name | varchar | 255 | √ | null |
|
|
CF Standard name for observation variable, if available |
|||||||||||
| variable_source | varchar | 255 | √ | null |
|
|
Source authority for the given variables |
|||||||||||
| variable_units | varchar | 255 | √ | null |
|
|
Units of the variable based on the eTUFF tag data file specification |
|||||||||||
| notes | text | 2147483647 | √ | null |
|
|
Notes or comments relating to the variable |
|||||||||||
| standard_unit | varchar | 255 | √ | null |
|
|
CF canonical standard unit for observation variable, if available |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| observation_types_pkey | Primary key | Asc | variable_id |
| observation_types_variable_name_key | Must be unique | Asc | variable_name |