stratum_species_targets

-1 rows


Description

Which species are intended to be planted in each stratum.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
planting_site_id int8 19 null
planting_sites.id stratum_species_targets_planting_site_id_fkey C
planting_site_species_targets.planting_site_id species_must_be_targeted_to_site C
strata.planting_site_id stratum_must_be_in_site C
stratum_id int8 19 null
strata.id stratum_species_targets_stratum_id_fkey C
species_id int8 19 null
planting_site_species_targets.species_id species_must_be_targeted_to_site C
species.id stratum_species_targets_species_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
stratum_species_targets_pkey Primary key Asc/Asc/Asc planting_site_id + stratum_id + species_id
stratum_species_targets_species_id_idx Performance Asc species_id
stratum_species_targets_stratum_id_idx Performance Asc stratum_id

Relationships

Close relationships within degrees of separation