stratum_histories

-1 rows


Description

Versions of stratum maps over time. Each time a planting site map changes, its strata’ maps are inserted into this table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
substratum_histories.stratum_history_id substratum_histories_stratum_history_id_fkey C
planting_site_history_id int8 19 null
planting_site_histories.id stratum_histories_planting_site_history_id_fkey C
stratum_id int8 19 √ null
strata.id stratum_histories_stratum_id_fkey N
name text 2147483647 null
boundary geometry 2147483647 null
area_ha numeric 0 √ null
stable_id text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
stratum_histories_pkey Primary key Asc id
stratum_histories_planting_site_history_id_idx Performance Asc planting_site_history_id
stratum_histories_stratum_id_idx Performance Asc stratum_id

Relationships

Close relationships within degrees of separation