Tables [dbo].[RPFormatCodeDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:43 AM Thursday, March 21, 2019
Last Modified1:13:58 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__RPFormat__4BD3CF82AF291DF0: FormatCodeDetailIDFormatCodeDetailIDint4
False
1 - 1
Foreign Keys FK_RPFormatCodeDetails_FormatCodeID_RPFormatCodes: [dbo].[RPFormatCodes].FormatCodeIDFormatCodeIDint4
False
Namevarchar(64)64
True
GroupByDigitsint4
True
GroupLevelint4
True
GroupByValueFromvarchar(64)64
True
GroupByValueTovarchar(64)64
True
GroupOrderbyint4
True
ShowHeaderbit1
True
ShowFooterbit1
True
SubtotalFlagint4
True
CreatorIDvarchar(8)8
True
CreateDatedatetime8
False
(getdate())
UpdatorIDvarchar(8)8
True
LastUpdatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__RPFormat__4BD3CF82AF291DF0: FormatCodeDetailIDPK__RPFormat__4BD3CF82AF291DF0FormatCodeDetailID
True
80
NameColumns
FK_RPFormatCodeDetails_FormatCodeID_RPFormatCodesFormatCodeID->[dbo].[RPFormatCodes].[FormatCodeID]
CREATE TABLE [dbo].[RPFormatCodeDetails]
(
[FormatCodeDetailID] [int] NOT NULL IDENTITY(1, 1),
[FormatCodeID] [int] NOT NULL,
[Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupByDigits] [int] NULL,
[GroupLevel] [int] NULL,
[GroupByValueFrom] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupByValueTo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupOrderby] [int] NULL,
[ShowHeader] [bit] NULL,
[ShowFooter] [bit] NULL,
[SubtotalFlag] [int] NULL,
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_RPFormatCodeDetails_CreateDate] DEFAULT (getdate()),
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_RPFormatCodeDetails_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPFormatCodeDetails] ADD CONSTRAINT [PK__RPFormat__4BD3CF82AF291DF0] PRIMARY KEY CLUSTERED  ([FormatCodeDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPFormatCodeDetails] ADD CONSTRAINT [FK_RPFormatCodeDetails_FormatCodeID_RPFormatCodes] FOREIGN KEY ([FormatCodeID]) REFERENCES [dbo].[RPFormatCodes] ([FormatCodeID])
GO