Table: File_Transfer
Contains records of File Transfers that have been created on the Portal server
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
file_transfer_KEYintNOT NULLunique 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_KEYintNOT NULLThe type of File Transfer
file_transfer_status_KEYintNOT NULLcurrent status of this File Transfer
staff__portal_user_KEYintNOT NULLStaff Portal_User associated with this File Transfer
staff__contact_KEYintNOT NULLStaff Contact associated with this File Transfer
contact__portal_user_KEYintNOT NULLportal that this transfer is to
contact__contact_KEYintNOT NULLcontact that this transfer is to
of__contact_KEYintcontact that contact__contact_KEY is of
subjectnvarchar (255)NOT NULLsubject line of this File Transfer
bodynvarchar (-1)NOT NULLbody of the File Transfer message
file_countintNOT NULLnumber of files associated to this File Transfer
total_file_sizeintNOT NULLsum of file sizes of files associated to this File Transfer
expiration_date_utcdatetimeNOT NULLdate that this File Transfer will no longer be available on the Portal server
file_transfer_create_date_utcdatetimeNOT NULLdate that this File Transfer was created
complete_date_utcdatetimeThe File_Transfer_Event.event_date_utc of the event that completed this File Transfer
Primary key
NameColumnsDescription
PK_File_Transfer$file_transfer_KEYfile_transfer_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_File_Transfer$contact__contact_KEYcontact__contact_KEYIndex supports foreign key FK_File_Transfer__Contact__contact__contact_KEY
IX_File_Transfer$contact__portal_user_KEYcontact__portal_user_KEYIndex supports foreign key FK_File_Transfer__Portal_User__contact__portal_user_KEY
IX_File_Transfer$file_transfer_status_KEYfile_transfer_status_KEYIndex supports foreign key FK_File_Transfer__File_Transfer_Status__file_transfer_status_KEY
IX_File_Transfer$file_transfer_type_KEYfile_transfer_type_KEYIndex supports foreign key FK_File_Transfer__File_Transfer_Type__file_transfer_type_KEY
IX_File_Transfer$of__contact_KEYof__contact_KEYIndex supports foreign key FK_File_Transfer__Contact__of__contact_KEY
IX_File_Transfer$staff__contact_KEYstaff__contact_KEYIndex supports foreign key FK_File_Transfer__Contact__staff__contact_KEY
IX_File_Transfer$staff__portal_user_KEYstaff__portal_user_KEYIndex supports foreign key FK_File_Transfer__Portal_User__staff__portal_user_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_File_Transfer__Contact__contact__contact_KEYcontact__contact_KEYContact
FK_File_Transfer__Contact__of__contact_KEYof__contact_KEYContact
FK_File_Transfer__Contact__staff__contact_KEYstaff__contact_KEYContact
FK_File_Transfer__Portal_User__contact__portal_user_KEYcontact__portal_user_KEYPortal_User
FK_File_Transfer__Portal_User__staff__portal_user_KEYstaff__portal_user_KEYPortal_User
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_File_Transfer_File__File_Transfer__file_transfer_KEYfile_transfer_KEYFile_Transfer_File
FK_File_Transfer_Event__File_Transfer__file_transfer_KEYfile_transfer_KEYFile_Transfer_Event

Schema diagram