conf_sftp


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
conf_classement_pac.conf_pac fk_conf_classement_pac R
label VARCHAR 255 null
library VARCHAR 191 null
lib_library.identifier fk_conf_sftp_library R
username VARCHAR 255 √ NULL
password VARCHAR 255 √ NULL
host VARCHAR 255 √ NULL
port INT 10 √ NULL
target_dir VARCHAR 255 √ NULL
active BIT 1 b'1'
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()

Indexes

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

Relationships

Close relationships within degrees of separation