Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| observation_id | int8 | 19 | null |
|
|
||||||
| substratum_id | int8 | 19 | √ | null |
|
|
|||||
| substratum_history_id | int8 | 19 | null |
|
|
||||||
| total_live | int4 | 10 | null |
|
|
||||||
| total_dead | int4 | 10 | null |
|
|
||||||
| total_existing | int4 | 10 | null |
|
|
||||||
| permanent_live | int4 | 10 | null |
|
|
||||||
| survival_rate | int4 | 10 | √ | null |
|
|
|||||
| survival_rate_std_dev | int4 | 10 | √ | null |
|
|
|||||
| plant_density | int4 | 10 | √ | null |
|
|
|||||
| plant_density_std_dev | int4 | 10 | √ | null |
|
|
|||||
| survival_rate_area | numeric | 0 | √ | null |
|
|
This substratum’s area in hectares at the time of the observation. |
||||
| needs_recalculation | bool | 1 | false |
|
|
If true, this row and the species totals for the same observation and scope are stale and will be rebuilt by the observation results recalculation job. Existing values are the last computed ones. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| observation_substratum_results_pkey | Primary key | Asc/Asc | observation_id + substratum_history_id |
| observation_substratum_results_observation_id_idx | Performance | Asc | observation_id |
| observation_substratum_results_substratum_id_idx | Performance | Asc | substratum_id |