Tables [dbo].[GLAcctProtectionAccountTypes]
PropertyValue
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 Nulls
Cluster Primary Key PK_GLAcctProtectionAccountTypes: AcctProtectionID\AccountTypeIDForeign Keys FK_GLAcctProtectionAccountTypes_AcctProtectionID_GLAcctProtections: [dbo].[GLAcctProtections].AcctProtectionIDAcctProtectionIDint4
False
Cluster Primary Key PK_GLAcctProtectionAccountTypes: AcctProtectionID\AccountTypeIDForeign Keys FK_GLAcctProtectionAccountTypes_AccountTypeID_GLAccountTypes: [dbo].[GLAccountTypes].AccountTypeIDAccountTypeIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_GLAcctProtectionAccountTypes: AcctProtectionID\AccountTypeIDPK_GLAcctProtectionAccountTypesAcctProtectionID, AccountTypeID
True
80
NameColumns
FK_GLAcctProtectionAccountTypes_AccountTypeID_GLAccountTypesAccountTypeID->[dbo].[GLAccountTypes].[AccountTypeID]
FK_GLAcctProtectionAccountTypes_AcctProtectionID_GLAcctProtectionsAcctProtectionID->[dbo].[GLAcctProtections].[AcctProtectionID]
CREATE TABLE [dbo].[GLAcctProtectionAccountTypes]
(
[AcctProtectionID] [int] NOT NULL,
[AccountTypeID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAcctProtectionAccountTypes] ADD CONSTRAINT [PK_GLAcctProtectionAccountTypes] PRIMARY KEY CLUSTERED  ([AcctProtectionID], [AccountTypeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAcctProtectionAccountTypes] ADD CONSTRAINT [FK_GLAcctProtectionAccountTypes_AccountTypeID_GLAccountTypes] FOREIGN KEY ([AccountTypeID]) REFERENCES [dbo].[GLAccountTypes] ([AccountTypeID])
GO
ALTER TABLE [dbo].[GLAcctProtectionAccountTypes] ADD CONSTRAINT [FK_GLAcctProtectionAccountTypes_AcctProtectionID_GLAcctProtections] FOREIGN KEY ([AcctProtectionID]) REFERENCES [dbo].[GLAcctProtections] ([AcctProtectionID])
GO