Table Icon dbo.Posts

Table Properties

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

Columns

  Name Description Data Type Length NULL Default RowGUIDCOL Computed
Primary KeyIdentity PostID int 4      
  ThreadID int 4      
  ParentID int 4      
  PostLevel int 4      
  SortOrder int 4      
  Subject nvarchar 256      
  PostDate datetime 8      
  Approved bit 1      
  ForumID int 4      
  UserName nvarchar 50      
  ThreadDate datetime 8      
  TotalViews int 4      
  IsLocked bit 1      
  IsPinned bit 1      
  PinnedDate datetime 8      
  Body ntext 16      
  PostType int 4      

Total: 17 column(s)

Indentity Column

Name Seed Increment Not for Replication
PostID 1 1  

Check Constraints

No check constraints exists

Indexes

Index Primary Unique Clustered
PK_Posts Primary Key Unique Index Clustered Index
IX_Posts_ParentID      
IX_Posts_ThreadID      
IX_Posts_SortOrder      
IX_Posts_PostLevel      
IX_Posts_Approved      
IX_Posts_ForumID      
IX_Posts_Username      
_WA_Sys_ThreadDate_7F60ED59      
_WA_Sys_PostDate_7F60ED59      

Permissions

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

SQL

CREATE TABLE [Posts] (
	[PostID] [int] IDENTITY (1, 1) NOT NULL ,
	[ThreadID] [int] NOT NULL CONSTRAINT [DF_Posts_ThreadID] DEFAULT (0),
	[ParentID] [int] NOT NULL CONSTRAINT [DF_Posts_ParentID] DEFAULT (0),
	[PostLevel] [int] NOT NULL CONSTRAINT [DF_Posts_PostLevel] DEFAULT (0),
	[SortOrder] [int] NOT NULL CONSTRAINT [DF_Posts_SortOrder] DEFAULT (0),
	[Subject] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PostDate] [datetime] NOT NULL CONSTRAINT [DF_Posts_PostDate] DEFAULT (getdate()),
	[Approved] [bit] NOT NULL CONSTRAINT [DF_Posts_Approved] DEFAULT (0),
	[ForumID] [int] NOT NULL CONSTRAINT [DF_Posts_ForumID] DEFAULT (0),
	[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ThreadDate] [datetime] NOT NULL CONSTRAINT [DF_Posts_ThreadDate] DEFAULT (getdate()),
	[TotalViews] [int] NOT NULL CONSTRAINT [DF_Posts_TotalViews] DEFAULT (0),
	[IsLocked] [bit] NOT NULL CONSTRAINT [DF_Posts_IsLocked] DEFAULT (0),
	[IsPinned] [bit] NOT NULL CONSTRAINT [DF_Posts_IsPinned] DEFAULT (0),
	[PinnedDate] [datetime] NOT NULL ,
	[Body] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PostType] [int] NOT NULL CONSTRAINT [DF_Posts_PostType] DEFAULT (0),
	CONSTRAINT [PK_Posts] PRIMARY KEY  CLUSTERED 
	(
		[PostID]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_Posts_Forums] FOREIGN KEY 
	(
		[ForumID]
	) REFERENCES [Forums] (
		[ForumID]
	),
	CONSTRAINT [FK_Posts_Users] FOREIGN KEY 
	(
		[UserName]
	) REFERENCES [Users] (
		[UserName]
	)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



					

Generated on 26/08/2004 15:05:23 by DataAide.