Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| observation_id | int8 | 19 | null |
|
|
||||||
| stratum_id | int8 | 19 | √ | null |
|
|
|||||
| stratum_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 |
|
|
Total area in hectares of substrata whose observation results contributed to the survival rate. |
||||
| observed_density | int4 | 10 | √ | null |
|
|
Plant density (plants per hectare) based only on the plots observed in this observation, without carrying forward last-observed data for substrata that were not observed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| observation_stratum_results_pkey | Primary key | Asc/Asc | observation_id + stratum_history_id |
| observation_stratum_results_stratum_id_idx | Performance | Asc | stratum_id |