| Table: variables |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | χ | √ | nextval('variables_id_seq'::regclass) | ||
| description | varchar | 255 | χ | χ | ''::character varying | Description or definition of variable. | |
| units | varchar | 255 | χ | χ | ''::character varying | units in which data must be entered. | |
| notes | text | 2147483647 | χ | χ | ''::text | ||
| created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| name | varchar | 255 | χ | χ | variable name, this is the name used by PEcAn and in other modeling contexts. | ||
| max | varchar | 255 | χ | χ | 'Infinity'::character varying | ||
| min | varchar | 255 | χ | χ | '-Infinity'::character varying | ||
| standard_name | varchar | 255 | √ | χ | null | ||
| standard_units | varchar | 255 | √ | χ | null | ||
| label | varchar | 255 | √ | χ | null | ||
| type | varchar | 255 | √ | χ | null |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | variables_pkey |
|
