lib_library


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
conf_configuration_check.library fk_configuration_check_library R
conf_configuration_ftp.library fk_configuration_ftp_library R
conf_digital_library.library fk_conf_digital_library_library R
conf_email.library fk_conf_email_library R
conf_export_ftp.library fk_conf_conf_export_library R
conf_files_gestion.library fk_configuration_filesgestion_library R
conf_internet_archive.library fk_conf_internet_archive_library R
conf_omeka.library fk_conf_omeka_library R
conf_sftp.library fk_conf_sftp_library R
conf_views_format_configuration.library fk_configuration_viewsformat_library R
del_slip_config.library fk_del_slip_config_library R
doc_bibliographic_record.library fk_doc_bibliographic_record_lib_library R
doc_check_slip_config.library fk_doc_check_slip_config_library R
doc_condreport_property_config.library fk_report_prop_conf_lib R
doc_condreport_slip_config.library fk_doc_condreport_slip_config_library R
doc_unit.library fk_doc_unit_library R
exc_csv_mapping.library fk_exc_csv_mapping_library R
exc_import_report.library fk_exc_import_report_library R
exc_mapping.library fk_exc_mapping_library R
exc_template.library fk_exc_template_library R
lib_parameter.library fk_lib_parameter_library R
plat_platform.library fk_platform_library R
proj_project.library fk_project_library R
proj_project_library.proj_library fk_library_project_library R
user_user.library fk_user_library R
workflow_group.library fk_workflow_group_library R
workflow_model.library fk_workflow_model_library R
name VARCHAR 255 √ NULL
address VARCHAR 191 √ NULL
user_address.identifier fk_lib_address R
website VARCHAR 255 √ NULL
phone_number VARCHAR 255 √ NULL
email VARCHAR 255 √ NULL
prefix VARCHAR 255 √ NULL
number VARCHAR 255 √ NULL
active BIT 1 √ NULL
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
active_configuration_ftp VARCHAR 191 √ NULL
conf_configuration_ftp.identifier fk_library_configuration_ftp R
cines_service VARCHAR 255 √ NULL
active_configuration_check VARCHAR 191 √ NULL
conf_configuration_check.identifier fk_library_configuration_check R
role VARCHAR 191 √ NULL
user_role.identifier fk_lib_role R
institution VARCHAR 255 √ NULL
superuser BIT 1 √ NULL
active_configuration_export_ftp VARCHAR 191 √ NULL
conf_export_ftp.identifier fk_library_configuration_export_ftp R
active_configuration_ocr_lang VARCHAR 191 √ NULL
conf_ocr_lang.identifier fk_library_configuration_ocr_lang R
active_format_configuration VARCHAR 191 √ NULL
lib_resp_name VARCHAR 191 √ NULL
lib_resp_phone VARCHAR 191 √ NULL
lib_resp_email VARCHAR 191 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_lib_address Performance Asc address
fk_lib_role Performance Asc role
fk_library_configuration_check Performance Asc active_configuration_check
fk_library_configuration_export_ftp Performance Asc active_configuration_export_ftp
fk_library_configuration_ftp Performance Asc active_configuration_ftp
fk_library_configuration_ocr_lang Performance Asc active_configuration_ocr_lang

Relationships

Close relationships within degrees of separation