observation_requested_substrata

-1 rows


Description

If an observation should only cover a specific set of substrata, the substratum IDs are stored here. If an observation is of the entire site (the default), there will be no rows for that observation in this table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
observation_id int8 19 null
observations.id observation_requested_substrata_observation_id_fkey C
substratum_id int8 19 null
substrata.id observation_requested_substrata_substratum_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
observation_requested_substrata_pkey Primary key Asc/Asc observation_id + substratum_id
observation_requested_substrata_substratum_id_idx Performance Asc substratum_id

Relationships

Close relationships within degrees of separation