[dbo].[HARPACKAGEGROUP]

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

	Name	Data Type	Collation	Max Length (Bytes)	Default
	PKGGRPOBJID	int		4
$Indexes HARPKGGRP_IND: ENVOBJID\PKGGRPNAME$	PKGGRPNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
$Indexes HARPKGGRP_IND: ENVOBJID\PKGGRPNAME$	ENVOBJID	int		4
	BIND	char(1)	SQL_Latin1_General_CP1_CI_AS	1	('N')
	CREATIONTIME	datetime		8
	CREATORID	int		4
	MODIFIEDTIME	datetime		8
	MODIFIERID	int		4
	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000

	Name	Columns	Unique
	HARPACKAGEGROUP_PK	PKGGRPOBJID
	HARPKGGRP_IND	ENVOBJID, PKGGRPNAME

Name	Delete	Columns
HARPACKAGEGROUP_ENVID_FK	Cascade	ENVOBJID->[dbo].[HARENVIRONMENT].[ENVOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARPACKAGEGROUP table stores the definition of the related package group.
Caption	COLUMN	BIND	Force bind packages (Y/N)
Caption	COLUMN	CREATIONTIME	Time object was created
Caption	COLUMN	CREATORID	Object ID of creator
Caption	COLUMN	ENVOBJID	Object ID of project
Caption	COLUMN	MODIFIEDTIME	Time object was modified
Caption	COLUMN	MODIFIERID	Object ID of modifier
Caption	COLUMN	NOTE	User-defined note
Caption	COLUMN	PKGGRPNAME	Name of package group
Caption	COLUMN	PKGGRPOBJID	Object ID of package group

SQL Script

CREATE TABLE [dbo].[HARPACKAGEGROUP]
(
[PKGGRPOBJID] [int] NOT NULL,
[PKGGRPNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ENVOBJID] [int] NOT NULL,
[BIND] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARPACKAGE__BIND__1DB06A4F] DEFAULT ('N'),
[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
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPACKAGEGROUP] ADD CONSTRAINT [HARPACKAGEGROUP_PK] PRIMARY KEY CLUSTERED ([PKGGRPOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARPKGGRP_IND] ON [dbo].[HARPACKAGEGROUP] ([ENVOBJID], [PKGGRPNAME]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPACKAGEGROUP] ADD CONSTRAINT [HARPACKAGEGROUP_ENVID_FK] FOREIGN KEY ([ENVOBJID]) REFERENCES [dbo].[HARENVIRONMENT] ([ENVOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPACKAGEGROUP table stores the definition of the related package group. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Force bind packages (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'BIND'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of package group', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'PKGGRPNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package group', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGEGROUP', 'COLUMN', N'PKGGRPOBJID'
GO