Tables [dbo].[GLAcctProtections]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:22 AM Thursday, March 21, 2019
Last Modified1:10:50 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_GLAcctProtections: AcctProtectionIDAcctProtectionIDint4
False
1 - 1
AcctProtectionvarchar(32)32
False
Descriptionvarchar(128)128
False
Foreign Keys FK_GLAcctProtections_AcctProtectionTypeID_GLAcctProtectionTypes: [dbo].[GLAcctProtectionTypes].AcctProtectionTypeIDAcctProtectionTypeIDint4
True
NonProtectedAcctsExpectedbit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_GLAcctProtections: AcctProtectionIDPK_GLAcctProtectionsAcctProtectionID
True
80
NameColumns
FK_GLAcctProtections_AcctProtectionTypeID_GLAcctProtectionTypesAcctProtectionTypeID->[dbo].[GLAcctProtectionTypes].[AcctProtectionTypeID]
CREATE TABLE [dbo].[GLAcctProtections]
(
[AcctProtectionID] [int] NOT NULL IDENTITY(1, 1),
[AcctProtection] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AcctProtectionTypeID] [int] NULL,
[NonProtectedAcctsExpected] [bit] NOT NULL CONSTRAINT [DF_GLAcctProtections_NonProtectedAcctsExpected] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAcctProtections] ADD CONSTRAINT [PK_GLAcctProtections] PRIMARY KEY CLUSTERED  ([AcctProtectionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAcctProtections] ADD CONSTRAINT [FK_GLAcctProtections_AcctProtectionTypeID_GLAcctProtectionTypes] FOREIGN KEY ([AcctProtectionTypeID]) REFERENCES [dbo].[GLAcctProtectionTypes] ([AcctProtectionTypeID])
GO