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	Details
`EventID`	Type: integer. Key Link to the `Event` table
`TargetTypeID`	Type: integer. Key A link to the `TargetType` table. this value specifies which kind of object the Event is linked to.
`TargetUID`	Type: unique identifier. Key. Nullable used to attach the `Event` to its target. The target table depends on the TargetTypeID of the linked EventType.
`TargetID`	Type: integer. Nullable ID of the target. Referenced if the UID is not available.
`TargetName`	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.