published_activity_observation_media_files

-1 rows


Description

Observation-specific details about media files in published activities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id int8 19 null
files.id published_activity_observation_media_files_file_id_fkey R
activity_id int8 19 null
published_activities.activity_id published_activity_observation_media_files_activity_id_fkey R
monitoring_plot_id int8 19 null
monitoring_plots.id published_activity_observation_media_fi_monitoring_plot_id_fkey R
position_id int4 10 √ null
observation_plot_positions.id published_activity_observation_media_files_position_id_fkey R
type_id int4 10 null
observation_media_types.id published_activity_observation_media_files_type_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
published_activity_observation_media_files_pkey Primary key Asc file_id
published_activity_observation_media_fil_monitoring_plot_id_idx Performance Asc monitoring_plot_id
published_activity_observation_media_files_activity_id_idx Performance Asc activity_id

Relationships

Close relationships within degrees of separation