CREATE TABLE [dbo].[HARUSERGROUP]
(
[USRGRPOBJID] [int] NOT NULL,
[USERGROUPNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARUSERGR__CREAT__1C873BEC] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARUSERGR__MODIF__1D7B6025] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GROUPEXTERNAL] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARUSERGR__GROUP__1E6F845E] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERGROUP] ADD CONSTRAINT [HARUSERGROUP_PK] PRIMARY KEY CLUSTERED ([USRGRPOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARUSERGROUP_IND] ON [dbo].[HARUSERGROUP] ([USERGROUPNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSERGROUP table stores the object user group information. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'USERGROUPNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERGROUP', 'COLUMN', N'USRGRPOBJID'
GO