substratum_histories

-1 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
monitoring_plot_histories.substratum_history_id monitoring_plot_histories_substratum_history_id_fkey C
observation_substratum_results.substratum_history_id observation_substratum_results_substratum_history_id_fkey C
observed_substratum_species_totals.substratum_history_id observed_substratum_species_totals_substratum_history_id_fkey C
simplified_substratum_histories.substratum_history_id simplified_substratum_histories_substratum_history_id_fkey C
stratum_history_id int8 19 null
stratum_histories.id substratum_histories_stratum_history_id_fkey C
substratum_id int8 19 √ null
substrata.id substratum_histories_substratum_id_fkey N
name text 2147483647 null
full_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)
substratum_histories_pkey Primary key Asc id
substratum_histories_stratum_history_id_idx Performance Asc stratum_history_id
substratum_histories_substratum_id_idx Performance Asc substratum_id

Relationships

Close relationships within degrees of separation