conf_export_ftp


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
conf_delivery_folder.conf_export_ftp conf_export_ftp_FK R
conf_files_gestion.active_export_ftp_conf files_gestion_export_ftp_conf_fk R
lib_library.active_configuration_export_ftp fk_library_configuration_export_ftp R
lot_lot.active_configuration_export_ftp fk_lot_configuration_export_ftp R
proj_project.active_configuration_export_ftp fk_project_configuration_export_ftp R
label VARCHAR 255 null
library VARCHAR 191 null
lib_library.identifier fk_conf_conf_export_library R
address VARCHAR 255 null
login VARCHAR 255 √ NULL
password VARCHAR 255 √ NULL
export_view BIT 1 b'0'
export_master BIT 1 b'0'
export_thumb BIT 1 b'0'
export_aip_sip BIT 1 b'0'
export_mets BIT 1 b'0'
export_pdf BIT 1 b'0'
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()
active BIT 1 √ b'1'
storage_server VARCHAR 255 √ NULL
port VARCHAR 255 √ NULL
export_alto BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
idx_conf_export_ftp_library Performance Asc library

Relationships

Close relationships within degrees of separation