[dbo].[Forum_UserForums]

(local) > DotNetNuke_Community > Tables > dbo.Forum_UserForums

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_UserForums: UserID\ForumID$	UserID	int	4
$Cluster Primary Key PK_Forum_UserForums: UserID\ForumID$	ForumID	int	4
	LastVisitDate	datetime	8

Indexes

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

Foreign Keys

Name	Update	Delete	Columns
FK_Forum_UserForums_Forum_Forums	Cascade	Cascade	ForumID->[dbo].[Forum_Forums].[ForumID]

SQL Script

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

GO
ALTER TABLE [dbo].[Forum_UserForums] ADD CONSTRAINT [PK_Forum_UserForums] PRIMARY KEY CLUSTERED ([UserID], [ForumID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_UserForums] ADD CONSTRAINT [FK_Forum_UserForums_Forum_Forums] FOREIGN KEY ([ForumID]) REFERENCES [dbo].[Forum_Forums] ([ForumID]) ON DELETE CASCADE ON UPDATE CASCADE
GO

Uses

[dbo].[Forum_Forums]
dbo

Used By