| Table: posterior_samples |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | χ | √ | nextval('posterior_samples_id_seq'::regclass) | Allows a posterior to be updated asynchronously (i.e. for a given PFT, not all variables have to have the same posterior_id). | |
| posterior_id | int8 | 19 | √ | χ | null | posteriors.id | |
| variable_id | int8 | 19 | √ | χ | null | variables.id | |
| pft_id | int8 | 19 | √ | χ | null | pfts.id | |
| parent_id | int8 | 19 | √ | χ | null | posterior_samples.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 | posterior_samples_pkey |
|
