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