[dbo].[SecurityGroupFunctions]

Property	Value
Row Count	72
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Property

Value

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:45 PM Thursday, October 04, 2007

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key pk_secgroupfunctions: groupID\functionID$	groupID	int	4
$Cluster Primary Key pk_secgroupfunctions: groupID\functionID$	functionID	int	4
	value	int	4	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key pk_secgroupfunctions: groupID\functionID$

groupID

int

$Cluster Primary Key pk_secgroupfunctions: groupID\functionID$

functionID

int

value

int

((0))

	Name	Columns	Unique
$Cluster Primary Key pk_secgroupfunctions: groupID\functionID$	pk_secgroupfunctions	groupID, functionID

Name

Columns

Unique

$Cluster Primary Key pk_secgroupfunctions: groupID\functionID$

pk_secgroupfunctions

groupID, functionID

Name	Columns
fk_secgroupfunctions_funcs	functionID->[dbo].[SecurityToolFunctions].[functionID]
fk_secgroupfunctions_secgroups	groupID->[dbo].[SecurityGroups].[groupID]

Name

Columns

fk_secgroupfunctions_funcs

functionID->[dbo].[SecurityToolFunctions].[functionID]

fk_secgroupfunctions_secgroups

groupID->[dbo].[SecurityGroups].[groupID]

SQL Script

CREATE TABLE [dbo].[SecurityGroupFunctions]
(
[groupID] [int] NOT NULL,
[functionID] [int] NOT NULL,
[value] [int] NOT NULL CONSTRAINT [DF__SecurityG__value__43D61337] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityGroupFunctions] ADD CONSTRAINT [pk_secgroupfunctions] PRIMARY KEY CLUSTERED ([groupID], [functionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityGroupFunctions] ADD CONSTRAINT [fk_secgroupfunctions_funcs] FOREIGN KEY ([functionID]) REFERENCES [dbo].[SecurityToolFunctions] ([functionID])
GO
ALTER TABLE [dbo].[SecurityGroupFunctions] ADD CONSTRAINT [fk_secgroupfunctions_secgroups] FOREIGN KEY ([groupID]) REFERENCES [dbo].[SecurityGroups] ([groupID])
GO