CREATE TABLE [dbo].[ReportSettings]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[reportID] [int] NOT NULL,
[setting] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[value] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportSettings] ADD CONSTRAINT [PK__ReportSettings__6BAEFA67] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportSettings] ADD CONSTRAINT [fk_repset_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
[dbo].[ReportSettings]
![Foreign Keys fk_repset_div: [dbo].[Divisions].divisionID](../../Images/fk.gif)
