Purpose
Determines which portal the user has access to when they enter the workspace.
Definition
CREATE TABLE [dbo].[UserPortals](
[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
[PortalFormGUID] [UNIQUEIDENTIFIER] NOT NULL,
[InstanceGUID] [UNIQUEIDENTIFIER] NOT NULL,
CONSTRAINT [PK_UserPortals_1] PRIMARY KEY CLUSTERED
(
[UserGUID] ASC,
[PortalFormGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Column Definitions
UserGUID is the InstanceGUID of the user’s Instance record
PortalFormGUID is the InstanceGUID of a Portal Form Definition that the user will use as their home page when they enter the workspace.
InstanceGUID is the InstanceGUID of a record that defines the highest point in the hierarchy that the user can see through their portal.
Key Functionality
Has an optional trigger to transfer changes to other data storage through InstanceChanges.