CREATE TABLE [dbo].[RPReportParamDetails]
(
[ReportParamDetailID] [int] NOT NULL IDENTITY(1, 1),
[ParamDetailName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReportParamID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[UseMe] [bit] NOT NULL CONSTRAINT [DF_RPReportParamDetails_UseMe] DEFAULT ((0)),
[UseMeName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisplayName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssociatedParamID] [int] NULL,
[Value] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssignedValue] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CrystalParamTypeID] [int] NULL,
[CodeDependent] [bit] NOT NULL CONSTRAINT [DF_RPReportParamDetails_CodeDependent] DEFAULT ((1)),
[CommonlyUsed] [bit] NOT NULL CONSTRAINT [DF_RPReportParamDetails_CommonlyUsed] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportParamDetails] ADD CONSTRAINT [PK_RPReportParamDetails] PRIMARY KEY CLUSTERED ([ReportParamDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportParamDetails] ADD CONSTRAINT [FK_RPReportParamDetails_AssociatedParamID_RPReportParams] FOREIGN KEY ([AssociatedParamID]) REFERENCES [dbo].[RPReportParams] ([ReportParamID])
GO
ALTER TABLE [dbo].[RPReportParamDetails] ADD CONSTRAINT [FK_RPReportParamDetails_CrystalParamTypeID_RPCrystalParamTypes] FOREIGN KEY ([CrystalParamTypeID]) REFERENCES [dbo].[RPCrystalParamTypes] ([ParamTypeID])
GO
ALTER TABLE [dbo].[RPReportParamDetails] ADD CONSTRAINT [FK_RPReportParamDetails_ReportParamID_RPReportParams] FOREIGN KEY ([ReportParamID]) REFERENCES [dbo].[RPReportParams] ([ReportParamID])
GO