[dbo].[Forum_Polls_Polls]
CREATE TABLE [dbo].[Forum_Polls_Polls]
(
[PollID] [int] NOT NULL IDENTITY(1, 1),
[Question] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShowResults] [bit] NOT NULL CONSTRAINT [DF_Forum_Polls_Polls_ShowResults] DEFAULT ((1)),
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF__Forum_Pol__Creat__7484378A] DEFAULT (getdate()),
[EndDate] [datetime] NULL,
[TakenMessage] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ThreadID] [int] NOT NULL CONSTRAINT [DF__Forum_Pol__Threa__75785BC3] DEFAULT ((-1)),
[ModuleID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Polls_Polls] ADD CONSTRAINT [PK_Forum_Polls_Polls] PRIMARY KEY CLUSTERED ([PollID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Forum_Polls_Polls] ADD CONSTRAINT [FK_Forum_Polls_Polls_Modules] FOREIGN KEY ([ModuleID]) REFERENCES [dbo].[Modules] ([ModuleID]) ON DELETE CASCADE
GO
![Foreign Keys FK_Forum_Polls_Polls_Modules: [dbo].[Modules].ModuleID](../Images/fk.gif)
