CREATE TABLE [dbo].[HARAPPROVELIST]
(
[PROCESSOBJID] [int] NOT NULL,
[STATEOBJID] [int] NOT NULL,
[ISGROUP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[USROBJID] [int] NULL,
[USRGRPOBJID] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARAPPROVELIST_IND_IND] ON [dbo].[HARAPPROVELIST] ([PROCESSOBJID], [STATEOBJID], [ISGROUP], [USROBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAPPROVELIST_STGRP] ON [dbo].[HARAPPROVELIST] ([STATEOBJID], [ISGROUP]) INCLUDE ([PROCESSOBJID], [USRGRPOBJID], [USROBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAPPROVELIST] ADD CONSTRAINT [HARAPPROVELIST_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARAPPROVELIST] ADD CONSTRAINT [HARAPPROVELIST_USRGRP_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARAPPROVELIST] ADD CONSTRAINT [HARAPPROVELIST_USRID_FK] FOREIGN KEY ([USROBJID]) REFERENCES [dbo].[HARUSER] ([USROBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARAPPROVELIST table stores the definition of an approve process requirement.', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVELIST', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User group in notify list (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVELIST', 'COLUMN', N'ISGROUP'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVELIST', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVELIST', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVELIST', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVELIST', 'COLUMN', N'USROBJID'
GO