Table – DeletedInstances

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]

Updated on November 24, 2022

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment