Tables [dbo].[Forum_Moderate_History]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:07:32 PM Saturday, November 06, 2010
Last Modified2:07:32 PM Saturday, November 06, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
ModeratorIDint4
Yes
Foreign Keys FK_Forum_Moderate_History_Portals: [dbo].[Portals].PortalIDPortalIDint4
No
Notesnvarchar(1024)2048
Yes
CreatedDatedatetime8
No
PostIDint4
Yes
ModerateActionIDint4
No
Foreign Keys Foreign Keys
NameNo CheckReplicationDeleteColumns
FK_Forum_Moderate_History_Portals
Yes
No
CascadePortalID->[dbo].[Portals].[PortalID]
SQL Script
CREATE TABLE [dbo].[Forum_Moderate_History]
(
[ModeratorID] [int] NULL,
[PortalID] [int] NOT NULL,
[Notes] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedDate] [datetime] NOT NULL,
[PostID] [int] NULL,
[ModerateActionID] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Forum_Moderate_History] WITH NOCHECK ADD CONSTRAINT [FK_Forum_Moderate_History_Portals] FOREIGN KEY ([PortalID]) REFERENCES [dbo].[Portals] ([PortalID]) ON DELETE CASCADE NOT FOR REPLICATION
GO
Uses
Used By