[dbo].[Forum_TrackedThreads]

Property	Value
Row Count	0
Created	2:07:30 PM Saturday, November 06, 2010
Last Modified	2:07:31 PM Saturday, November 06, 2010

Property

Value

Row Count

Created

2:07:30 PM Saturday, November 06, 2010

Last Modified

2:07:31 PM Saturday, November 06, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$	ForumID	int	4
$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$	ThreadID	int	4
$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$	UserID	int	4
	CreatedDate	datetime	8
	ModuleID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$

ForumID

int

$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$

ThreadID

int

$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$

UserID

int

CreatedDate

datetime

ModuleID

int

	Name	Columns	Unique
$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$	PK_Forum_TrackedThreads	ThreadID, UserID, ForumID

Name

Columns

Unique

$Cluster Primary Key PK_Forum_TrackedThreads: ThreadID\UserID\ForumID$

PK_Forum_TrackedThreads

ThreadID, UserID, ForumID

Name	No Check	Replication	Delete	Columns
FK_Forum_TrackedThreads_Forum_Threads			Cascade	ThreadID->[dbo].[Forum_Threads].[ThreadID]

Name

No Check

Replication

Delete

Columns

FK_Forum_TrackedThreads_Forum_Threads

Cascade

ThreadID->[dbo].[Forum_Threads].[ThreadID]

SQL Script

CREATE TABLE [dbo].[Forum_TrackedThreads]
(
[ForumID] [int] NOT NULL,
[ThreadID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[CreatedDate] [datetime] NULL,
[ModuleID] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_TrackedThreads] ADD CONSTRAINT [PK_Forum_TrackedThreads] PRIMARY KEY CLUSTERED ([ThreadID], [UserID], [ForumID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_TrackedThreads] WITH NOCHECK ADD CONSTRAINT [FK_Forum_TrackedThreads_Forum_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[Forum_Threads] ([ThreadID]) ON DELETE CASCADE NOT FOR REPLICATION
GO