[dbo].[Forum_UserThreads]

(local) > DotNetNuke_Community > Tables > dbo.Forum_UserThreads

Properties
Columns
Indexes
Foreign Keys
SQL Script
Uses
Used By

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

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Forum_UserThreads: UserID\ThreadID$	UserID	int	4
$Cluster Primary Key PK_Forum_UserThreads: UserID\ThreadID$	ThreadID	int	4
	LastVisitDate	datetime	8

Indexes

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

Foreign Keys

Name	Update	Delete	Columns
FK_Forum_UserThreads_Forum_Threads	Cascade	Cascade	ThreadID->[dbo].[Forum_Threads].[ThreadID]

SQL Script

CREATE TABLE [dbo].[Forum_UserThreads]
(
[UserID] [int] NOT NULL,
[ThreadID] [int] NOT NULL,
[LastVisitDate] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_UserThreads] ADD CONSTRAINT [PK_Forum_UserThreads] PRIMARY KEY CLUSTERED ([UserID], [ThreadID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_UserThreads] ADD CONSTRAINT [FK_Forum_UserThreads_Forum_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[Forum_Threads] ([ThreadID]) ON DELETE CASCADE ON UPDATE CASCADE
GO

Uses

[dbo].[Forum_Threads]
dbo

Used By