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 |
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 |