Constraints

171 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_exc_csv_mapping_library
exc_csv_mapping.library
lib_library.identifier
Restrict delete
fk_doc_condreport_binding_value
doc_condreport_desc.value
doc_condreport_desc_value.identifier
Restrict delete
fk_doc_condreport_binding_property
doc_condreport_desc.property
doc_condreport_desc_property.identifier
Restrict delete
fk_doc_condreport_binding_detail
doc_condreport_desc.detail
doc_condreport_detail.identifier
Restrict delete
fk_delivery_lot
del_delivery.lot_identifier
lot_lot.identifier
Restrict delete
fk_delivery_multi_delivery
del_delivery.multi_lots_delivery
del_multi_lots_delivery.identifier
Restrict delete
fk_doc_condreport_attachment_report
doc_condreport_attachment.report
doc_condreport.identifier
Restrict delete
fk_exc_doc_unit_report
exc_doc_unit.report
exc_import_report.identifier
Restrict delete
fk_exc_doc_unit_doc_unit
exc_doc_unit.doc_unit
doc_unit.identifier
Restrict delete
fk_exc_template_library
exc_template.library
lib_library.identifier
Restrict delete
fk_doc_check_digital_document
doc_global_check.digital_document
doc_digital_document.identifier
Restrict delete
fk_platform_library
plat_platform.library
lib_library.identifier
Restrict delete
fk_platform_lot
plat_platform.lot
lot_lot.identifier
Restrict delete
fk_doc_workflow_model
doc_workflow.model
workflow_model.identifier
Restrict delete
fk_doc_archive_collection
doc_archive_collection.item
doc_archive_item.identifier
Restrict delete
fk_conf_sftp_library
conf_sftp.library
lib_library.identifier
Restrict delete
fk_library_project_library
proj_project_library.proj_library
lib_library.identifier
Restrict delete
fk_project_project_library
proj_project_library.project
proj_project.identifier
Restrict delete
fk_doc_condreport_slip_config_library
doc_condreport_slip_config.library
lib_library.identifier
Restrict delete
fk_exc_import_file_report
exc_import_file.report
exc_import_report.identifier
Restrict delete
fk_del_slip_config_library
del_slip_config.library
lib_library.identifier
Restrict delete
fk_proj_coll_ia
proj_project.collection_ia
conf_collection_ia.identifier
Restrict delete
fk_project_provider
proj_project.provider
user_user.identifier
Restrict delete
fk_project_configuration_ftp
proj_project.active_configuration_ftp
conf_configuration_ftp.identifier
Restrict delete
fk_project_configuration_export_ftp
proj_project.active_configuration_export_ftp
conf_export_ftp.identifier
Restrict delete
fk_proj_items_omeka
proj_project.items_omeka
conf_lists_omeka.identifier
Restrict delete
fk_project_configuration_check
proj_project.active_configuration_check
conf_configuration_check.identifier
Restrict delete
fk_project_configuration_viewsformat
proj_project.active_format_configuration
conf_views_format_configuration.identifier
Restrict delete
proj_delivery_folder_fk
proj_project.active_export_ftp_delivery_folder
conf_delivery_folder.identifier
Restrict delete
fk_proj_pac
proj_project.classement_pac
conf_classement_pac.identifier
Restrict delete
fk_project_workflow_model
proj_project.workflow_model
workflow_model.identifier
Restrict delete
fk_project_library
proj_project.library
lib_library.identifier
Restrict delete
fk_proj_omeka_conf
proj_project.omeka_configuration
conf_omeka.identifier
Restrict delete
fk_proj_coll_omeka
proj_project.collection_omeka
conf_lists_omeka.identifier
Restrict delete
conf_export_ftp_FK
conf_delivery_folder.conf_export_ftp
conf_export_ftp.identifier
Restrict delete
fk_check_automatic_result_digital_document
check_automatic_result.digital_document
doc_digital_document.identifier
Restrict delete
fk_check_automatic_result_doc_unit
check_automatic_result.doc_unit
doc_unit.identifier
Restrict delete
fk_check_automatic_result_delivery
check_automatic_result.delivery
del_delivery.identifier
Restrict delete
fk_check_automatic_result_check
check_automatic_result.check_type
check_automatic_type.identifier
Restrict delete
fk_check_automatic_result_physical_document
check_automatic_result.physical_document
doc_physical_document.identifier
Restrict delete
fk_check_automatic_result_page
check_automatic_result.page
doc_page.identifier
Restrict delete
fk_configuration_viewsformat_library
conf_views_format_configuration.library
lib_library.identifier
Restrict delete
fk_doc_digital_document_doc_unit
doc_digital_document.doc_unit
doc_unit.identifier
Restrict delete
fk_workflow_model_state_group
workflow_model_state.group
workflow_group.identifier
Restrict delete
fk_workflow_model_state_model
workflow_model_state.model
workflow_model.identifier
Restrict delete
fk_exc_mapping_library
exc_mapping.library
lib_library.identifier
Restrict delete
fk_report_prop_conf_lib
doc_condreport_property_config.library
lib_library.identifier
Restrict delete
fk_report_prop_conf_bind
doc_condreport_property_config.desc_property
doc_condreport_desc_property.identifier
Restrict delete
fk_exc_doc_unit_msg_imp_unit
exc_doc_unit_msg.imp_unit
exc_doc_unit.identifier
Restrict delete
fk_exc_import_report_mapping_perio
exc_import_report.mapping_children
exc_mapping.identifier
Restrict delete
fk_exc_import_report_parent
exc_import_report.parent
exc_import_report.identifier
Restrict delete
fk_exc_import_report_mapping
exc_import_report.mapping
exc_mapping.identifier
Restrict delete
fk_exc_import_report_library
exc_import_report.library
lib_library.identifier
Restrict delete
fk_exc_import_report_csv_mapping
exc_import_report.csv_mapping
exc_csv_mapping.identifier
Restrict delete
fk_exc_import_report_lot
exc_import_report.lot
lot_lot.identifier
Restrict delete
fk_exc_import_report_project
exc_import_report.project
proj_project.identifier
Restrict delete
fk_conf_email_library
conf_email.library
lib_library.identifier
Restrict delete
fk_del_slip_line
del_slip_line.slip
del_slip.identifier
Restrict delete
fk_doc_archive_contributor
doc_archive_contributor.item
doc_archive_item.identifier
Restrict delete
fk_conf_collection_ia
conf_collection_ia.conf_ia
conf_internet_archive.identifier
Restrict delete
fk_doc_physical_document_digital_digital
doc_physical_document_digital.physical_document
doc_physical_document.identifier
Restrict delete
fk_doc_physical_document_digital_physical
doc_physical_document_digital.digital_document
doc_digital_document.identifier
Restrict delete
fk_conf_omeka_library
conf_omeka.library
lib_library.identifier
Restrict delete
fk_doc_archive_header
doc_archive_header.item
doc_archive_item.identifier
Restrict delete
fk_exc_cines_report_doc_unit
exc_cines_report.doc_unit
doc_unit.identifier
Restrict delete
fk_role_authorization_authorization
user_role_authorization.user_authorization
user_authorization.identifier
Restrict delete
fk_role_authorization_role
user_role_authorization.role
user_role.identifier
Restrict delete
fk_doc_archive_subject
doc_archive_subject.item
doc_archive_item.identifier
Restrict delete
fk_doc_bibliographic_record_doc_unit
doc_bibliographic_record.doc_unit
doc_unit.identifier
Restrict delete
fk_doc_bibliographic_record_lib_library
doc_bibliographic_record.library
lib_library.identifier
Restrict delete
fk_lib_parameter_library
lib_parameter.library
lib_library.identifier
Restrict delete
fk_doc_archive_coverage
doc_archive_coverage.item
doc_archive_item.identifier
Restrict delete
fk_exc_internet_archive_report_doc_unit
exc_internet_archive_report.doc_unit
doc_unit.identifier
Restrict delete
fk_library_configuration_check
lib_library.active_configuration_check
conf_configuration_check.identifier
Restrict delete
fk_lib_address
lib_library.address
user_address.identifier
Restrict delete
fk_library_configuration_export_ftp
lib_library.active_configuration_export_ftp
conf_export_ftp.identifier
Restrict delete
fk_library_configuration_ocr_lang
lib_library.active_configuration_ocr_lang
conf_ocr_lang.identifier
Restrict delete
fk_lib_role
lib_library.role
user_role.identifier
Restrict delete
fk_library_configuration_ftp
lib_library.active_configuration_ftp
conf_configuration_ftp.identifier
Restrict delete
fk_exc_csv_mapping_rule_property
exc_csv_mapping_rule.property
doc_property_type.identifier
Restrict delete
fk_exc_csv_mapping_rule_mapping
exc_csv_mapping_rule.mapping
exc_csv_mapping.identifier
Restrict delete
fk_configuration_ftp_library
conf_configuration_ftp.library
lib_library.identifier
Restrict delete
fk_check_automatic_type_rule
conf_automatic_check_rule.check_type
check_automatic_type.identifier
Restrict delete
fk_conf_configuration_check_rule
conf_automatic_check_rule.check_configuration
conf_configuration_check.identifier
Restrict delete
fk_conf_conf_export_library
conf_export_ftp.library
lib_library.identifier
Restrict delete
fk_conf_lists_omeka
conf_lists_omeka.conf_omeka
conf_omeka.identifier
Restrict delete
fk_doc_workflow_state_workflow
doc_workflow_state.workflow
doc_workflow.identifier
Restrict delete
fk_doc_workflow_state_model_state
doc_workflow_state.model_state
workflow_model_state.identifier
Restrict delete
fk_lib_parameter_value_cines_lib_parameter
lib_parameter_value_cines.parameter
lib_parameter.identifier
Restrict delete
fk_check_slip_check_slip_lines
check_slip_line.check_slip
check_slip.identifier
Restrict delete
files_gestion_delivery_folder_fk
conf_files_gestion.active_export_ftp_delivery_folder
conf_delivery_folder.identifier
Restrict delete
fk_configuration_filesgestion_library
conf_files_gestion.library
lib_library.identifier
Restrict delete
files_gestion_export_ftp_conf_fk
conf_files_gestion.active_export_ftp_conf
conf_export_ftp.identifier
Restrict delete
fk_metadata_values_to_properties
image_metadata_values.metadata
image_metadata_properties.identifier
Restrict delete
fk_metadata_values_doc_unit
image_metadata_values.doc_unit
doc_unit.identifier
Restrict delete
fk_doc_archive_creator
doc_archive_creator.item
doc_archive_item.identifier
Restrict delete
fk_workflow_group_user_group
workflow_group_user.workflow_group
workflow_group.identifier
Restrict delete
fk_workflow_group_user_user
workflow_group_user.workflow_user
user_user.identifier
Restrict delete
fk_exc_doc_unit_dupl_imp
exc_doc_unit_dupl.imp_unit
exc_doc_unit.identifier
Restrict delete
fk_exc_doc_unit_dupl_doc
exc_doc_unit_dupl.doc_unit
doc_unit.identifier
Restrict delete
fk_project_project_platform
proj_project_platform.project
proj_project.identifier
Restrict delete
fk_platform_project_platform
proj_project_platform.proj_platform
plat_platform.identifier
Restrict delete
fk_user_library
user_user.library
lib_library.identifier
Restrict delete
fk_user_dashboard
user_user.dashboard
user_dashboard.identifier
Restrict delete
fk_user_role
user_user.role
user_role.identifier
Restrict delete
fk_user_address
user_user.address
user_address.identifier
Restrict delete
fk_doc_physical_document_doc_unit
doc_physical_document.doc_unit
doc_unit.identifier
Restrict delete
fk_doc_physical_document_train_train
doc_physical_document.train
train_train.identifier
Restrict delete
fk_conf_internet_archive_library
conf_internet_archive.library
lib_library.identifier
Restrict delete
fk_conf_configuration_ocr_lang
conf_activated_ocr_lang.ocr_lang_configuration
conf_ocr_lang.identifier
Restrict delete
fk_conf_ocr_lang_language
conf_activated_ocr_lang.ocr_language
conf_language_ocr.identifier
Restrict delete
fk_doc_condreport_detail_report
doc_condreport_detail.report
doc_condreport.identifier
Restrict delete
fk_page_parent
hlp_page.parent
hlp_page.identifier
Restrict delete
fk_conf_classement_pac
conf_classement_pac.conf_pac
conf_sftp.identifier
Restrict delete
fk_doc_archive_language
doc_archive_language.item
doc_archive_item.identifier
Restrict delete
fk_doc_check_slip_config_library
doc_check_slip_config.library
lib_library.identifier
Restrict delete
fk_conf_email_prop_conf
conf_email_prop.conf_id
conf_email.identifier
Restrict delete
fk_doc_page_sample
doc_page.sample
doc_sample.identifier
Restrict delete
fk_doc_page_digital_document
doc_page.digital_document
doc_digital_document.identifier
Restrict delete
fk_doc_property_record
doc_property.record
doc_bibliographic_record.identifier
Restrict delete
fk_doc_property_type
doc_property.type
doc_property_type.identifier
Restrict delete
fk_proj_user_project_user
proj_project_user.proj_user
user_user.identifier
Restrict delete
fk_project_project_user
proj_project_user.project
proj_project.identifier
Restrict delete
fk_sto_stored_file_page
sto_stored_file.page
doc_page.identifier
Restrict delete
fk_sto_stored_file_format_config
sto_stored_file.format_configuration
conf_views_format_configuration.identifier
Restrict delete
fk_lot_workflow_model
lot_lot.workflow_model
workflow_model.identifier
Restrict delete
fk_lot_ocr_lang
lot_lot.active_ocr_lang
conf_language_ocr.identifier
Restrict delete
fk_lot_configuration_ftp
lot_lot.active_configuration_ftp
conf_configuration_ftp.identifier
Restrict delete
fk_lot_provider
lot_lot.provider
user_user.identifier
Restrict delete
fk_lot_coll_ia
lot_lot.collection_ia
conf_collection_ia.identifier
Restrict delete
fk_lot_configuration_export_ftp
lot_lot.active_configuration_export_ftp
conf_export_ftp.identifier
Restrict delete
fk_lot_configuration_viewsformat
lot_lot.active_format_configuration
conf_views_format_configuration.identifier
Restrict delete
fk_lot_pac
lot_lot.classement_pac
conf_classement_pac.identifier
Restrict delete
lot_delivery_folder_fk
lot_lot.active_export_ftp_delivery_folder
conf_delivery_folder.identifier
Restrict delete
fk_lot_project
lot_lot.project
proj_project.identifier
Restrict delete
fk_lot_items_omeka
lot_lot.items_omeka
conf_lists_omeka.identifier
Restrict delete
fk_lot_configuration_check
lot_lot.active_configuration_check
conf_configuration_check.identifier
Restrict delete
fk_lot_coll_omeka
lot_lot.collection_omeka
conf_lists_omeka.identifier
Restrict delete
fk_lot_omeka_conf
lot_lot.omeka_configuration
conf_omeka.identifier
Restrict delete
fk_doc_unit_coll_omeka
doc_unit.collection_omeka
conf_lists_omeka.identifier
Restrict delete
fk_doc_unit_project
doc_unit.project
proj_project.identifier
Restrict delete
fk_doc_unit_ia_item
doc_unit.archive_item
doc_archive_item.identifier
Restrict delete
fk_doc_unit_coll_ia
doc_unit.collection_ia
conf_collection_ia.identifier
Restrict delete
fk_doc_unit_sibling
doc_unit.sibling
doc_unit_sibling.identifier
Restrict delete
fk_doc_unit_library
doc_unit.library
lib_library.identifier
Restrict delete
fk_doc_unit_items_omeka
doc_unit.items_omeka
conf_lists_omeka.identifier
Restrict delete
fk_doc_ocr_lang
doc_unit.active_ocr_lang
conf_language_ocr.identifier
Restrict delete
fk_doc_unit_exp_data
doc_unit.export_data
doc_export_data.identifier
Restrict delete
fk_doc_unit_lot_lot
doc_unit.lot
lot_lot.identifier
Restrict delete
fk_doc_unit_pac
doc_unit.classement_pac
conf_classement_pac.identifier
Restrict delete
fk_doc_unit_parent
doc_unit.parent
doc_unit.identifier
Restrict delete
fk_doc_unit_workflow
doc_unit.workflow
doc_workflow.identifier
Restrict delete
fk_doc_check_page
doc_check.page
doc_page.identifier
Restrict delete
fk_workflow_model_library
workflow_model.library
lib_library.identifier
Restrict delete
fk_doc_condreport_binding_value_property
doc_condreport_desc_value.property
doc_condreport_desc_property.identifier
Restrict delete
fk_workflow_group_library
workflow_group.library
lib_library.identifier
Restrict delete
fk_check_slip_delivered_document
del_delivered_document.check_slip
check_slip.identifier
Restrict delete
fk_del_delivered_document_delivery
del_delivered_document.delivery
del_delivery.identifier
Restrict delete
fk_del_delivered_document_digital
del_delivered_document.digital_document
doc_digital_document.identifier
Restrict delete
fk_doc_sample_delivery
doc_sample.delivery
del_delivery.identifier
Restrict delete
fk_doc_sample_digital_document
doc_sample.digital_document
doc_digital_document.identifier
Restrict delete
fk_doc_export_property
doc_export_property.record
doc_export_data.identifier
Restrict delete
fk_doc_export_property_type
doc_export_property.type
doc_property_type.identifier
Restrict delete
fk_doc_condreport_docunit
doc_condreport.doc_unit
doc_unit.identifier
Restrict delete
fk_configuration_check_library
conf_configuration_check.library
lib_library.identifier
Restrict delete
fk_conf_digital_library_library
conf_digital_library.library
lib_library.identifier
Restrict delete
fk_del_slip_delivery
del_slip.delivery
del_delivery.identifier
Restrict delete
fk_prop_conf_type_conf
doc_condreport_property_config_type.conf
doc_condreport_property_config.identifier
Restrict delete
fk_train_project
train_train.project
proj_project.identifier
Restrict delete
fk_exc_mapping_rule_property
exc_mapping_rule.property
doc_property_type.identifier
Restrict delete
fk_exc_mapping_rule_mapping
exc_mapping_rule.mapping
exc_mapping.identifier
Restrict delete

Check Constraints

Table Constraint Name Constraint