[dbo].[HARLINKEDPROCESS]

Property	Value
Row Count	65
Created	4:59:54 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

	Name	Data Type	Collation	Max Length (Bytes)
$Foreign Keys HARLINKEDPROCESS_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PARENTPROCOBJID$	STATEOBJID	int		4
$Cluster Primary Key HARLINKEDPROCESS_PK: PARENTPROCOBJID\PROCESSOBJID$ $Foreign Keys HARLINKEDPROCESS_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PARENTPROCOBJID$ $Indexes HARLINKEDPROCESS_IND: PARENTPROCOBJID\PROCESSNAME$ $Indexes HARLINKEDPROCESS_PARENT: PARENTPROCOBJID\PROCESSPRELINK\PROCESSORDER$	PARENTPROCOBJID	int		4
$Cluster Primary Key HARLINKEDPROCESS_PK: PARENTPROCOBJID\PROCESSOBJID$	PROCESSOBJID	int		4
$Indexes HARLINKEDPROCESS_PARENT: PARENTPROCOBJID\PROCESSPRELINK\PROCESSORDER$	PROCESSORDER	int		4
$Indexes HARLINKEDPROCESS_IND: PARENTPROCOBJID\PROCESSNAME$	PROCESSNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
	PROCESSTYPE	varchar(32)	SQL_Latin1_General_CP1_CI_AS	32
$Indexes HARLINKEDPROCESS_PARENT: PARENTPROCOBJID\PROCESSPRELINK\PROCESSORDER$	PROCESSPRELINK	char(1)	SQL_Latin1_General_CP1_CI_AS	1

	Name	Columns
$Cluster Primary Key HARLINKEDPROCESS_PK: PARENTPROCOBJID\PROCESSOBJID$	HARLINKEDPROCESS_PK	PARENTPROCOBJID, PROCESSOBJID
	HARLINKEDPROCESS_IND	PARENTPROCOBJID, PROCESSNAME
	HARLINKEDPROCESS_PARENT	PARENTPROCOBJID, PROCESSPRELINK, PROCESSORDER
	HARLINKEDPROCESS_POBJID	PROCESSOBJID
	HARLINKEDPROCESS_STATEOBJID	STATEOBJID

Name	Delete	Columns
HARLINKEDPROCESS_SPID_FK	Cascade	STATEOBJID->[dbo].[HARSTATEPROCESS].[STATEOBJID] PARENTPROCOBJID->[dbo].[HARSTATEPROCESS].[PROCESSOBJID]
HARLINKEDPROCESS_STATEID_FK	Cascade	STATEOBJID->[dbo].[HARSTATE].[STATEOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARLINKEDPROCESS table stores the definition of a linked process.
Caption	COLUMN	PARENTPROCOBJID	Object ID of parent process
Caption	COLUMN	PROCESSNAME	Name of the process
Caption	COLUMN	PROCESSOBJID	Object ID of process
Caption	COLUMN	PROCESSORDER	Order of process execution
Caption	COLUMN	PROCESSPRELINK	Pre/post link flag
Caption	COLUMN	PROCESSTYPE	Type of linked process
Caption	COLUMN	STATEOBJID	Object ID of state

SQL Script

CREATE TABLE [dbo].[HARLINKEDPROCESS]
(
[STATEOBJID] [int] NOT NULL,
[PARENTPROCOBJID] [int] NOT NULL,
[PROCESSOBJID] [int] NOT NULL,
[PROCESSORDER] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[PROCESSTYPE] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PROCESSPRELINK] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARLINKEDPROCESS] ADD CONSTRAINT [HARLINKEDPROCESS_PK] PRIMARY KEY CLUSTERED ([PARENTPROCOBJID], [PROCESSOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARLINKEDPROCESS_IND] ON [dbo].[HARLINKEDPROCESS] ([PARENTPROCOBJID], [PROCESSNAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARLINKEDPROCESS_PARENT] ON [dbo].[HARLINKEDPROCESS] ([PARENTPROCOBJID], [PROCESSPRELINK], [PROCESSORDER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARLINKEDPROCESS_POBJID] ON [dbo].[HARLINKEDPROCESS] ([PROCESSOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARLINKEDPROCESS_STATEOBJID] ON [dbo].[HARLINKEDPROCESS] ([STATEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARLINKEDPROCESS] ADD CONSTRAINT [HARLINKEDPROCESS_SPID_FK] FOREIGN KEY ([STATEOBJID], [PARENTPROCOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARLINKEDPROCESS] ADD CONSTRAINT [HARLINKEDPROCESS_STATEID_FK] FOREIGN KEY ([STATEOBJID]) REFERENCES [dbo].[HARSTATE] ([STATEOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARLINKEDPROCESS table stores the definition of a linked process. ', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of parent process', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'PARENTPROCOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Order of process execution', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'PROCESSORDER'
GO
EXEC sp_addextendedproperty N'Caption', N'Pre/post link flag', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'PROCESSPRELINK'
GO
EXEC sp_addextendedproperty N'Caption', N'Type of linked process', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'PROCESSTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARLINKEDPROCESS', 'COLUMN', N'STATEOBJID'
GO