Constraints

47 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
annotation_set_creators_creator_id_fkey
annotation_set_creators.creator_id
creators.id
Cascade on delete
annotation_set_creators_annotation_set_id_fkey
annotation_set_creators.annotation_set_id
annotation_sets.id
Cascade on delete
annotation_set_image_sets_annotation_set_id_fkey
annotation_set_image_sets.annotation_set_id
annotation_sets.id
Cascade on delete
annotation_set_image_sets_image_set_id_fkey
annotation_set_image_sets.image_set_id
image_sets.id
Cascade on delete
image_creators_image_id_fkey
image_creators.image_id
images.id
Cascade on delete
image_creators_creator_id_fkey
image_creators.creator_id
creators.id
Cascade on delete
annotations_image_id_fkey
annotations.image_id
images.id
Cascade on delete
annotations_annotation_set_id_fkey
annotations.annotation_set_id
annotation_sets.id
Cascade on delete
annotation_sets_project_id_fkey
annotation_sets.project_id
projects.id
Null on delete
annotation_sets_license_id_fkey
annotation_sets.license_id
licenses.id
Null on delete
annotation_sets_pi_id_fkey
annotation_sets.pi_id
pis.id
Null on delete
annotation_sets_context_id_fkey
annotation_sets.context_id
contexts.id
Null on delete
annotation_labels_annotator_id_fkey
annotation_labels.annotator_id
annotators.id
Null on delete
annotation_labels_annotation_id_fkey
annotation_labels.annotation_id
annotations.id
Cascade on delete
annotation_labels_label_id_fkey
annotation_labels.label_id
labels.id
Cascade on delete
images_license_id_fkey
images.license_id
licenses.id
Null on delete
images_project_id_fkey
images.project_id
projects.id
Null on delete
images_platform_id_fkey
images.platform_id
platforms.id
Null on delete
images_sensor_id_fkey
images.sensor_id
sensors.id
Null on delete
images_context_id_fkey
images.context_id
contexts.id
Null on delete
images_camera_pose_id_fkey
images.camera_pose_id
image_camera_poses.id
Restrict delete
images_event_id_fkey
images.event_id
events.id
Null on delete
images_image_set_id_fkey
images.image_set_id
image_sets.id
Cascade on delete
images_camera_housing_viewport_id_fkey
images.camera_housing_viewport_id
image_camera_housing_viewports.id
Restrict delete
images_domeport_parameter_id_fkey
images.domeport_parameter_id
image_domeport_parameters.id
Restrict delete
images_camera_calibration_model_id_fkey
images.camera_calibration_model_id
image_camera_calibration_models.id
Restrict delete
images_photometric_calibration_id_fkey
images.photometric_calibration_id
image_photometric_calibrations.id
Restrict delete
images_pi_id_fkey
images.pi_id
pis.id
Null on delete
images_flatport_parameter_id_fkey
images.flatport_parameter_id
image_flatport_parameters.id
Restrict delete
labels_annotation_set_id_fkey
labels.annotation_set_id
annotation_sets.id
Cascade on delete
image_set_creators_creator_id_fkey
image_set_creators.creator_id
creators.id
Cascade on delete
image_set_creators_image_set_id_fkey
image_set_creators.image_set_id
image_sets.id
Cascade on delete
image_sets_photometric_calibration_id_fkey
image_sets.photometric_calibration_id
image_photometric_calibrations.id
Restrict delete
image_sets_pi_id_fkey
image_sets.pi_id
pis.id
Null on delete
image_sets_event_id_fkey
image_sets.event_id
events.id
Null on delete
image_sets_camera_housing_viewport_id_fkey
image_sets.camera_housing_viewport_id
image_camera_housing_viewports.id
Restrict delete
image_sets_domeport_parameter_id_fkey
image_sets.domeport_parameter_id
image_domeport_parameters.id
Restrict delete
image_sets_camera_calibration_model_id_fkey
image_sets.camera_calibration_model_id
image_camera_calibration_models.id
Restrict delete
image_sets_flatport_parameter_id_fkey
image_sets.flatport_parameter_id
image_flatport_parameters.id
Restrict delete
image_sets_sensor_id_fkey
image_sets.sensor_id
sensors.id
Null on delete
image_sets_camera_pose_id_fkey
image_sets.camera_pose_id
image_camera_poses.id
Restrict delete
image_sets_context_id_fkey
image_sets.context_id
contexts.id
Null on delete
image_sets_project_id_fkey
image_sets.project_id
projects.id
Null on delete
image_sets_license_id_fkey
image_sets.license_id
licenses.id
Null on delete
image_sets_platform_id_fkey
image_sets.platform_id
platforms.id
Null on delete
image_set_related_materials_material_id_fkey
image_set_related_materials.material_id
related_materials.id
Cascade on delete
image_set_related_materials_image_set_id_fkey
image_set_related_materials.image_set_id
image_sets.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
spatial_ref_sys spatial_ref_sys_srid_check (((srid > 0) AND (srid <= 998999)))