84 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| annotation_sessions_transect_id_foreign |
|
|
Cascade on delete | ||
| transects_media_type_id_foreign |
|
|
Restrict delete | ||
| transects_creator_id_foreign |
|
|
Null on delete | ||
| storage_requests_user_id_foreign |
|
|
Cascade on delete | ||
| annotation_session_user_annotation_session_id_foreign |
|
|
Cascade on delete | ||
| annotation_session_user_user_id_foreign |
|
|
Cascade on delete | ||
| annotation_assistance_requests_user_id_foreign |
|
|
Cascade on delete | ||
| annotation_assistance_requests_receiver_id_foreign |
|
|
Null on delete | ||
| annotation_assistance_requests_annotation_id_foreign |
|
|
Cascade on delete | ||
| label_tree_authorized_project_project_id_foreign |
|
|
Cascade on delete | ||
| label_tree_authorized_project_label_tree_id_foreign |
|
|
Cascade on delete | ||
| images_transect_id_foreign |
|
|
Cascade on delete | ||
| image_labels_label_id_foreign |
|
|
Restrict delete | ||
| image_labels_image_id_foreign |
|
|
Cascade on delete | ||
| image_labels_user_id_foreign |
|
|
Null on delete | ||
| maia_annotation_candidates_job_id_foreign |
|
|
Cascade on delete | ||
| maia_annotation_candidates_label_id_foreign |
|
|
Null on delete | ||
| maia_annotation_candidates_shape_id_foreign |
|
|
Restrict delete | ||
| maia_annotation_candidates_image_id_foreign |
|
|
Cascade on delete | ||
| maia_annotation_candidates_annotation_id_foreign |
|
|
Null on delete | ||
| reports_user_id_foreign |
|
|
Cascade on delete | ||
| reports_type_id_foreign |
|
|
Restrict delete | ||
| storage_request_files_storage_request_id_foreign |
|
|
Cascade on delete | ||
| labels_label_source_id_foreign |
|
|
Restrict delete | ||
| labels_parent_id_foreign |
|
|
Cascade on delete | ||
| labels_label_tree_id_foreign |
|
|
Cascade on delete | ||
| maia_training_proposal_feature_vectors_job_id_foreign |
|
|
Cascade on delete | ||
| lslogin_ids_user_id_foreign |
|
|
Cascade on delete | ||
| user_disks_user_id_foreign |
|
|
Cascade on delete | ||
| pending_volumes_media_type_id_foreign |
|
|
Restrict delete | ||
| pending_volumes_volume_id_foreign |
|
|
Cascade on delete | ||
| pending_volumes_project_id_foreign |
|
|
Cascade on delete | ||
| pending_volumes_user_id_foreign |
|
|
Cascade on delete | ||
| maia_annotation_candidate_feature_vectors_job_id_foreign |
|
|
Cascade on delete | ||
| label_tree_user_label_tree_id_foreign |
|
|
Cascade on delete | ||
| label_tree_user_role_id_foreign |
|
|
Restrict delete | ||
| label_tree_user_user_id_foreign |
|
|
Cascade on delete | ||
| annotation_labels_user_id_foreign |
|
|
Null on delete | ||
| annotation_labels_annotation_id_foreign |
|
|
Cascade on delete | ||
| annotation_labels_label_id_foreign |
|
|
Restrict delete | ||
| project_user_project_id_foreign |
|
|
Cascade on delete | ||
| project_user_project_role_id_foreign |
|
|
Restrict delete | ||
| project_user_user_id_foreign |
|
|
Cascade on delete | ||
| video_annotations_shape_id_foreign |
|
|
Restrict delete | ||
| video_annotations_video_id_foreign |
|
|
Cascade on delete | ||
| label_tree_project_label_tree_id_foreign |
|
|
Cascade on delete | ||
| label_tree_project_project_id_foreign |
|
|
Cascade on delete | ||
| maia_jobs_state_id_foreign |
|
|
Restrict delete | ||
| maia_jobs_user_id_foreign |
|
|
Null on delete | ||
| maia_jobs_volume_id_foreign |
|
|
Cascade on delete | ||
| users_role_id_foreign |
|
|
Restrict delete | ||
| videos_volume_id_foreign |
|
|
Cascade on delete | ||
| project_invitations_project_id_foreign |
|
|
Cascade on delete | ||
| project_invitations_role_id_foreign |
|
|
Restrict delete | ||
| copria_color_sort_sequence_transect_id_foreign |
|
|
Cascade on delete | ||
| annotations_shape_id_foreign |
|
|
Restrict delete | ||
| annotations_image_id_foreign |
|
|
Cascade on delete | ||
| label_tree_versions_label_tree_id_foreign |
|
|
Cascade on delete | ||
| video_labels_user_id_foreign |
|
|
Null on delete | ||
| video_labels_video_id_foreign |
|
|
Cascade on delete | ||
| video_labels_label_id_foreign |
|
|
Restrict delete | ||
| video_annotation_label_feature_vectors_label_tree_id_foreign |
|
|
Restrict delete | ||
| video_annotation_label_feature_vectors_annotation_id_foreign |
|
|
Cascade on delete | ||
| video_annotation_label_feature_vectors_id_foreign |
|
|
Cascade on delete | ||
| video_annotation_label_feature_vectors_label_id_foreign |
|
|
Restrict delete | ||
| image_annotation_label_feature_vectors_label_tree_id_foreign |
|
|
Restrict delete | ||
| image_annotation_label_feature_vectors_label_id_foreign |
|
|
Restrict delete | ||
| image_annotation_label_feature_vectors_annotation_id_foreign |
|
|
Cascade on delete | ||
| image_annotation_label_feature_vectors_id_foreign |
|
|
Cascade on delete | ||
| label_trees_visibility_id_foreign |
|
|
Restrict delete | ||
| label_trees_version_id_foreign |
|
|
Cascade on delete | ||
| project_transect_project_id_foreign |
|
|
Restrict delete | ||
| project_transect_transect_id_foreign |
|
|
Cascade on delete | ||
| federated_search_models_federated_search_instance_id_foreign |
|
|
Cascade on delete | ||
| projects_creator_id_foreign |
|
|
Null on delete | ||
| video_annotation_labels_user_id_foreign |
|
|
Null on delete | ||
| video_annotation_labels_video_annotation_id_foreign |
|
|
Cascade on delete | ||
| video_annotation_labels_label_id_foreign |
|
|
Restrict delete | ||
| maia_training_proposals_image_id_foreign |
|
|
Cascade on delete | ||
| maia_training_proposals_shape_id_foreign |
|
|
Restrict delete | ||
| maia_training_proposals_job_id_foreign |
|
|
Cascade on delete | ||
| federated_search_model_user_federated_search_model_id_foreign |
|
|
Cascade on delete | ||
| federated_search_model_user_user_id_foreign |
|
|
Cascade on delete | ||
| api_tokens_owner_id_foreign |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| project_invitations | check_max_uses | (((max_uses IS NULL) OR (current_uses <= max_uses))) |
| 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[]))) |