[dbo].[HARPKGSINPKGGRP]

Property	Value
Row Count	0
Created	5:00:03 AM Monday, March 02, 2009
Last Modified	5:00:27 AM Monday, March 02, 2009

Property

Value

Row Count

Created

5:00:03 AM Monday, March 02, 2009

Last Modified

5:00:27 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key HARPKGSINPKGGRP_PK: PACKAGEOBJID\PKGGRPOBJID$	PACKAGEOBJID	int	4
$Cluster Primary Key HARPKGSINPKGGRP_PK: PACKAGEOBJID\PKGGRPOBJID$	PKGGRPOBJID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key HARPKGSINPKGGRP_PK: PACKAGEOBJID\PKGGRPOBJID$

PACKAGEOBJID

int

$Cluster Primary Key HARPKGSINPKGGRP_PK: PACKAGEOBJID\PKGGRPOBJID$

PKGGRPOBJID

int

	Name	Columns	Unique
$Cluster Primary Key HARPKGSINPKGGRP_PK: PACKAGEOBJID\PKGGRPOBJID$	HARPKGSINPKGGRP_PK	PACKAGEOBJID, PKGGRPOBJID
	HARPKGSINPKGGRP_IND	PKGGRPOBJID

Name

Columns

Unique

$Cluster Primary Key HARPKGSINPKGGRP_PK: PACKAGEOBJID\PKGGRPOBJID$

HARPKGSINPKGGRP_PK

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]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARPKGSINPKGGRP table stores the relationship between packages and package groups.
Caption	COLUMN	PACKAGEOBJID	Object ID of package
Caption	COLUMN	PKGGRPOBJID	Object ID of package group

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARPKGSINPKGGRP table stores the relationship between packages and package groups.

Caption

COLUMN

PACKAGEOBJID

Object ID of package

Caption

COLUMN

PKGGRPOBJID

Object ID of package group

SQL Script

CREATE TABLE [dbo].[HARPKGSINPKGGRP]
(
[PACKAGEOBJID] [int] NOT NULL,
[PKGGRPOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPKGSINPKGGRP] ADD CONSTRAINT [HARPKGSINPKGGRP_PK] PRIMARY KEY CLUSTERED ([PACKAGEOBJID], [PKGGRPOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPKGSINPKGGRP_IND] ON [dbo].[HARPKGSINPKGGRP] ([PKGGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPKGSINPKGGRP] ADD CONSTRAINT [HARPKGSINGRP_PKGGRPID_FK] FOREIGN KEY ([PKGGRPOBJID]) REFERENCES [dbo].[HARPACKAGEGROUP] ([PKGGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPKGSINPKGGRP table stores the relationship between packages and package groups. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINPKGGRP', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINPKGGRP', 'COLUMN', N'PACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package group', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINPKGGRP', 'COLUMN', N'PKGGRPOBJID'
GO