Purpose
Reatins the InstanceMilestones for deleted Instance records.
Definition
CREATE TABLE [dbo].[DeletedInstanceMilestones](
[InstanceGUID] [UNIQUEIDENTIFIER] NOT NULL,
[AchievedOn] [DATETIME2](7) NOT NULL,
[AchievedBy] [VARCHAR](100) NOT NULL,
[Milestone] [VARCHAR](2000) NOT NULL,
CONSTRAINT [PK_DeletedInstanceMilestones] PRIMARY KEY CLUSTERED
(
[InstanceGUID] ASC,
[AchievedOn] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]