CREATE TABLE [dbo].[HARNOTIFYLIST]
(
[PROCESSOBJID] [int] NOT NULL,
[PARENTPROCOBJID] [int] NULL,
[STATEOBJID] [int] NULL,
[ISGROUP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[USROBJID] [int] NULL,
[USRGRPOBJID] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARNOTIFYLIST_PARENTPROCOBJID] ON [dbo].[HARNOTIFYLIST] ([PARENTPROCOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARNOTIFYLIST_IND] ON [dbo].[HARNOTIFYLIST] ([PROCESSOBJID], [STATEOBJID], [PARENTPROCOBJID], [ISGROUP], [USROBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARNOTIFYLIST] ADD CONSTRAINT [HARNOTIFYLIST_PPID_FK] FOREIGN KEY ([PARENTPROCOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARLINKEDPROCESS] ([PARENTPROCOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARNOTIFYLIST] ADD CONSTRAINT [HARNOTIFYLIST_USRGRPID_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARNOTIFYLIST] ADD CONSTRAINT [HARNOTIFYLIST_USRID_FK] FOREIGN KEY ([USROBJID]) REFERENCES [dbo].[HARUSER] ([USROBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARNOTIFYLIST table stores the definition of notification requirements. ', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User group in notify list (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', 'COLUMN', N'ISGROUP'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of parent process', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', 'COLUMN', N'PARENTPROCOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFYLIST', 'COLUMN', N'USROBJID'
GO