[dbo].[HARINTMRGPROC]

Property	Value
Row Count	7
Created	4:59:52 AM Monday, March 02, 2009
Last Modified	5:00:26 AM Monday, March 02, 2009

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Foreign Keys HARINTMRGPROC_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$	PROCESSOBJID	int		4
	PROCESSNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
$Foreign Keys HARINTMRGPROC_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$	STATEOBJID	int		4
	CREATIONTIME	datetime		8
	CREATORID	int		4
	MODIFIEDTIME	datetime		8
	MODIFIERID	int		4
	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000
	MERGEWAY	int		4	((0))

	Name	Columns	Unique
	HARINTMRGPROC_PK	PROCESSOBJID

Name	Delete	Columns
HARINTMRGPROC_SPID_FK	Cascade	STATEOBJID->[dbo].[HARSTATEPROCESS].[STATEOBJID] PROCESSOBJID->[dbo].[HARSTATEPROCESS].[PROCESSOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARINTMRGPROC table stores the definition of an interactive merge process.
Caption	COLUMN	CREATIONTIME	Time object was created
Caption	COLUMN	CREATORID	Object ID of creator
Caption	COLUMN	MERGEWAY	2-way or 3-way merge (0/1)
Caption	COLUMN	MODIFIEDTIME	Time object was modified
Caption	COLUMN	MODIFIERID	Object ID of modifier
Caption	COLUMN	NOTE	User-defined note
Caption	COLUMN	PROCESSNAME	Name of the process
Caption	COLUMN	PROCESSOBJID	Object ID of process
Caption	COLUMN	STATEOBJID	Object ID of state

SQL Script

CREATE TABLE [dbo].[HARINTMRGPROC]
(
[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,
[MERGEWAY] [int] NOT NULL CONSTRAINT [DF__HARINTMRG__MERGE__693CA210] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARINTMRGPROC] ADD CONSTRAINT [HARINTMRGPROC_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARINTMRGPROC] ADD CONSTRAINT [HARINTMRGPROC_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARINTMRGPROC table stores the definition of an interactive merge process. ', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'2-way or 3-way merge (0/1)', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'MERGEWAY'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARINTMRGPROC', 'COLUMN', N'STATEOBJID'
GO