file_transports

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_transport_id INT 10 √ null
vendor_edi_accounts.file_transport_id vendor_edi_accounts_ibfk_file_transport N
name VARCHAR 80 null
host VARCHAR 80 'localhost'
port INT 10 22
transport enum('ftp', 'sftp', 'local') 5 'sftp'
passive TINYINT 3 1
user_name VARCHAR 80 √ NULL
password MEDIUMTEXT 16777215 √ NULL
key_file MEDIUMTEXT 16777215 √ NULL
auth_mode enum('password', 'key_file', 'noauth') 8 'password'
download_directory MEDIUMTEXT 16777215 √ NULL
upload_directory MEDIUMTEXT 16777215 √ NULL
status LONGTEXT 2147483647 √ NULL
debug TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
file_transports_s_pk Primary key Asc file_transport_id
host_idx Performance Asc host
PRIMARY Must be unique Asc file_transport_id

Relationships

Close relationships within degrees of separation