[cohesion].[cc_user

Property	Value
Row Count	11
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_user_group__6A30C649: cendura_id\group_id$	cendura_id	int	4
$Cluster Primary Key PK__cc_user_group__6A30C649: cendura_id\group_id$	group_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__cc_user_group__6A30C649: cendura_id\group_id$

cendura_id

int

$Cluster Primary Key PK__cc_user_group__6A30C649: cendura_id\group_id$

group_id

int

	Name	Columns	Unique
$Cluster Primary Key PK__cc_user_group__6A30C649: cendura_id\group_id$	PK__cc_user_group__6A30C649	cendura_id, group_id
	XIE1cc_user_group	group_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_user_group__6A30C649: cendura_id\group_id$

PK__cc_user_group__6A30C649

cendura_id, group_id

XIE1cc_user_group

group_id

Name	Columns
FK__cc_user_g__cendu__6C190EBB	cendura_id->[cohesion].[cc_user].[cendura_id]
FK__cc_user_g__group__6B24EA82	group_id->[cohesion].[cc_group].[group_id]

Name

Columns

FK__cc_user_g__cendu__6C190EBB

cendura_id->[cohesion].[cc_user].[cendura_id]

FK__cc_user_g__group__6B24EA82

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

SQL Script

CREATE TABLE [cohesion].[cc_user_group]
(
[cendura_id] [int] NOT NULL,
[group_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_user_group] ADD CONSTRAINT [PK__cc_user_group__6A30C649] PRIMARY KEY CLUSTERED ([cendura_id], [group_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_user_group] ON [cohesion].[cc_user_group] ([group_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_user_group] ADD CONSTRAINT [FK__cc_user_g__cendu__6C190EBB] FOREIGN KEY ([cendura_id]) REFERENCES [cohesion].[cc_user] ([cendura_id])
GO
ALTER TABLE [cohesion].[cc_user_group] ADD CONSTRAINT [FK__cc_user_g__group__6B24EA82] FOREIGN KEY ([group_id]) REFERENCES [cohesion].[cc_group] ([group_id])
GO