-- Table: dbo.PartitionPlanActiveTable
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[PartitionPlanActiveTable] (
	[PlanName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ViewName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[TableName] 
         AS ([TableNameCommonLiteral] + convert(varchar(6),[RecBaseDt],112)) ,
	[TableNameCommonLiteral] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[IntervalOffset] [smallint] NULL ,
	[IsCreated] [bit] NULL 
        CONSTRAINT [dft_PartitionPlanActiveTable__IsCreated] DEFAULT (0),
	[PartitionStartDt] 
         AS (convert(datetime,(convert(varchar(8),[RecBaseDt],102) + '01 '))) ,
	[PartitionEndDt] 
         AS (convert(datetime,(convert(varchar(8),dateadd(month,1,[RecBaseDt]),102) + '01 23:59:59')) - 1) ,
	[PartitionTag] AS (convert(varchar(6),[RecBaseDt],112)) ,
	[RecBaseDt] [datetime] NOT NULL ,
	[RecCreatedDt] [datetime] NULL 
        CONSTRAINT [dft_PartitionPlanActiveTables__RecCreatedDt] DEFAULT (getdate()),
	CONSTRAINT [ukc_PartitionPlanActiveTables__ViewName__PlanName__TableName] 
        UNIQUE  CLUSTERED 
	(
		[ViewName],
		[PlanName],
		[TableName]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO