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
Name | Type | Constraints | Description
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

Primary key
Name | Columns | Description
PK_File_Transfer_Event$file_transfer_event_KEY | file_transfer_event_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_File_Transfer_Event$portal_event_id | portal_event_id | Each event from the Portal server should be stored in this table exactly once.
Indexes
Name | Columns | Description
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

Foreign keys
Name | Columns | Referenced table | Description
FK_File_Transfer_Event__File_Transfer__file_transfer_KEY | file_transfer_KEY | File_Transfer |
FK_File_Transfer_Event__File_Transfer_File__file_transfer_file_KEY | file_transfer_file_KEY | File_Transfer_File |
FK_File_Transfer_Event__Portal_User__portal_user_KEY | portal_user_KEY | Portal_User |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction__File_Transfer_Event__file_transfer_event_KEY | file_transfer_event_KEY | Interaction |