Table: File_Transfer
Contains records of File Transfers that have been created on the Portal server
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
file_transfer_KEY | int | NOT NULL | unique and immutable primary key of this file transfer provided by the Portal server which is also used as this table's primary key
file_transfer_type_KEY | int | NOT NULL | The type of File Transfer
file_transfer_status_KEY | int | NOT NULL | current status of this File Transfer
staff__portal_user_KEY | int | NOT NULL | Staff Portal_User associated with this File Transfer
staff__contact_KEY | int | NOT NULL | Staff Contact associated with this File Transfer
contact__portal_user_KEY | int | NOT NULL | portal that this transfer is to
contact__contact_KEY | int | NOT NULL | contact that this transfer is to
of__contact_KEY | int |  | contact that contact__contact_KEY is of
subject | nvarchar (255) | NOT NULL | subject line of this File Transfer
body | nvarchar (-1) | NOT NULL | body of the File Transfer message
file_count | int | NOT NULL | number of files associated to this File Transfer
total_file_size | int | NOT NULL | sum of file sizes of files associated to this File Transfer
expiration_date_utc | datetime | NOT NULL | date that this File Transfer will no longer be available on the Portal server
file_transfer_create_date_utc | datetime | NOT NULL | date that this File Transfer was created
complete_date_utc | datetime |  | The File_Transfer_Event.event_date_utc of the event that completed this File Transfer

Primary key
Name | Columns | Description
PK_File_Transfer$file_transfer_KEY | file_transfer_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_File_Transfer$contact__contact_KEY | contact__contact_KEY | Index supports foreign key FK_File_Transfer__Contact__contact__contact_KEY
IX_File_Transfer$contact__portal_user_KEY | contact__portal_user_KEY | Index supports foreign key FK_File_Transfer__Portal_User__contact__portal_user_KEY
IX_File_Transfer$file_transfer_status_KEY | file_transfer_status_KEY | Index supports foreign key FK_File_Transfer__File_Transfer_Status__file_transfer_status_KEY
IX_File_Transfer$file_transfer_type_KEY | file_transfer_type_KEY | Index supports foreign key FK_File_Transfer__File_Transfer_Type__file_transfer_type_KEY
IX_File_Transfer$of__contact_KEY | of__contact_KEY | Index supports foreign key FK_File_Transfer__Contact__of__contact_KEY
IX_File_Transfer$staff__contact_KEY | staff__contact_KEY | Index supports foreign key FK_File_Transfer__Contact__staff__contact_KEY
IX_File_Transfer$staff__portal_user_KEY | staff__portal_user_KEY | Index supports foreign key FK_File_Transfer__Portal_User__staff__portal_user_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_File_Transfer__Contact__contact__contact_KEY | contact__contact_KEY | Contact |
FK_File_Transfer__Contact__of__contact_KEY | of__contact_KEY | Contact |
FK_File_Transfer__Contact__staff__contact_KEY | staff__contact_KEY | Contact |
FK_File_Transfer__Portal_User__contact__portal_user_KEY | contact__portal_user_KEY | Portal_User |
FK_File_Transfer__Portal_User__staff__portal_user_KEY | staff__portal_user_KEY | Portal_User |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_File_Transfer_File__File_Transfer__file_transfer_KEY | file_transfer_KEY | File_Transfer_File |
FK_File_Transfer_Event__File_Transfer__file_transfer_KEY | file_transfer_KEY | File_Transfer_Event |