[dbo].[SecurityRoleGroupJoin]

Property	Value
Row Count	3
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_rolegroupjoin: groupID\roleID$	roleID	int	4
$Cluster Primary Key pk_rolegroupjoin: groupID\roleID$	groupID	int	4
	isDefault	int	4	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key pk_rolegroupjoin: groupID\roleID$

roleID

int

$Cluster Primary Key pk_rolegroupjoin: groupID\roleID$

groupID

int

isDefault

int

((0))

	Name	Columns	Unique
$Cluster Primary Key pk_rolegroupjoin: groupID\roleID$	pk_rolegroupjoin	groupID, roleID

Name

Columns

Unique

$Cluster Primary Key pk_rolegroupjoin: groupID\roleID$

pk_rolegroupjoin

groupID, roleID

Name	Columns
fk_rolegroupjoin_group	groupID->[dbo].[SecurityGroups].[groupID]
fk_rolegroupjoin_role	roleID->[dbo].[Roles].[roleID]

Name

Columns

fk_rolegroupjoin_group

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

fk_rolegroupjoin_role

roleID->[dbo].[Roles].[roleID]

SQL Script

CREATE TABLE [dbo].[SecurityRoleGroupJoin]
(
[roleID] [int] NOT NULL,
[groupID] [int] NOT NULL,
[isDefault] [int] NOT NULL CONSTRAINT [DF__SecurityR__isDef__51300E55] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityRoleGroupJoin] ADD CONSTRAINT [pk_rolegroupjoin] PRIMARY KEY CLUSTERED ([groupID], [roleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityRoleGroupJoin] ADD CONSTRAINT [fk_rolegroupjoin_group] FOREIGN KEY ([groupID]) REFERENCES [dbo].[SecurityGroups] ([groupID])
GO
ALTER TABLE [dbo].[SecurityRoleGroupJoin] ADD CONSTRAINT [fk_rolegroupjoin_role] FOREIGN KEY ([roleID]) REFERENCES [dbo].[Roles] ([roleID])
GO