CREATE TABLE [dbo].[DTA_progress]
(
[ProgressEventID] [int] NOT NULL IDENTITY(1, 1),
[SessionID] [int] NULL,
[TuningStage] [tinyint] NOT NULL CONSTRAINT [DF__DTA_progr__Tunin__2A6B46EF] DEFAULT ((0)),
[WorkloadConsumption] [tinyint] NOT NULL,
[EstImprovement] [int] NOT NULL CONSTRAINT [DF__DTA_progr__EstIm__2C538F61] DEFAULT ((0)),
[ProgressEventTime] [datetime] NOT NULL CONSTRAINT [DF__DTA_progr__Progr__2D47B39A] DEFAULT (getdate()),
[ConsumingWorkLoadMessage] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PerformingAnalysisMessage] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GeneratingReportsMessage] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_progress] ADD CONSTRAINT [CK__DTA_progr__Workl__2B5F6B28] CHECK (([WorkloadConsumption]>=(0) AND [WorkloadConsumption]<=(100)))
GO
CREATE CLUSTERED INDEX [DTA_progress_index] ON [dbo].[DTA_progress] ([SessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_progress] ADD CONSTRAINT [FK__DTA_progr__Sessi__297722B6] FOREIGN KEY ([SessionID]) REFERENCES [dbo].[DTA_input] ([SessionID]) ON DELETE CASCADE
GO
[dbo].[DTA_progress]
![Foreign Keys FK__DTA_progr__Sessi__297722B6: [dbo].[DTA_input].SessionID](../../Images/fk.gif)
![Check Constraints CK__DTA_progr__Workl__2B5F6B28 : ([WorkloadConsumption]>=(0) AND [WorkloadConsumption]<=(100))](../../Images/c-constraint.gif)
