observation_photos

0 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_fkeyC
observation_id int8 19 null
observation_plots.observation_id observation_photos_observation_id_monitoring_plot_id_fkeyR
observations.id observation_photos_observation_id_fkeyR
monitoring_plot_id int8 19 null
monitoring_plots.id observation_photos_monitoring_plot_id_fkeyR
observation_plots.monitoring_plot_id observation_photos_observation_id_monitoring_plot_id_fkeyR
position_id int4 10 null
observation_plot_positions.id observation_photos_position_id_fkeyR
gps_coordinates geometry 2147483647 √ null

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