[dbo].[HARASSOCPKG]

Property	Value
Row Count	12
Created	4:59:32 AM Monday, March 02, 2009
Last Modified	5:00:25 AM Monday, March 02, 2009

Property

Value

Row Count

Created

4:59:32 AM Monday, March 02, 2009

Last Modified

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

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key HARASSOCPKG_PK: FORMOBJID\ASSOCPKGID$	FORMOBJID	int	4
$Cluster Primary Key HARASSOCPKG_PK: FORMOBJID\ASSOCPKGID$	ASSOCPKGID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key HARASSOCPKG_PK: FORMOBJID\ASSOCPKGID$

FORMOBJID

int

$Cluster Primary Key HARASSOCPKG_PK: FORMOBJID\ASSOCPKGID$

ASSOCPKGID

int

	Name	Columns	Unique
$Cluster Primary Key HARASSOCPKG_PK: FORMOBJID\ASSOCPKGID$	HARASSOCPKG_PK	FORMOBJID, ASSOCPKGID
	HARASSOCPKG_IND	ASSOCPKGID

Name

Columns

Unique

$Cluster Primary Key HARASSOCPKG_PK: FORMOBJID\ASSOCPKGID$

HARASSOCPKG_PK

FORMOBJID, ASSOCPKGID

HARASSOCPKG_IND

ASSOCPKGID

Name	Delete	Columns
HARASSOCPKG_AID_FK	Cascade	ASSOCPKGID->[dbo].[HARPACKAGE].[PACKAGEOBJID]
HARASSOCPKG_FID_FK	Cascade	FORMOBJID->[dbo].[HARFORM].[FORMOBJID]

Name

Delete

Columns

HARASSOCPKG_AID_FK

Cascade

ASSOCPKGID->[dbo].[HARPACKAGE].[PACKAGEOBJID]

HARASSOCPKG_FID_FK

Cascade

FORMOBJID->[dbo].[HARFORM].[FORMOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARASSOCPKG table stores the information for associated packages.
Caption	COLUMN	ASSOCPKGID	Object ID of package
Caption	COLUMN	FORMOBJID	Object ID of form

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARASSOCPKG table stores the information for associated packages.

Caption

COLUMN

ASSOCPKGID

Object ID of package

Caption

COLUMN

FORMOBJID

Object ID of form

SQL Script

CREATE TABLE [dbo].[HARASSOCPKG]
(
[FORMOBJID] [int] NOT NULL,
[ASSOCPKGID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARASSOCPKG] ADD CONSTRAINT [HARASSOCPKG_PK] PRIMARY KEY CLUSTERED ([FORMOBJID], [ASSOCPKGID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARASSOCPKG_IND] ON [dbo].[HARASSOCPKG] ([ASSOCPKGID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARASSOCPKG] ADD CONSTRAINT [HARASSOCPKG_AID_FK] FOREIGN KEY ([ASSOCPKGID]) REFERENCES [dbo].[HARPACKAGE] ([PACKAGEOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARASSOCPKG] ADD CONSTRAINT [HARASSOCPKG_FID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARASSOCPKG table stores the information for associated packages.', 'SCHEMA', N'dbo', 'TABLE', N'HARASSOCPKG', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARASSOCPKG', 'COLUMN', N'ASSOCPKGID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARASSOCPKG', 'COLUMN', N'FORMOBJID'
GO