CREATE TABLE [dbo].[HARNOTIFY]
(
[PROCESSOBJID] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[PARENTPROCOBJID] [int] NULL,
[STATEOBJID] [int] NULL,
[OUTPUTTARGET] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ONERRORACTION] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[MAILFACILITY] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MESSAGE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SUBJECT] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARNOTIFY] ADD CONSTRAINT [HARNOTIFY_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARNOTIFY_PARENTPROCOBJID] ON [dbo].[HARNOTIFY] ([PARENTPROCOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARNOTIFY] ADD CONSTRAINT [HARNOTIFY_PPID_FK] FOREIGN KEY ([PARENTPROCOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARLINKEDPROCESS] ([PARENTPROCOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARNOTIFY table stores the definition of a notify process. ', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of mail program', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'MAILFACILITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined message', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'MESSAGE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'DISPLAY or DISCARD', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'ONERRORACTION'
GO
EXEC sp_addextendedproperty N'Caption', N'DISPLAY or DISCARD', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'OUTPUTTARGET'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of parent process', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'PARENTPROCOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Mail message subject', 'SCHEMA', N'dbo', 'TABLE', N'HARNOTIFY', 'COLUMN', N'SUBJECT'
GO