[cohesion].[cc_group

Property	Value
Row Count	1
Created	11:18:10 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Property

Value

Row Count

Created

11:18:10 AM Friday, April 20, 2007

Last Modified

11:18:10 AM Friday, April 20, 2007

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK__cc_group_role__6E01572D: group_id\role_id$	group_id	int	4
$Cluster Primary Key PK__cc_group_role__6E01572D: group_id\role_id$	role_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__cc_group_role__6E01572D: group_id\role_id$

group_id

int

$Cluster Primary Key PK__cc_group_role__6E01572D: group_id\role_id$

role_id

int

	Name	Columns	Unique
$Cluster Primary Key PK__cc_group_role__6E01572D: group_id\role_id$	PK__cc_group_role__6E01572D	group_id, role_id
	XIE1cc_group_role	role_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_group_role__6E01572D: group_id\role_id$

PK__cc_group_role__6E01572D

group_id, role_id

XIE1cc_group_role

role_id

Name	Columns
FK__cc_group___group__6FE99F9F	group_id->[cohesion].[cc_group].[group_id]
FK__cc_group___role___6EF57B66	role_id->[cohesion].[cc_role].[role_id]

Name

Columns

FK__cc_group___group__6FE99F9F

group_id->[cohesion].[cc_group].[group_id]

FK__cc_group___role___6EF57B66

role_id->[cohesion].[cc_role].[role_id]

SQL Script

CREATE TABLE [cohesion].[cc_group_role]
(
[group_id] [int] NOT NULL,
[role_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_group_role] ADD CONSTRAINT [PK__cc_group_role__6E01572D] PRIMARY KEY CLUSTERED ([group_id], [role_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_group_role] ON [cohesion].[cc_group_role] ([role_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_group_role] ADD CONSTRAINT [FK__cc_group___group__6FE99F9F] FOREIGN KEY ([group_id]) REFERENCES [cohesion].[cc_group] ([group_id])
GO
ALTER TABLE [cohesion].[cc_group_role] ADD CONSTRAINT [FK__cc_group___role___6EF57B66] FOREIGN KEY ([role_id]) REFERENCES [cohesion].[cc_role] ([role_id])
GO