observation_media_files

-1 rows


Description

Observation-specific details about a photo or video of a monitoring plot. Generic metadata is in the files table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id int8 19 null
files.id observation_photos_file_id_fkey C
observation_id int8 19 null
observation_plots.observation_id observation_photos_observation_id_monitoring_plot_id_fkey R
observations.id observation_photos_observation_id_fkey R
monitoring_plot_id int8 19 null
monitoring_plots.id observation_photos_monitoring_plot_id_fkey R
observation_plots.monitoring_plot_id observation_photos_observation_id_monitoring_plot_id_fkey R
position_id int4 10 √ null
observation_plot_positions.id observation_photos_position_id_fkey R
type_id int4 10 null
observation_media_types.id observation_photos_type_id_fkey R
caption text 2147483647 √ null
is_original bool 1 null

If true, this photo was uploaded as part of the original observation data. If false, this photo was added after the observation.

Indexes

Constraint Name Type Sort Column(s)
observation_photos_pkey Primary key Asc file_id
observation_photos_file_id_idx Performance Asc file_id
observation_photos_monitoring_plot_id_idx Performance Asc monitoring_plot_id

Relationships

Close relationships within degrees of separation