[dbo].[harlinkedprocess]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	29
Created	11:08:06 AM Wednesday, March 07, 2007
Last Modified	2:23:09 PM Friday, March 21, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:08:06 AM Wednesday, March 07, 2007

Last Modified

2:23:09 PM Friday, March 21, 2008

	Name	Data Type	Max Length (Bytes)
$Foreign Keys HARLINKEDPROCESS_SPID_FK: [dbo].[harstateprocess].stateobjid\parentprocobjid$	stateobjid	int	4
$Cluster Primary Key XPKharlinkedprocess: parentprocobjid\processobjid$ $Foreign Keys HARLINKEDPROCESS_SPID_FK: [dbo].[harstateprocess].stateobjid\parentprocobjid$ $Indexes HARLINKEDPROCESS_IND: parentprocobjid\processname\processprelink$ $Indexes HARLINKEDPROCESS_PARENT: parentprocobjid\processprelink\processorder$	parentprocobjid	int	4
$Cluster Primary Key XPKharlinkedprocess: parentprocobjid\processobjid$	processobjid	int	4
$Indexes HARLINKEDPROCESS_PARENT: parentprocobjid\processprelink\processorder$	processorder	int	4
$Indexes HARLINKEDPROCESS_IND: parentprocobjid\processname\processprelink$	processname	char(128)	128
	processtype	char(32)	32
$Indexes HARLINKEDPROCESS_IND: parentprocobjid\processname\processprelink$ $Indexes HARLINKEDPROCESS_PARENT: parentprocobjid\processprelink\processorder$	processprelink	char(1)	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Foreign Keys HARLINKEDPROCESS_SPID_FK: [dbo].[harstateprocess].stateobjid\parentprocobjid$

stateobjid

int

$Cluster Primary Key XPKharlinkedprocess: parentprocobjid\processobjid$ $Foreign Keys HARLINKEDPROCESS_SPID_FK: [dbo].[harstateprocess].stateobjid\parentprocobjid$ $Indexes HARLINKEDPROCESS_IND: parentprocobjid\processname\processprelink$ $Indexes HARLINKEDPROCESS_PARENT: parentprocobjid\processprelink\processorder$

parentprocobjid

int

$Cluster Primary Key XPKharlinkedprocess: parentprocobjid\processobjid$

processobjid

int

$Indexes HARLINKEDPROCESS_PARENT: parentprocobjid\processprelink\processorder$

processorder

int

$Indexes HARLINKEDPROCESS_IND: parentprocobjid\processname\processprelink$

processname

char(128)

128

processtype

char(32)

$Indexes HARLINKEDPROCESS_IND: parentprocobjid\processname\processprelink$ $Indexes HARLINKEDPROCESS_PARENT: parentprocobjid\processprelink\processorder$

processprelink

char(1)

	Name	Columns
$Cluster Primary Key XPKharlinkedprocess: parentprocobjid\processobjid$	XPKharlinkedprocess	parentprocobjid, processobjid
	HARLINKEDPROCESS_IND	parentprocobjid, processname, processprelink
	HARLINKEDPROCESS_PARENT	parentprocobjid, processprelink, processorder
	HARLINKEDPROCESS_POBJID	processobjid

Name

Columns

Unique

$Cluster Primary Key XPKharlinkedprocess: parentprocobjid\processobjid$

XPKharlinkedprocess

parentprocobjid, processobjid

HARLINKEDPROCESS_IND

parentprocobjid, processname, processprelink

HARLINKEDPROCESS_PARENT

parentprocobjid, processprelink, processorder

HARLINKEDPROCESS_POBJID

processobjid

Name	Delete	Columns
HARLINKEDPROCESS_SPID_FK	Cascade	stateobjid->[dbo].[harstateprocess].[stateobjid] parentprocobjid->[dbo].[harstateprocess].[processobjid]
HARLINKEDPROCESS_STATEID_FK	Cascade	stateobjid->[dbo].[harstate].[stateobjid]

Name

Delete

Columns

HARLINKEDPROCESS_SPID_FK

Cascade

stateobjid->[dbo].[harstateprocess].[stateobjid]
parentprocobjid->[dbo].[harstateprocess].[processobjid]

HARLINKEDPROCESS_STATEID_FK

Cascade

stateobjid->[dbo].[harstate].[stateobjid]

Type	Action	Owning Principal
Grant	Delete	harvest_group
Grant	Insert	harvest_group
Grant	Select	harvest_group
Grant	Update	harvest_group
Grant	Select	harvest_rep

Type

Action

Owning Principal

Grant

Delete

harvest_group

Grant

Insert

harvest_group

Grant

Select

harvest_group

Grant

Update

harvest_group

Grant

Select

harvest_rep

SQL Script

CREATE TABLE [dbo].[harlinkedprocess]
(
[stateobjid] [int] NOT NULL,
[parentprocobjid] [int] NOT NULL,
[processobjid] [int] NOT NULL,
[processorder] [int] NOT NULL,
[processname] [char] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[processtype] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[processprelink] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harlinkedprocess] ADD CONSTRAINT [XPKharlinkedprocess] PRIMARY KEY CLUSTERED ([parentprocobjid], [processobjid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARLINKEDPROCESS_IND] ON [dbo].[harlinkedprocess] ([parentprocobjid], [processname], [processprelink]) 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
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
GRANT SELECT ON  [dbo].[harlinkedprocess] TO [harvest_group]
GRANT INSERT ON  [dbo].[harlinkedprocess] TO [harvest_group]
GRANT DELETE ON  [dbo].[harlinkedprocess] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harlinkedprocess] TO [harvest_group]
GRANT SELECT ON  [dbo].[harlinkedprocess] TO [harvest_rep]
GO