CREATE TABLE [dbo].[HARCHECKOUTPROC]
(
[PROCESSOBJID] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[STATEOBJID] [int] NOT NULL,
[PATHOPTION] [int] NOT NULL,
[REPLACEFILE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ITEMNEWER] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UPDMODE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CONCURUPDMODE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BROWSEMODE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RESERVEMODE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SYNCMODE] [char] (1) 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,
[SHAREDWORKINGDIR] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[USECHECKINTIMESTAMP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTDIR] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VIEWPATH] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARCHECKOUTPROC] ADD CONSTRAINT [HARCHECKOUTPROC_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARCHECKOUTPROC] ADD CONSTRAINT [HARCHECKOUTPROC_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARCHECKOUTPROC table stores the definition of a check-out process. ', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Browse mode (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'BROWSEMODE'
GO
EXEC sp_addextendedproperty N'Caption', N'Client directory path name', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'CLIENTDIR'
GO
EXEC sp_addextendedproperty N'Caption', N'Concurrent update mode (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'CONCURUPDMODE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'New item (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'ITEMNEWER'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-out path option setting', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'PATHOPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Replace read-only files (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'REPLACEFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Reserve only mode (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'RESERVEMODE'
GO
EXEC sp_addextendedproperty N'Caption', N'Shared working directory flag', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'SHAREDWORKINGDIR'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Synchronize mode (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'SYNCMODE'
GO
EXEC sp_addextendedproperty N'Caption', N'Update mode (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'UPDMODE'
GO
EXEC sp_addextendedproperty N'Caption', N'Preserve file timestamp', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'USECHECKINTIMESTAMP'
GO
EXEC sp_addextendedproperty N'Caption', N'View path name', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKOUTPROC', 'COLUMN', N'VIEWPATH'
GO