[dbo].[harpkgsinpkggrp]

Property	Value
Row Count	0
Created	11:08:03 AM Wednesday, March 07, 2007
Last Modified	1:41:38 PM Friday, May 11, 2007

Property

Value

Row Count

Created

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

Last Modified

1:41:38 PM Friday, May 11, 2007

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key XPKharpkgsinpkggrp: packageobjid\pkggrpobjid$	packageobjid	int	4
$Cluster Primary Key XPKharpkgsinpkggrp: packageobjid\pkggrpobjid$	pkggrpobjid	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKharpkgsinpkggrp: packageobjid\pkggrpobjid$

packageobjid

int

$Cluster Primary Key XPKharpkgsinpkggrp: packageobjid\pkggrpobjid$

pkggrpobjid

int

	Name	Columns	Unique	Fill Factor
$Cluster Primary Key XPKharpkgsinpkggrp: packageobjid\pkggrpobjid$	XPKharpkgsinpkggrp	packageobjid, pkggrpobjid		90
	HARPKGSINPKGGRP_IND	pkggrpobjid		90

Name

Columns

Unique

Fill Factor

$Cluster Primary Key XPKharpkgsinpkggrp: packageobjid\pkggrpobjid$

XPKharpkgsinpkggrp

packageobjid, pkggrpobjid

HARPKGSINPKGGRP_IND

pkggrpobjid

Name	Delete	Columns
HARPKGSINGRP_PKGGRPID_FK	Cascade	pkggrpobjid->[dbo].[harpackagegroup].[pkggrpobjid]

Name

Delete

Columns

HARPKGSINGRP_PKGGRPID_FK

Cascade

pkggrpobjid->[dbo].[harpackagegroup].[pkggrpobjid]

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].[harpkgsinpkggrp]
(
[packageobjid] [int] NOT NULL,
[pkggrpobjid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpkgsinpkggrp] ADD CONSTRAINT [XPKharpkgsinpkggrp] PRIMARY KEY CLUSTERED ([packageobjid], [pkggrpobjid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPKGSINPKGGRP_IND] ON [dbo].[harpkgsinpkggrp] ([pkggrpobjid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpkgsinpkggrp] ADD CONSTRAINT [HARPKGSINGRP_PKGGRPID_FK] FOREIGN KEY ([pkggrpobjid]) REFERENCES [dbo].[harpackagegroup] ([pkggrpobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harpkgsinpkggrp] TO [harvest_group]
GRANT INSERT ON  [dbo].[harpkgsinpkggrp] TO [harvest_group]
GRANT DELETE ON  [dbo].[harpkgsinpkggrp] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harpkgsinpkggrp] TO [harvest_group]
GRANT SELECT ON  [dbo].[harpkgsinpkggrp] TO [harvest_rep]
GO