CREATE TABLE [dbo].[Groups]
(
[groupID] [int] NOT NULL IDENTITY(1, 1),
[groupName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[startEpoch] [decimal] (18, 0) NULL,
[endEpoch] [decimal] (18, 0) NULL,
[externalRef] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isCurrent] [int] NULL,
[ownerUserID] [int] NULL,
[status] [int] NULL,
[escalationDate] [decimal] (18, 0) NULL,
[creatorUserID] [int] NULL,
[divisionID] [int] NULL,
[originalGroupID] [int] NULL,
[categoryID] [int] NULL CONSTRAINT [DF__Groups__category__0C50D423] DEFAULT ((0)),
[groupType] [int] NULL CONSTRAINT [DF__Groups__groupTyp__0D44F85C] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Groups] ADD CONSTRAINT [pk_groups] PRIMARY KEY CLUSTERED ([groupID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_Groups_creatorUserID] ON [dbo].[Groups] ([creatorUserID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_Groups_epochs] ON [dbo].[Groups] ([startEpoch], [groupID], [endEpoch], [ownerUserID]) ON [PRIMARY]
GO
[dbo].[Groups]
