published_activity_observations

-1 rows


Description

Which published activities represent which observations. Top-level observation results are copied here as well since the underlying results could change after publication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
activity_id int8 19 null
published_activities.activity_id published_activity_observations_activity_id_fkey C
observation_id int8 19 null
observations.id published_activity_observations_observation_id_fkey C
live_plants int4 10 √ null
plant_density int4 10 √ null
survival_rate int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
published_activity_observations_pkey Primary key Asc activity_id
published_activity_observations_observation_id_key Must be unique Asc observation_id

Relationships

Close relationships within degrees of separation