Table Properties

Name	Value
Owner	dbo
Created	2004-05-31
Located On	PRIMARY
Rows	1
Data Size KB	8
Index Size KB	16

Columns

	Name	Description	Data Type	Length	NULL	Default	RowGUIDCOL	Computed
	UserName		nvarchar	50
	ForumID		int	4
	DateCreated		datetime	8
	EmailNotification		bit	1

Total: 4 column(s)

Indentity Column

No identity column exists

Check Constraints

No check constraints exists

Indexes

Index	Primary	Unique	Clustered
PK_Moderators

Permissions

No direct permissions defined (N.B. Permissions may be inherited from roles

SQL

CREATE TABLE [Moderators] (
	[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ForumID] [int] NOT NULL ,
	[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_Moderators_DateCreated] DEFAULT (getdate()),
	[EmailNotification] [bit] NOT NULL CONSTRAINT [DF_Moderators_EmailNotification] DEFAULT (0),
	CONSTRAINT [PK_Moderators] PRIMARY KEY  CLUSTERED 
	(
		[UserName],
		[ForumID]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_Moderators_Users] FOREIGN KEY 
	(
		[UserName]
	) REFERENCES [Users] (
		[UserName]
	)
) ON [PRIMARY]
GO