CREATE TABLE [dbo].[CTPeriods]
(
[Period] [int] NOT NULL,
[StateID] [int] NOT NULL,
[FrequencyID] [int] NOT NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_CTPeriods_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdaterID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NOT NULL,
[EndDate] [datetime] NULL,
[RollingPeriods] [bit] NOT NULL CONSTRAINT [DF_CTPeriods_RollingPeriods] DEFAULT ((0)),
[StartDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTPeriods] ADD CONSTRAINT [PK_CTPeriods] PRIMARY KEY CLUSTERED ([Period]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTPeriods] ADD CONSTRAINT [FK_CTPeriods_FrequencyID_CTPeriodTypes] FOREIGN KEY ([FrequencyID]) REFERENCES [dbo].[CTPeriodTypes] ([PeriodTypeID])
GO
ALTER TABLE [dbo].[CTPeriods] ADD CONSTRAINT [FK_CTPeriods_StateID_CTPeriodStates] FOREIGN KEY ([StateID]) REFERENCES [dbo].[CTPeriodStates] ([StateID])
GO