CREATE TABLE [dbo].[SHGroup]
(
[groupID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[typeName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[scheduleInterval] [decimal] (18, 0) NULL,
[scheduleType] [decimal] (18, 0) NULL,
[scheduleTime] [decimal] (18, 0) NULL,
[scheduleSpread] [decimal] (18, 0) NULL,
[localStorageSettings] [int] NULL,
[defaultGroup] [int] NULL,
[isActive] [int] NULL CONSTRAINT [DF__SHGroup__isActiv__37FA4C37] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHGroup] ADD CONSTRAINT [PK__SHGroup__361203C5] PRIMARY KEY CLUSTERED ([groupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHGroup] ADD CONSTRAINT [FK__SHGroup__divisio__370627FE] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
[dbo].[SHGroup]
![Foreign Keys FK__SHGroup__divisio__370627FE: [dbo].[Divisions].divisionID](../../Images/fk.gif)
