CREATE TABLE [dbo].[HARAPPROVEHIST]
(
[PACKAGEOBJID] [int] NOT NULL,
[ENVOBJID] [int] NOT NULL,
[STATEOBJID] [int] NOT NULL,
[USROBJID] [int] NOT NULL,
[EXECDTIME] [datetime] NOT NULL,
[ACTION] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAPPROVEHIST] ADD CONSTRAINT [HARAPPROVEHIST_PK] PRIMARY KEY CLUSTERED ([ENVOBJID], [STATEOBJID], [PACKAGEOBJID], [USROBJID], [EXECDTIME], [ACTION]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAPPROVEHIST_IND] ON [dbo].[HARAPPROVEHIST] ([PACKAGEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAPPROVEHIST] ADD CONSTRAINT [HARAPPROVEHIST_ENVID_FK] FOREIGN KEY ([ENVOBJID]) REFERENCES [dbo].[HARENVIRONMENT] ([ENVOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARAPPROVEHIST table stores the history of an approve process.', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Action performed on object', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'ACTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of object execution', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'EXECDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'PACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVEHIST', 'COLUMN', N'USROBJID'
GO