CREATE TABLE [dbo].[BcDimensionSetup]
(
[BcDimensionSetupId] [int] NOT NULL IDENTITY(1, 1),
[BranchBcDimensionFid] [int] NOT NULL,
[DivisionBcDimensionFid] [int] NOT NULL,
[MoveTypeBcDimensionFid] [int] NOT NULL,
[DriverSalesBcDimensionFid] [int] NOT NULL,
[ProjectBcDimensionFid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BcDimensionSetup] ADD CONSTRAINT [PK_BcDimensionSetup] PRIMARY KEY CLUSTERED  ([BcDimensionSetupId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BcDimensionSetup] ADD CONSTRAINT [FK_BcDimensionSetup_BcDimension_Branch] FOREIGN KEY ([BranchBcDimensionFid]) REFERENCES [dbo].[BcDimension] ([BcDimensionId])
GO
ALTER TABLE [dbo].[BcDimensionSetup] ADD CONSTRAINT [FK_BcDimensionSetup_BcDimension_Division] FOREIGN KEY ([DivisionBcDimensionFid]) REFERENCES [dbo].[BcDimension] ([BcDimensionId])
GO
ALTER TABLE [dbo].[BcDimensionSetup] ADD CONSTRAINT [FK_BcDimensionSetup_BcDimension_DriverSales] FOREIGN KEY ([DriverSalesBcDimensionFid]) REFERENCES [dbo].[BcDimension] ([BcDimensionId])
GO
ALTER TABLE [dbo].[BcDimensionSetup] ADD CONSTRAINT [FK_BcDimensionSetup_BcDimension_MoveType] FOREIGN KEY ([MoveTypeBcDimensionFid]) REFERENCES [dbo].[BcDimension] ([BcDimensionId])
GO
ALTER TABLE [dbo].[BcDimensionSetup] ADD CONSTRAINT [FK_BcDimensionSetup_BcDimension_Project] FOREIGN KEY ([ProjectBcDimensionFid]) REFERENCES [dbo].[BcDimension] ([BcDimensionId])
GO
GRANT SELECT ON  [dbo].[BcDimensionSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[BcDimensionSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[BcDimensionSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[BcDimensionSetup] TO [MssExec]
GO