Table: current_posteriors |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | bigserial | 19 | χ | √ | nextval('current_posteriors_id_seq'::regclass) | This table makes it easier to identify the 'latest' posterior for any PFT or other functional grouping. For example, if you query a specific PFT and project you get the list of variables that have been estimated and their (joint) posteriors. | |
pft_id | int8 | 19 | √ | χ | null | pfts.id | |
variable_id | int8 | 19 | √ | χ | null | variables.id | |
posteriors_samples_id | int8 | 19 | √ | χ | null | posterior_samples.id | |
project_id | int8 | 19 | √ | χ | null | projects.id | |
created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
updated_at | timestamp | 29,6 | √ | χ | utc_now() |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | current_posteriors_pkey |
![]() ![]() |