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