observation_requested_subzones

-1 rows


Description

If an observation should only cover a specific set of subzones, the subzone 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_subzones_observation_id_fkey C
planting_subzone_id int8 19 null
planting_subzones.id observation_requested_subzones_planting_subzone_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
observation_requested_subzones_pkey Primary key Asc/Asc observation_id + planting_subzone_id
observation_requested_subzones_planting_subzone_id_idx Performance Asc planting_subzone_id

Relationships

Close relationships within degrees of separation