Purpose
Tracks when users enter a workspace and is only used for auditing purposes.
Definition
CREATE TABLE [dbo].[WorkspaceEntry](
[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
[EnteredOn] [DATETIMEOFFSET](7) NOT NULL
) ON [PRIMARY]
Column Definitions
The UserGUID records the InstanceGUID of the user. NOTE – users can only enter workspaces that they belong to so the WorkspaceGUID is not required – it is the ParentGUID of the user’s Instance record.
EnteredOn records the timestamp that the user entered the workspace.