Table Properties

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

Columns

	Name	Description	Data Type	Length	NULL	Default	RowGUIDCOL	Computed
	ForumID		int	4
	ForumGroupId		int	4
	ParentID		int	4
	Name		nvarchar	100
	Description		nvarchar	3000
	DateCreated		datetime	8
	Moderated		bit	1
	DaysToView		int	4
	Active		bit	1
	SortOrder		int	4
	TotalPosts		int	4
	TotalThreads		int	4
	MostRecentPostID		int	4
	MostRecentThreadID		int	4
	MostRecentPostDate		datetime	8
	MostRecentPostAuthor		nvarchar	50
	DisplayMask		binary	64

Total: 17 column(s)

Indentity Column

Name	Seed	Increment	Not for Replication
ForumID	1	1

Check Constraints

No check constraints exists

Indexes

Index	Primary	Unique	Clustered
PK_Forums
IX_Forums_Active
_WA_Sys_ForumGroupId_78B3EFCA

Permissions

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

SQL

CREATE TABLE [Forums] (
	[ForumID] [int] IDENTITY (1, 1) NOT NULL ,
	[ForumGroupId] [int] NOT NULL ,
	[ParentID] [int] NOT NULL CONSTRAINT [DF__Forums__ParentID__01342732] DEFAULT (0),
	[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Description] [nvarchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_Forums_DateCreated] DEFAULT (getdate()),
	[Moderated] [bit] NOT NULL CONSTRAINT [DF_Forums_Moderated] DEFAULT (0),
	[DaysToView] [int] NOT NULL CONSTRAINT [DF_Forums_DaysToView] DEFAULT (30),
	[Active] [bit] NOT NULL CONSTRAINT [DF_Forums_Active] DEFAULT (1),
	[SortOrder] [int] NOT NULL CONSTRAINT [DF_Forums_SortOrder] DEFAULT (0),
	[TotalPosts] [int] NOT NULL CONSTRAINT [DF_Forums_TotalPosts] DEFAULT (0),
	[TotalThreads] [int] NOT NULL CONSTRAINT [DF_Forums_TotalThreads] DEFAULT (0),
	[MostRecentPostID] [int] NOT NULL CONSTRAINT [DF_Forums_MostRecentPostID] DEFAULT (0),
	[MostRecentThreadID] [int] NOT NULL CONSTRAINT [DF_Forums_MostRecentThreadID] DEFAULT (0),
	[MostRecentPostDate] [datetime] NULL ,
	[MostRecentPostAuthor] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Forums_MostRecentPostAuthor] DEFAULT (''),
	[DisplayMask] [binary] (64) NOT NULL CONSTRAINT [DF__forums__DisplayM__004002F9] DEFAULT (0),
	CONSTRAINT [PK_Forums] PRIMARY KEY  CLUSTERED 
	(
		[ForumID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO