conf_files_gestion


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
trigger_type VARCHAR 255 null
delay INT 10 null
destination_dir VARCHAR 255 NULL
delete_master BIT 1 b'0'
delete_print BIT 1 b'0'
delete_view BIT 1 b'0'
delete_thumb BIT 1 b'0'
save_master BIT 1 b'0'
save_print BIT 1 b'0'
save_view BIT 1 b'0'
save_thumb BIT 1 b'0'
library VARCHAR 191 NULL
lib_library.identifier fk_configuration_filesgestion_library R
version BIGINT 19 null
created_by VARCHAR 255 'system'
last_modified_by VARCHAR 255 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
delete_pdf BIT 1 b'0'
save_pdf BIT 1 b'0'
save_aip_sip BIT 1 b'0'
export_ftp BIT 1 b'0'
active_export_ftp_delivery_folder VARCHAR 191 NULL
conf_delivery_folder.identifier files_gestion_delivery_folder_fk R
active_export_ftp_conf VARCHAR 191 NULL
conf_export_ftp.identifier files_gestion_export_ftp_conf_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
files_gestion_delivery_folder_fk Performance Asc active_export_ftp_delivery_folder
files_gestion_export_ftp_conf_fk Performance Asc active_export_ftp_conf
fk_configuration_filesgestion_library Performance Asc library

Relationships