trading_partner_sftp

SFTP connection information for a trading partner.

Primary Key:

• trading_partner_sftp_id

Foreign Keys:

• trading_partner_id => trading_partner.trading_partner_id

Indexes:

• trading_partner_sftp_trading_partner_id_hostname_port_usern_idx (Unique) - trading_partner_id, hostname, port, username
• trading_partner_sftp_trading_partner_id_idx - trading_partner_id

Column	Data Type	Nullable	Indexed	Description
trading_partner_sftp_id	bigint	No	Yes	Snowflake ID of the SFTP configuration for a trading partner. Generated through expression:
trading_partner_id	bigint	No	Yes	Link to the trading partner record. Generated through expression:
hostname	text	No	Yes	- Generated through expression:
port	text	No	Yes	- Generated through expression:
username	text	No	Yes	- Generated through expression:
password	text	No	No	- Generated through expression:
private_key_path	text	No	No	- Generated through expression:
host_key_path	text	No	No	- Generated through expression:
additional_ciphers	text	No	No	- Generated through expression: