CREATE TABLE [dbo].[HARDELPKGPROC]
(
[PROCESSOBJID] [int] NOT NULL,
[processname] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[stateobjid] [int] NOT NULL,
[creationtime] [datetime] NOT NULL,
[creatorid] [int] NOT NULL,
[modifiedtime] [datetime] NOT NULL,
[modifierid] [int] NOT NULL,
[note] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARDELPKGPROC] ADD CONSTRAINT [HARDELPKGPROC_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARDELPKGPROC] ADD CONSTRAINT [HARDELPKGPROC_SPID_FK] FOREIGN KEY ([stateobjid], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARDELPKGPROC table stores the definition of a delete package process. ', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'creationtime'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'creatorid'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'modifiedtime'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'modifierid'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'note'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'processname'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARDELPKGPROC', 'COLUMN', N'stateobjid'
GO