images

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
context_id uuid 2147483647 √ null
contexts.id images_context_id_fkey N
project_id uuid 2147483647 √ null
projects.id images_project_id_fkey N
event_id uuid 2147483647 √ null
events.id images_event_id_fkey N
platform_id uuid 2147483647 √ null
platforms.id images_platform_id_fkey N
sensor_id uuid 2147483647 √ null
sensors.id images_sensor_id_fkey N
pi_id uuid 2147483647 √ null
pis.id images_pi_id_fkey N
license_id uuid 2147483647 √ null
licenses.id images_license_id_fkey N
camera_pose_id uuid 2147483647 √ null
image_camera_poses.id images_camera_pose_id_fkey R
camera_housing_viewport_id uuid 2147483647 √ null
image_camera_housing_viewports.id images_camera_housing_viewport_id_fkey R
flatport_parameter_id uuid 2147483647 √ null
image_flatport_parameters.id images_flatport_parameter_id_fkey R
domeport_parameter_id uuid 2147483647 √ null
image_domeport_parameters.id images_domeport_parameter_id_fkey R
photometric_calibration_id uuid 2147483647 √ null
image_photometric_calibrations.id images_photometric_calibration_id_fkey R
camera_calibration_model_id uuid 2147483647 √ null
image_camera_calibration_models.id images_camera_calibration_model_id_fkey R
image_set_id uuid 2147483647 null
image_sets.id images_image_set_id_fkey C
id uuid 2147483647 null
annotations.image_id annotations_image_id_fkey C
image_creators.image_id image_creators_image_id_fkey C
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
name varchar 255 null
handle varchar 2147483647 √ null
copyright varchar 500 √ null
abstract text 2147483647 √ null
objective text 2147483647 √ null
target_environment text 2147483647 √ null
target_timescale text 2147483647 √ null
curation_protocol text 2147483647 √ null
sha256_hash varchar 64 √ null
date_time timestamp 29,6 √ null
geom geometry 2147483647 √ null
latitude float8 17,17 √ null
longitude float8 17,17 √ null
altitude_meters float8 17,17 √ null
coordinate_uncertainty_meters float8 17,17 √ null
entropy float8 17,17 √ null
particle_count int4 10 √ null
average_color _float8 17,17 √ null
mpeg7_color_layout _float8 17,17 √ null
mpeg7_color_statistic _float8 17,17 √ null
mpeg7_color_structure _float8 17,17 √ null
mpeg7_dominant_color _float8 17,17 √ null
mpeg7_edge_histogram _float8 17,17 √ null
mpeg7_homogeneous_texture _float8 17,17 √ null
mpeg7_scalable_color _float8 17,17 √ null
acquisition acquisitionenum 2147483647 √ null
quality qualityenum 2147483647 √ null
deployment deploymentenum 2147483647 √ null
navigation navigationenum 2147483647 √ null
scale_reference scalereferenceenum 2147483647 √ null
illumination illuminationenum 2147483647 √ null
pixel_magnitude pixelmagnitudeenum 2147483647 √ null
marine_zone marinezoneenum 2147483647 √ null
spectral_resolution spectralresenum 2147483647 √ null
capture_mode capturemodeenum 2147483647 √ null
fauna_attraction faunaattractionenum 2147483647 √ null
area_square_meters float8 17,17 √ null
meters_above_ground float8 17,17 √ null
acquisition_settings jsonb 2147483647 √ null
camera_yaw_degrees float8 17,17 √ null
camera_pitch_degrees float8 17,17 √ null
camera_roll_degrees float8 17,17 √ null
overlap_fraction float8 17,17 √ null
spatial_constraints text 2147483647 √ null
temporal_constraints text 2147483647 √ null
time_synchronisation text 2147483647 √ null
item_identification_scheme text 2147483647 √ null
visual_constraints text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
images_pkey Primary key Asc id
idx_images_geom Performance Asc geom
images_id_key Must be unique Asc id
images_name_key Must be unique Asc name
images_sha256_hash_key Must be unique Asc sha256_hash

Relationships

Close relationships within degrees of separation