[dbo].[Forum_ThreadRating]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Forum_ThreadRating: UserID\ThreadID$	UserID	int	4
$Cluster Primary Key PK_Forum_ThreadRating: UserID\ThreadID$	ThreadID	int	4
	Rate	decimal(4,2)	5
	Comment	nvarchar(500)	1000

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_Forum_ThreadRating: UserID\ThreadID$

UserID

int

$Cluster Primary Key PK_Forum_ThreadRating: UserID\ThreadID$

ThreadID

int

Rate

decimal(4,2)

Comment

nvarchar(500)

1000

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

Name

Columns

Unique

$Cluster Primary Key PK_Forum_ThreadRating: UserID\ThreadID$

PK_Forum_ThreadRating

UserID, ThreadID

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

Name

No Check

Replication

Delete

Columns

FK_Forum_ThreadRating_Forum_Threads

Cascade

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

SQL Script

CREATE TABLE [dbo].[Forum_ThreadRating]
(
[UserID] [int] NOT NULL,
[ThreadID] [int] NOT NULL,
[Rate] [decimal] (4, 2) NOT NULL,
[Comment] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

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