EventTarget Table

The EventTarget table stores the links between Activities and other tables in the database.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for EventTarget table

Database Column



Type: integer. Key

Link to the Event table


Type: integer. Key

A link to the TargetType table. this value specifies which kind of object the Event is linked to.


Type: unique identifier. Key. Nullable

used to attach the Event to its target. The target table depends on the TargetTypeID of the linked EventType.


Type: integer. Nullable

ID of the target. Referenced if the UID is not available.


Type: text (max 128 characters). Nullable

TargetName used to record the name of the target. Can be used when the UID or ID is not available.