1. Home
  2. Data
  3. Record Storage Services
  4. Deleted Tables
  5. Table – DeletedInstanceHistory
Searching...

Table – DeletedInstanceHistory

Contents

Purpose

Retains the InstanceHistory for deleted Instance records.

Definition

CREATE TABLE [dbo].[DeletedInstanceHistory](
	[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,
	[CorrelationGUID] [UNIQUEIDENTIFIER] NULL,
 CONSTRAINT [PK_DeletedInstanceHistory_1] PRIMARY KEY CLUSTERED 
(
	[InstanceGUID] ASC,
	[DataVersion] 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?

Yes No

About The Author

Tony Nicholls

Building application systems with 100% of the desired requirements with only a fraction of the cost, time, and risk. This is the problem Tony has been working to solve for more than 35 years. Starting his career in the UK military sector, he has been developing highly secure, scalable, and robust applications since 1985. He has been relentless in finding innovative ways to build new applications. This has come to a pinnacle with trellispark, which eliminates 90% of the costs and effort of application development without compromising on quality, scalability, or security. Tony leads our innovation center of excellence and development teams. His Data Agnostic Services vision has sparked a movement that shakes the traditional assumptions of software development.

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