Tables [dbo].[RPReportParamDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:49 AM Thursday, March 21, 2019
Last Modified1:14:04 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_RPReportParamDetails: ReportParamDetailIDReportParamDetailIDint4
False
1 - 1
ParamDetailNamevarchar(64)64
False
Foreign Keys FK_RPReportParamDetails_ReportParamID_RPReportParams: [dbo].[RPReportParams].ReportParamIDReportParamIDint4
False
DetailIDint4
False
UseMebit1
False
((0))
UseMeNamevarchar(64)64
True
DisplayNamevarchar(128)128
True
Foreign Keys FK_RPReportParamDetails_AssociatedParamID_RPReportParams: [dbo].[RPReportParams].AssociatedParamIDAssociatedParamIDint4
True
Valuevarchar(128)128
True
AssignedValuevarchar(128)128
True
Foreign Keys FK_RPReportParamDetails_CrystalParamTypeID_RPCrystalParamTypes: [dbo].[RPCrystalParamTypes].CrystalParamTypeIDCrystalParamTypeIDint4
True
CodeDependentbit1
False
((1))
CommonlyUsedbit1
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_RPReportParamDetails: ReportParamDetailIDPK_RPReportParamDetailsReportParamDetailID
True
80
NameColumns
FK_RPReportParamDetails_AssociatedParamID_RPReportParamsAssociatedParamID->[dbo].[RPReportParams].[ReportParamID]
FK_RPReportParamDetails_CrystalParamTypeID_RPCrystalParamTypesCrystalParamTypeID->[dbo].[RPCrystalParamTypes].[ParamTypeID]
FK_RPReportParamDetails_ReportParamID_RPReportParamsReportParamID->[dbo].[RPReportParams].[ReportParamID]
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