image_sets

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
context_id uuid 2147483647 √ null
contexts.id image_sets_context_id_fkey N
project_id uuid 2147483647 √ null
projects.id image_sets_project_id_fkey N
event_id uuid 2147483647 √ null
events.id image_sets_event_id_fkey N
platform_id uuid 2147483647 √ null
platforms.id image_sets_platform_id_fkey N
sensor_id uuid 2147483647 √ null
sensors.id image_sets_sensor_id_fkey N
pi_id uuid 2147483647 √ null
pis.id image_sets_pi_id_fkey N
license_id uuid 2147483647 √ null
licenses.id image_sets_license_id_fkey N
camera_pose_id uuid 2147483647 √ null
image_camera_poses.id image_sets_camera_pose_id_fkey R
camera_housing_viewport_id uuid 2147483647 √ null
image_camera_housing_viewports.id image_sets_camera_housing_viewport_id_fkey R
flatport_parameter_id uuid 2147483647 √ null
image_flatport_parameters.id image_sets_flatport_parameter_id_fkey R
domeport_parameter_id uuid 2147483647 √ null
image_domeport_parameters.id image_sets_domeport_parameter_id_fkey R
photometric_calibration_id uuid 2147483647 √ null
image_photometric_calibrations.id image_sets_photometric_calibration_id_fkey R
camera_calibration_model_id uuid 2147483647 √ null
image_camera_calibration_models.id image_sets_camera_calibration_model_id_fkey R
local_path varchar 500 √ null
min_latitude_degrees float8 17,17 √ null
max_latitude_degrees float8 17,17 √ null
min_longitude_degrees float8 17,17 √ null
max_longitude_degrees float8 17,17 √ null
limits geometry 2147483647 √ 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
id uuid 2147483647 null
annotation_set_image_sets.image_set_id annotation_set_image_sets_image_set_id_fkey C
image_set_creators.image_set_id image_set_creators_image_set_id_fkey C
image_set_related_materials.image_set_id image_set_related_materials_image_set_id_fkey C
images.image_set_id images_image_set_id_fkey C
created_at timestamp 29,6 null
updated_at timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
image_sets_pkey Primary key Asc id
idx_image_sets_geom Performance Asc geom
idx_image_sets_limits Performance Asc limits
image_sets_id_key Must be unique Asc id
image_sets_name_key Must be unique Asc name
image_sets_sha256_hash_key Must be unique Asc sha256_hash

Relationships

Close relationships within degrees of separation