Table: File_Transfer_File
Contains files that are part of a File Transfer
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
file_transfer_file_KEYintNOT NULLunique and immutable primary key of this file provided by the Portal server which is also used as this table's primary key
file_transfer_KEYintNOT NULLFile Transfer that this file is a part of
file_transfer_file_status_KEYintNOT NULLStatus of this File
file_transfer_file_signature_status_KEYintNOT NULLStatus of the signature request for this file, if any
file_namenvarchar (260)NOT NULLFile name of this file
file_sizeintNOT NULLFile size of this file
source_pathnvarchar (260)NOT NULLThe original full path of this file at the time this file was uploaded as part of a File Transfer
source_machine_namenvarchar (50)NOT NULLThe original machine name from which the file was uploaded
signature_request_date_utcdatetimeThe time at which this file's signature request was created
signature_sign_date_utcdatetimeThe time at which this file's signature request was signed
signature_reject_date_utcdatetimeThe time at which this file's signature request was rejected
Primary key
NameColumnsDescription
PK_File_Transfer_File$file_transfer_file_KEYfile_transfer_file_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_File_Transfer_File$file_transfer_file_signature_status_KEYfile_transfer_file_signature_status_KEYIndex supports foreign key FK_File_Transfer_File__File_Transfer_File_Signature_Status__file_transfer_file_signature_status_KEY
IX_File_Transfer_File$file_transfer_file_status_KEYfile_transfer_file_status_KEYIndex supports foreign key FK_File_Transfer_File__File_Transfer_File_Status__file_transfer_file_status_KEY
IX_File_Transfer_File$file_transfer_KEYfile_transfer_KEYIndex supports foreign key FK_File_Transfer_File__File_Transfer__file_transfer_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_File_Transfer_File__File_Transfer__file_transfer_KEYfile_transfer_KEYFile_Transfer
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_File_Transfer_Event__File_Transfer_File__file_transfer_file_KEYfile_transfer_file_KEYFile_Transfer_Event

Schema diagram