CREATE TABLE [dbo].[usm_plan_data]
(
[fp_id] [int] NOT NULL,
[ps_id] [int] NOT NULL,
[cp_id] [int] NOT NULL,
[item_id] [int] NOT NULL,
[type] [int] NOT NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[numeric_1] [float] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [XPKusm_plan_data] PRIMARY KEY CLUSTERED ([fp_id], [ps_id], [cp_id], [item_id], [type], [domain]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [$usm_p_r000027ed00000000] FOREIGN KEY ([cp_id]) REFERENCES [dbo].[usm_cost_pool] ([cp_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [$usm_p_r000027f700000000] FOREIGN KEY ([ps_id]) REFERENCES [dbo].[usm_planning_set] ([ps_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [$usm_p_r0000280100000000] FOREIGN KEY ([fp_id]) REFERENCES [dbo].[usm_fiscal_period] ([fp_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [$usm_p_r00002de700000000] FOREIGN KEY ([cp_id]) REFERENCES [dbo].[usm_cost_pool] ([cp_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [$usm_p_r00002df100000000] FOREIGN KEY ([ps_id]) REFERENCES [dbo].[usm_planning_set] ([ps_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [$usm_p_r00002dfb00000000] FOREIGN KEY ([fp_id]) REFERENCES [dbo].[usm_fiscal_period] ([fp_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [XFK01usm_plan_data] FOREIGN KEY ([cp_id]) REFERENCES [dbo].[usm_cost_pool] ([cp_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [XFK02usm_plan_data] FOREIGN KEY ([ps_id]) REFERENCES [dbo].[usm_planning_set] ([ps_id])
GO
ALTER TABLE [dbo].[usm_plan_data] ADD CONSTRAINT [XFK03usm_plan_data] FOREIGN KEY ([fp_id]) REFERENCES [dbo].[usm_fiscal_period] ([fp_id])
GO
GRANT SELECT ON  [dbo].[usm_plan_data] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_plan_data] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_plan_data] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_plan_data] TO [usmgroup]
GO