observation_dependent_substrata

-1 rows


Description

For a completed observation and each substratum in its geometry snapshot, the prior (or same) observation whose substratum results should be rolled forward. A materialization of the “latest observation at or before this one that observed the substratum” relationship. A substratum observed in the observation itself is stored as a self-reference.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
observation_id int8 19 null
observations.id observation_dependent_substrata_observation_id_fkey C

The consuming observation whose rolled-up results use the depended-on data.
substratum_history_id int8 19 null
substratum_histories.id observation_dependent_substrata_substratum_history_id_fkey C

The substratum’s history in the consuming observation’s snapshot.
depends_on_observation_id int8 19 null
observations.id observation_dependent_substrata_depends_on_observation_id_fkey C

The observation whose substratum results are rolled forward; equals observation_id when the substratum was observed in the consuming observation.
depends_on_substratum_history_id int8 19 null
substratum_histories.id observation_dependent_substra_depends_on_substratum_histor_fkey C

The substratum’s history in the depended-on observation’s snapshot.

Indexes

Constraint Name Type Sort Column(s)
observation_dependent_substrata_pkey Primary key Asc/Asc observation_id + substratum_history_id
observation_dependent_substra_depends_on_observation_id_dep_idx Performance Asc/Asc depends_on_observation_id + depends_on_substratum_history_id

Relationships

Close relationships within degrees of separation