[dbo].[DTA_reports_query]
CREATE TABLE [dbo].[DTA_reports_query]
(
[QueryID] [int] NOT NULL,
[SessionID] [int] NOT NULL,
[StatementType] [smallint] NOT NULL,
[StatementString] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CurrentCost] [float] NOT NULL,
[RecommendedCost] [float] NOT NULL,
[Weight] [float] NOT NULL,
[EventString] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EventWeight] [float] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_query] ADD CONSTRAINT [DTA_reports_query_pk] PRIMARY KEY CLUSTERED ([SessionID], [QueryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_query] ADD CONSTRAINT [FK__DTA_repor__Sessi__451F3D2B] FOREIGN KEY ([SessionID]) REFERENCES [dbo].[DTA_input] ([SessionID]) ON DELETE CASCADE
GO
![Foreign Keys FK__DTA_repor__Sessi__451F3D2B: [dbo].[DTA_input].SessionID](../../Images/fk.gif)
