Events that occured during the life cycle of a File Transfer. These can originate from Practice CS or from the Portal web user interface |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
file_transfer_event_KEY | int | NOT NULL | Assigned 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_KEY | int | NOT NULL | File Transfer that this file is a part of |
file_transfer_file_KEY | int | | File associated with this event, if any |
file_transfer_event_type_KEY | int | NOT NULL | Type of event |
event_date_utc | datetime | NOT NULL | The time at which this event occurred |
portal_user_KEY | int | NOT NULL | Portal_User who triggered this event |
label | nvarchar (260) | | Label for this event, as provided by Portal server |
ip_address | varchar (39) | NOT NULL | IP Address of machine that triggered this event |
file_size | int | | File size of the file associated with this event, if any |
portal_event_id | int | NOT NULL | Unique and immutable identifier of this event provided by the Portal server |
PK_File_Transfer_Event$file_transfer_event_KEY | file_transfer_event_KEY | CLUSTERED |
UK_File_Transfer_Event$portal_event_id | portal_event_id | Each event from the Portal server should be stored in this table exactly once. |
IX_File_Transfer_Event$file_transfer_event_type_KEY | file_transfer_event_type_KEY | Index supports foreign key FK_File_Transfer_Event__File_Transfer_Event_Type__file_transfer_event_type_KEY |
IX_File_Transfer_Event$file_transfer_file_KEY | file_transfer_file_KEY | Index supports foreign key FK_File_Transfer_Event__File_Transfer_File__file_transfer_file_KEY |
IX_File_Transfer_Event$file_transfer_KEY | file_transfer_KEY | Index supports foreign key FK_File_Transfer_Event__File_Transfer__file_transfer_KEY |
IX_File_Transfer_Event$portal_user_KEY | portal_user_KEY | Index supports foreign key FK_File_Transfer_Event__Portal_User__portal_user_KEY |