[dbo].[CollabResponseGroupJoin]

Property	Value
Row Count	8
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)	Allow Nulls
$Cluster Primary Key pk_collabrespgroupjoin: responseID\groupID$	responseID	int	4
$Cluster Primary Key pk_collabrespgroupjoin: responseID\groupID$	groupID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_collabrespgroupjoin: responseID\groupID$

responseID

int

$Cluster Primary Key pk_collabrespgroupjoin: responseID\groupID$

groupID

int

	Name	Columns	Unique
$Cluster Primary Key pk_collabrespgroupjoin: responseID\groupID$	pk_collabrespgroupjoin	responseID, groupID

Name

Columns

Unique

$Cluster Primary Key pk_collabrespgroupjoin: responseID\groupID$

pk_collabrespgroupjoin

responseID, groupID

Name	Columns
fk_collabrespgroupjoin_group	groupID->[dbo].[CollabResponseGroups].[groupID]
fk_collabrespgroupjoin_resp	responseID->[dbo].[CollabResponses].[responseID]

Name

Columns

fk_collabrespgroupjoin_group

groupID->[dbo].[CollabResponseGroups].[groupID]

fk_collabrespgroupjoin_resp

responseID->[dbo].[CollabResponses].[responseID]

SQL Script

CREATE TABLE [dbo].[CollabResponseGroupJoin]
(
[responseID] [int] NOT NULL,
[groupID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CollabResponseGroupJoin] ADD CONSTRAINT [pk_collabrespgroupjoin] PRIMARY KEY CLUSTERED ([responseID], [groupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CollabResponseGroupJoin] ADD CONSTRAINT [fk_collabrespgroupjoin_group] FOREIGN KEY ([groupID]) REFERENCES [dbo].[CollabResponseGroups] ([groupID])
GO
ALTER TABLE [dbo].[CollabResponseGroupJoin] ADD CONSTRAINT [fk_collabrespgroupjoin_resp] FOREIGN KEY ([responseID]) REFERENCES [dbo].[CollabResponses] ([responseID])
GO