Tables [dbo].[RPReportParams]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:49 AM Thursday, March 21, 2019
Last Modified1:14:05 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_RPReportParams: ReportParamIDReportParamIDint4
False
1 - 1
ParamNamevarchar(64)64
False
DisplayNamevarchar(64)64
False
Descriptionvarchar(128)128
False
Foreign Keys FK_RPReportParams_ReportID_RPReports: [dbo].[RPReports].ReportIDReportIDint4
False
Foreign Keys FK_RPReportParams_TypeID_RPReportParamTypesEx: [dbo].[RPReportParamTypesEx].TypeIDTypeIDint4
False
TypeValuevarchar(1024)1024
True
TypeValue2varchar(128)128
True
TypeValue3varchar(128)128
True
TypeValue4varchar(128)128
True
OrderValueint4
True
DisplayOrderValueint4
True
Hidebit1
False
((0))
LdBaseIDint4
True
Requiredbit1
False
((0))
Foreign Keys FK_RPReportParams_Type2ID_RPReportParamTypes2: [dbo].[RPReportParamTypes2].Type2IDType2IDint4
False
((2))
AddSingleQuotesbit1
False
((0))
NoPreviewbit1
False
((0))
RememberMebit1
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_RPReportParams: ReportParamIDPK_RPReportParamsReportParamID
True
80
NameColumns
FK_RPReportParams_ReportID_RPReportsReportID->[dbo].[RPReports].[ReportID]
FK_RPReportParams_Type2ID_RPReportParamTypes2Type2ID->[dbo].[RPReportParamTypes2].[ParamTypeID]
FK_RPReportParams_TypeID_RPReportParamTypesExTypeID->[dbo].[RPReportParamTypesEx].[ParamTypeID]
CREATE TABLE [dbo].[RPReportParams]
(
[ReportParamID] [int] NOT NULL IDENTITY(1, 1),
[ParamName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DisplayName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReportID] [int] NOT NULL,
[TypeID] [int] NOT NULL,
[TypeValue] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeValue2] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeValue3] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeValue4] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderValue] [int] NULL,
[DisplayOrderValue] [int] NULL,
[Hide] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_Hide] DEFAULT ((0)),
[LdBaseID] [int] NULL,
[Required] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_Required] DEFAULT ((0)),
[Type2ID] [int] NOT NULL CONSTRAINT [DF_RPReportParams_Type2ID] DEFAULT ((2)),
[AddSingleQuotes] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_AddSingleQuotes] DEFAULT ((0)),
[NoPreview] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_NoPreview] DEFAULT ((0)),
[RememberMe] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_RememberMe] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [PK_RPReportParams] PRIMARY KEY CLUSTERED  ([ReportParamID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [FK_RPReportParams_ReportID_RPReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[RPReports] ([ReportID])
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [FK_RPReportParams_Type2ID_RPReportParamTypes2] FOREIGN KEY ([Type2ID]) REFERENCES [dbo].[RPReportParamTypes2] ([ParamTypeID])
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [FK_RPReportParams_TypeID_RPReportParamTypesEx] FOREIGN KEY ([TypeID]) REFERENCES [dbo].[RPReportParamTypesEx] ([ParamTypeID])
GO