[dbo].[HARPKGSINCMEW]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
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)
$Cluster Primary Key HARPKGSINCMEW_PK: EPACKAGEOBJID\PACKAGEOBJID$	EPACKAGEOBJID	int	4
	EPACKAGENAME	varchar(200)	200
$Cluster Primary Key HARPKGSINCMEW_PK: EPACKAGEOBJID\PACKAGEOBJID$	PACKAGEOBJID	int	4
	CMEWSTATUS	varchar(1)	1

	Name	Columns	Unique
$Cluster Primary Key HARPKGSINCMEW_PK: EPACKAGEOBJID\PACKAGEOBJID$	HARPKGSINCMEW_PK	EPACKAGEOBJID, PACKAGEOBJID

Name	Delete	Columns
HARPKGSINCMEW_FK	Cascade	PACKAGEOBJID->[dbo].[HARPACKAGE].[PACKAGEOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARPKGSINCMEW table stores the definition of the packages in CMEW.
Caption	COLUMN	CMEWSTATUS	CMEW executor status
Caption	COLUMN	EPACKAGENAME	Object ID of CA SCM package
Caption	COLUMN	EPACKAGEOBJID	CMEW enterprise package name
Caption	COLUMN	PACKAGEOBJID	Object ID of CA SCM package

SQL Script

CREATE TABLE [dbo].[HARPKGSINCMEW]
(
[EPACKAGEOBJID] [int] NOT NULL,
[EPACKAGENAME] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PACKAGEOBJID] [int] NOT NULL,
[CMEWSTATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPKGSINCMEW] ADD CONSTRAINT [HARPKGSINCMEW_PK] PRIMARY KEY CLUSTERED ([EPACKAGEOBJID], [PACKAGEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPKGSINCMEW] ADD CONSTRAINT [HARPKGSINCMEW_FK] FOREIGN KEY ([PACKAGEOBJID]) REFERENCES [dbo].[HARPACKAGE] ([PACKAGEOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPKGSINCMEW table stores the definition of the packages in CMEW. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINCMEW', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'CMEW executor status', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINCMEW', 'COLUMN', N'CMEWSTATUS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of CA SCM package', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINCMEW', 'COLUMN', N'EPACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'CMEW enterprise package name', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINCMEW', 'COLUMN', N'EPACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of CA SCM package', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGSINCMEW', 'COLUMN', N'PACKAGEOBJID'
GO