Table: File_Transfer_Event
Events that occured during the life cycle of a File Transfer. These can originate from Practice CS or from the Portal web user interface
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
file_transfer_event_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Unique and immutable primary key of this event provided by the Portal server which is also used as this table's primary key
file_transfer_KEYintNOT NULLFile Transfer that this file is a part of
file_transfer_file_KEYintFile associated with this event, if any
file_transfer_event_type_KEYintNOT NULLType of event
event_date_utcdatetimeNOT NULLThe time at which this event occurred
portal_user_KEYintNOT NULLPortal_User who triggered this event
labelnvarchar (260)Label for this event, as provided by Portal server
ip_addressvarchar (39)NOT NULLIP Address of machine that triggered this event
file_sizeintFile size of the file associated with this event, if any
portal_event_idintNOT NULLUnique and immutable identifier of this event provided by the Portal server
Primary key
NameColumnsDescription
PK_File_Transfer_Event$file_transfer_event_KEYfile_transfer_event_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_File_Transfer_Event$portal_event_idportal_event_idEach event from the Portal server should be stored in this table exactly once.
Indexes
NameColumnsDescription
IX_File_Transfer_Event$file_transfer_event_type_KEYfile_transfer_event_type_KEYIndex supports foreign key FK_File_Transfer_Event__File_Transfer_Event_Type__file_transfer_event_type_KEY
IX_File_Transfer_Event$file_transfer_file_KEYfile_transfer_file_KEYIndex supports foreign key FK_File_Transfer_Event__File_Transfer_File__file_transfer_file_KEY
IX_File_Transfer_Event$file_transfer_KEYfile_transfer_KEYIndex supports foreign key FK_File_Transfer_Event__File_Transfer__file_transfer_KEY
IX_File_Transfer_Event$portal_user_KEYportal_user_KEYIndex supports foreign key FK_File_Transfer_Event__Portal_User__portal_user_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_File_Transfer_Event__File_Transfer__file_transfer_KEYfile_transfer_KEYFile_Transfer
FK_File_Transfer_Event__File_Transfer_File__file_transfer_file_KEYfile_transfer_file_KEYFile_Transfer_File
FK_File_Transfer_Event__Portal_User__portal_user_KEYportal_user_KEYPortal_User
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction__File_Transfer_Event__file_transfer_event_KEYfile_transfer_event_KEYInteraction

Schema diagram