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. primary key for this table |
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 |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Interaction__File_Transfer_Event__file_transfer_event_KEY | file_transfer_event_KEY | Interaction |