CREATE TABLE [dbo].[HARUSERSINGROUP]
(
[USROBJID] [int] NOT NULL,
[USRGRPOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERSINGROUP] ADD CONSTRAINT [HARUSERSINGROUP_PK] PRIMARY KEY CLUSTERED ([USROBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSERSINGROUP_BASELINE_IND] ON [dbo].[HARUSERSINGROUP] ([USRGRPOBJID]) INCLUDE ([USROBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERSINGROUP] ADD CONSTRAINT [HARUSRINGRP_USRGRPID_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARUSERSINGROUP] ADD CONSTRAINT [HARUSRINGRP_USRID_FK] FOREIGN KEY ([USROBJID]) REFERENCES [dbo].[HARUSER] ([USROBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSERSINGROUP table stores the relationship between users and user groups. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERSINGROUP', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERSINGROUP', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERSINGROUP', 'COLUMN', N'USROBJID'
GO