substrata

-1 rows


Description

Regions within strata that are a convenient size for a planting operation. Typically <10Ha.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
monitoring_plot_histories.substratum_id monitoring_plot_histories_substratum_id_fkey N
monitoring_plots.substratum_id monitoring_plots_substratum_id_fkey N
observation_requested_substrata.substratum_id observation_requested_substrata_substratum_id_fkey C
observed_substratum_species_totals.substratum_id observed_substratum_species_totals_substratum_id_fkey C
plantings.substratum_id plantings_substratum_id_fkey C
substratum_histories.substratum_id substratum_histories_substratum_id_fkey N
substratum_populations.substratum_id substratum_populations_substratum_id_fkey C
stratum_id int8 19 null
strata.id substrata_stratum_id_fkey C

Which stratum this substratum is part of.
name text 2147483647 null

Short name of this substratum. This is often just a single letter and number. Must be unique within a stratum.
full_name text 2147483647 null
boundary geometry 2147483647 null

Boundary of the substratum. Coordinates always use SRID 4326 (WGS 84 latitude/longitude).
created_by int8 19 null
users.id substrata_created_by_fkey R

Which user created the substratum.
created_time timestamptz 35,6 null

When the substratum was originally created.
modified_by int8 19 null
users.id substrata_modified_by_fkey R

Which user most recently modified the substratum.
modified_time timestamptz 35,6 null

When the substratum was most recently modified.
planting_site_id int8 19 null
plantings.planting_site_id plantings_planting_site_id_substratum_id_fkey R
strata.planting_site_id substrata_planting_site_id_stratum_id_fkey R
planting_sites.id substrata_planting_site_id_fkey C

Which planting site this substratum is part of. This is the same as the planting site ID of this substratum’s stratum, but is duplicated here so it can be used as the target of a foreign key constraint.
area_ha numeric 0 null
planting_completed_time timestamptz 35,6 √ null
observed_time timestamptz 35,6 √ null

When an observation of a monitoring plot in the substratum was most recently completed.
stable_id text 2147483647 null

Substratum identifier that doesn’t change even if the substratum is renamed or edited. Defaults to the full name.

Indexes

Constraint Name Type Sort Column(s)
substrata_pkey Primary key Asc id
substrata_planting_site_id_id_key Must be unique Asc/Asc planting_site_id + id
substrata_planting_site_id_stable_id_key Must be unique Asc/Asc planting_site_id + stable_id
substrata_stratum_id_name_key Must be unique Asc/Asc stratum_id + name

Check Constraints

Constraint Name Constraint
area_positive (area_ha > (0)::numeric)

Relationships

Close relationships within degrees of separation