Table Icon dbo.ThreadTrackings

Table Properties

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

Columns

  Name Description Data Type Length NULL Default RowGUIDCOL Computed
Primary Key ThreadID int 4      
Primary Key UserName nvarchar 50      
  DateCreated datetime 8      

Total: 3 column(s)

Indentity Column

No identity column exists

Check Constraints

No check constraints exists

Indexes

Index Primary Unique Clustered
PK_ThreadTrackings Primary Key Unique Index Clustered Index

Permissions

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

SQL

CREATE TABLE [ThreadTrackings] (
	[ThreadID] [int] NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_ThreadTrackings_DateCreated] DEFAULT (getdate()),
	CONSTRAINT [PK_ThreadTrackings] PRIMARY KEY  CLUSTERED 
	(
		[ThreadID],
		[UserName]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_ThreadTrackings_Users] FOREIGN KEY 
	(
		[UserName]
	) REFERENCES [Users] (
		[UserName]
	)
) ON [PRIMARY]
GO



					

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