lot_lot


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
del_delivery.lot_identifier fk_delivery_lot R
doc_unit.lot fk_doc_unit_lot_lot R
exc_import_report.lot fk_exc_import_report_lot R
plat_platform.lot fk_platform_lot R
label VARCHAR 255 √ NULL
code VARCHAR 191 √ NULL
type VARCHAR 255 √ NULL
description VARCHAR 2000 √ NULL
active BIT 1 √ NULL
status VARCHAR 255 √ NULL
cond_notes VARCHAR 255 √ NULL
num_notes VARCHAR 255 √ NULL
delivery_date_forseen TIMESTAMP 19 √ 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()
required_format VARCHAR 191 √ NULL
project VARCHAR 191 √ NULL
proj_project.identifier fk_lot_project R
active_configuration_ftp VARCHAR 191 √ NULL
conf_configuration_ftp.identifier fk_lot_configuration_ftp R
active_configuration_check VARCHAR 191 √ NULL
conf_configuration_check.identifier fk_lot_configuration_check R
required_colorspace VARCHAR 191 √ NULL
required_type_compression VARCHAR 191 √ NULL
required_taux_compression INT 10 √ NULL
required_resolution VARCHAR 191 √ NULL
provider VARCHAR 191 √ NULL
user_user.identifier fk_lot_provider R
collection_omeka VARCHAR 191 √ NULL
conf_lists_omeka.identifier fk_lot_coll_omeka R
items_omeka VARCHAR 191 √ NULL
conf_lists_omeka.identifier fk_lot_items_omeka R
active_configuration_export_ftp VARCHAR 191 √ NULL
conf_export_ftp.identifier fk_lot_configuration_export_ftp R
active_ocr_lang VARCHAR 191 √ NULL
conf_language_ocr.identifier fk_lot_ocr_lang R
collection_ia VARCHAR 191 √ NULL
conf_collection_ia.identifier fk_lot_coll_ia R
classement_pac VARCHAR 191 √ NULL
conf_classement_pac.identifier fk_lot_pac R
workflow_model VARCHAR 191 √ NULL
workflow_model.identifier fk_lot_workflow_model R
real_end_date DATE 10 √ NULL
files_archived BIT 1 b'0'
active_format_configuration VARCHAR 191 √ NULL
conf_views_format_configuration.identifier fk_lot_configuration_viewsformat R
omeka_configuration VARCHAR 191 √ NULL
conf_omeka.identifier fk_lot_omeka_conf R
active_export_ftp_delivery_folder VARCHAR 191 √ NULL
conf_delivery_folder.identifier lot_delivery_folder_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_lot_coll_ia Performance Asc collection_ia
fk_lot_coll_omeka Performance Asc collection_omeka
fk_lot_configuration_check Performance Asc active_configuration_check
fk_lot_configuration_export_ftp Performance Asc active_configuration_export_ftp
fk_lot_configuration_ftp Performance Asc active_configuration_ftp
fk_lot_configuration_viewsformat Performance Asc active_format_configuration
fk_lot_items_omeka Performance Asc items_omeka
fk_lot_ocr_lang Performance Asc active_ocr_lang
fk_lot_omeka_conf Performance Asc omeka_configuration
fk_lot_pac Performance Asc classement_pac
fk_lot_provider Performance Asc provider
fk_lot_workflow_model Performance Asc workflow_model
idx_lot_project Performance Asc project
lot_delivery_folder_fk Performance Asc active_export_ftp_delivery_folder
uniq_lot_lot_code Must be unique Asc code

Relationships

Close relationships within degrees of separation