Constraints

73 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

helmholtz_ids_user_id_foreign

helmholtz_ids.user_id

Cascade on delete

annotation_sessions_transect_id_foreign

annotation_sessions.volume_id

Cascade on delete

transects_creator_id_foreign

volumes.creator_id

Null on delete

storage_requests_user_id_foreign

storage_requests.user_id

Cascade on delete

annotation_session_user_annotation_session_id_foreign

annotation_session_user.annotation_session_id

annotation_sessions.id

Cascade on delete

annotation_session_user_user_id_foreign

annotation_session_user.user_id

Cascade on delete

annotation_assistance_requests_user_id_foreign

annotation_assistance_requests.user_id

Cascade on delete

annotation_assistance_requests_receiver_id_foreign

annotation_assistance_requests.receiver_id

Null on delete

annotation_assistance_requests_annotation_id_foreign

annotation_assistance_requests.annotation_id

image_annotations.id

Cascade on delete

label_tree_authorized_project_project_id_foreign

label_tree_authorized_project.project_id

Cascade on delete

label_tree_authorized_project_label_tree_id_foreign

label_tree_authorized_project.label_tree_id

Cascade on delete

image_labels_label_id_foreign

image_labels.label_id

Restrict delete

image_labels_image_id_foreign

image_labels.image_id

Cascade on delete

image_labels_user_id_foreign

image_labels.user_id

Null on delete

images_transect_id_foreign

images.volume_id

Cascade on delete

maia_annotation_candidates_job_id_foreign

maia_annotation_candidates.job_id

Cascade on delete

maia_annotation_candidates_label_id_foreign

maia_annotation_candidates.label_id

Null on delete

maia_annotation_candidates_image_id_foreign

maia_annotation_candidates.image_id

Cascade on delete

maia_annotation_candidates_annotation_id_foreign

maia_annotation_candidates.annotation_id

image_annotations.id

Null on delete

reports_user_id_foreign

reports.user_id

Cascade on delete

storage_request_files_storage_request_id_foreign

storage_request_files.storage_request_id

storage_requests.id

Cascade on delete

labels_label_source_id_foreign

labels.label_source_id

label_sources.id

Restrict delete

labels_parent_id_foreign

labels.parent_id

Cascade on delete

labels_label_tree_id_foreign

labels.label_tree_id

Cascade on delete

lslogin_ids_user_id_foreign

lslogin_ids.user_id

Cascade on delete

maia_training_proposal_feature_vectors_job_id_foreign

maia_training_proposal_feature_vectors.job_id

Cascade on delete

user_disks_user_id_foreign

user_disks.user_id

Cascade on delete

pending_volumes_volume_id_foreign

pending_volumes.volume_id

Cascade on delete

pending_volumes_project_id_foreign

pending_volumes.project_id

Cascade on delete

pending_volumes_user_id_foreign

pending_volumes.user_id

Cascade on delete

maia_annotation_candidate_feature_vectors_job_id_foreign

maia_annotation_candidate_feature_vectors.job_id

Cascade on delete

label_tree_user_label_tree_id_foreign

label_tree_user.label_tree_id

Cascade on delete

label_tree_user_user_id_foreign

label_tree_user.user_id

Cascade on delete

annotation_labels_user_id_foreign

image_annotation_labels.user_id

Null on delete

annotation_labels_annotation_id_foreign

image_annotation_labels.annotation_id

image_annotations.id

Cascade on delete

annotation_labels_label_id_foreign

image_annotation_labels.label_id

Restrict delete

project_user_project_id_foreign

project_user.project_id

Cascade on delete

project_user_user_id_foreign

project_user.user_id

Cascade on delete

video_annotations_video_id_foreign

video_annotations.video_id

Cascade on delete

label_tree_project_label_tree_id_foreign

label_tree_project.label_tree_id

Cascade on delete

label_tree_project_project_id_foreign

label_tree_project.project_id

Cascade on delete

maia_jobs_user_id_foreign

maia_jobs.user_id

Null on delete

maia_jobs_volume_id_foreign

maia_jobs.volume_id

Cascade on delete

videos_volume_id_foreign

videos.volume_id

Cascade on delete

project_invitations_project_id_foreign

project_invitations.project_id

Cascade on delete

copria_color_sort_sequence_transect_id_foreign

color_sort_sequences.volume_id

Cascade on delete

annotations_image_id_foreign

image_annotations.image_id

Cascade on delete

label_tree_versions_label_tree_id_foreign

label_tree_versions.label_tree_id

Cascade on delete

video_labels_user_id_foreign

video_labels.user_id

Null on delete

video_labels_video_id_foreign

video_labels.video_id

Cascade on delete

video_labels_label_id_foreign

video_labels.label_id

Restrict delete

video_annotation_label_feature_vectors_label_tree_id_foreign

video_annotation_label_feature_vectors.label_tree_id

Restrict delete

video_annotation_label_feature_vectors_annotation_id_foreign

video_annotation_label_feature_vectors.annotation_id

video_annotations.id

Cascade on delete

video_annotation_label_feature_vectors_id_foreign

video_annotation_label_feature_vectors.id

video_annotation_labels.id

Cascade on delete

video_annotation_label_feature_vectors_label_id_foreign

video_annotation_label_feature_vectors.label_id

Restrict delete

image_annotation_label_feature_vectors_label_tree_id_foreign

image_annotation_label_feature_vectors.label_tree_id

Restrict delete

image_annotation_label_feature_vectors_label_id_foreign

image_annotation_label_feature_vectors.label_id

Restrict delete

image_annotation_label_feature_vectors_annotation_id_foreign

image_annotation_label_feature_vectors.annotation_id

image_annotations.id

Cascade on delete

image_annotation_label_feature_vectors_id_foreign

image_annotation_label_feature_vectors.id

image_annotation_labels.id

Cascade on delete

label_trees_version_id_foreign

label_trees.version_id

label_tree_versions.id

Cascade on delete

project_transect_project_id_foreign

project_volume.project_id

Restrict delete

project_transect_transect_id_foreign

project_volume.volume_id

Cascade on delete

federated_search_models_federated_search_instance_id_foreign

federated_search_models.federated_search_instance_id

federated_search_instances.id

Cascade on delete

nfdi_login_ids_user_id_foreign

nfdi_login_ids.user_id

Cascade on delete

projects_creator_id_foreign

projects.creator_id

Null on delete

video_annotation_labels_user_id_foreign

video_annotation_labels.user_id

Null on delete

video_annotation_labels_video_annotation_id_foreign

video_annotation_labels.annotation_id

video_annotations.id

Cascade on delete

video_annotation_labels_label_id_foreign

video_annotation_labels.label_id

Restrict delete

maia_training_proposals_image_id_foreign

maia_training_proposals.image_id

Cascade on delete

maia_training_proposals_job_id_foreign

maia_training_proposals.job_id

Cascade on delete

federated_search_model_user_federated_search_model_id_foreign

federated_search_model_user.federated_search_model_id

federated_search_models.id

Cascade on delete

federated_search_model_user_user_id_foreign

federated_search_model_user.user_id

Cascade on delete

api_tokens_owner_id_foreign

api_tokens.owner_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
volumes	volumes_media_type_check	(((media_type >= 1) AND (media_type <= 2))) NOT VALID
maia_annotation_candidates	maia_annotation_candidates_shape_check	(((shape >= 1) AND (shape <= 7))) NOT VALID
reports	reports_type_check	(((type >= 1) AND (type <= 16))) NOT VALID
pending_volumes	pending_volumes_media_type_check	(((media_type >= 1) AND (media_type <= 2))) NOT VALID
label_tree_user	label_tree_user_role_check	(((role >= 1) AND (role <= 4))) NOT VALID
project_user	project_user_project_role_check	(((project_role >= 1) AND (project_role <= 4))) NOT VALID
video_annotations	video_annotations_shape_check	(((shape >= 1) AND (shape <= 7))) NOT VALID
maia_jobs	maia_jobs_state_check	(((state >= 1) AND (state <= 6))) NOT VALID
users	users_role_check	(((role >= 1) AND (role <= 4))) NOT VALID
project_invitations	check_max_uses	(((max_uses IS NULL) OR (current_uses <= max_uses)))
project_invitations	project_invitations_role_check	(((role >= 1) AND (role <= 4))) NOT VALID
image_annotations	image_annotations_shape_check	(((shape >= 1) AND (shape <= 7))) NOT VALID
label_trees	label_trees_visibility_check	(((visibility >= 1) AND (visibility <= 2))) NOT VALID
federated_search_models	federated_search_models_type_check	(((type)::text = ANY ((ARRAY['Biigle\LabelTree'::character varying, 'Biigle\Project'::character varying, 'Biigle\Volume'::character varying])::text[])))
maia_training_proposals	maia_training_proposals_shape_check	(((shape >= 1) AND (shape <= 7))) NOT VALID