observation_photos

-1 rows


Description

Observation-specific details about a photo 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
observations.id observation_photos_observation_id_fkey R
observation_plots.observation_id observation_photos_observation_id_monitoring_plot_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
gps_coordinates geometry 2147483647 √ null
type_id int4 10 null
observation_photo_types.id observation_photos_type_id_fkey R

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