Purpose
Retains Instances for deleted Instance records.
NOTE – this table adds DeletedOn and DeletedByGUID fields to record the InstanceGUID of the user who deleted the records and the timestamp of the deletion. It also adds the RequestGUID field to group all of the Instance records that were included in the deletion request.
Definition
CREATE TABLE [dbo].[DeletedInstances](
[RequestGUID] [UNIQUEIDENTIFIER] NOT NULL,
[InstanceGUID] [UNIQUEIDENTIFIER] NOT NULL,
[DataVersion] [INT] NOT NULL,
[InstanceName] [VARCHAR](300) NOT NULL,
[ConceptGUID] [UNIQUEIDENTIFIER] NOT NULL,
[Hierarchy] [VARCHAR](500) NOT NULL,
[ParentGUID] [UNIQUEIDENTIFIER] NOT NULL,
[InsertedByGUID] [UNIQUEIDENTIFIER] NOT NULL,
[InsertedOn] [DATETIME2](7) NOT NULL,
[InstanceStatus] [VARCHAR](50) NOT NULL,
[InstanceData] [XML] NOT NULL,
[DeletedByGUID] [UNIQUEIDENTIFIER] NULL,
[DeletedOn] [DATETIME2](7) NULL,
[CreatedByGUID] [UNIQUEIDENTIFIER] NULL,
[CreatedOn] [DATETIME2](7) NULL,
[LastUpdated] [DATETIME2](7) NULL,
[LastUpdatedByGUID] [UNIQUEIDENTIFIER] NULL,
[OldPrimaryKey] [VARCHAR](500) NULL,
[CorrelationGUID] [UNIQUEIDENTIFIER] NULL,
CONSTRAINT [PK_DeletedInstances] PRIMARY KEY CLUSTERED
(
[RequestGUID] ASC,
[InstanceGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]