Table: File_Transfer_File
Contains files that are part of a File Transfer
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
file_transfer_file_KEY | int | NOT NULL | unique and immutable primary key of this file provided by the Portal server which is also used as this table's primary key
file_transfer_KEY | int | NOT NULL | File Transfer that this file is a part of
file_transfer_file_status_KEY | int | NOT NULL | Status of this File
file_transfer_file_signature_status_KEY | int | NOT NULL | Status of the signature request for this file, if any
file_name | nvarchar (260) | NOT NULL | File name of this file
file_size | int | NOT NULL | File size of this file
source_path | nvarchar (260) | NOT NULL | The original full path of this file at the time this file was uploaded as part of a File Transfer
source_machine_name | nvarchar (50) | NOT NULL | The original machine name from which the file was uploaded
signature_request_date_utc | datetime |  | The time at which this file's signature request was created
signature_sign_date_utc | datetime |  | The time at which this file's signature request was signed
signature_reject_date_utc | datetime |  | The time at which this file's signature request was rejected

Primary key
Name | Columns | Description
PK_File_Transfer_File$file_transfer_file_KEY | file_transfer_file_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_File_Transfer_File$file_transfer_file_signature_status_KEY | file_transfer_file_signature_status_KEY | Index 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_KEY | file_transfer_file_status_KEY | Index supports foreign key FK_File_Transfer_File__File_Transfer_File_Status__file_transfer_file_status_KEY
IX_File_Transfer_File$file_transfer_KEY | file_transfer_KEY | Index supports foreign key FK_File_Transfer_File__File_Transfer__file_transfer_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_File_Transfer_File__File_Transfer__file_transfer_KEY | file_transfer_KEY | File_Transfer |
FK_File_Transfer_File__File_Transfer_File_Signature_Status__file_transfer_file_signature_status_KEY | file_transfer_file_signature_status_KEY | File_Transfer_File_Signature_Status |
FK_File_Transfer_File__File_Transfer_File_Status__file_transfer_file_status_KEY | file_transfer_file_status_KEY | File_Transfer_File_Status |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_File_Transfer_Event__File_Transfer_File__file_transfer_file_KEY | file_transfer_file_KEY | File_Transfer_Event |