[dbo].[harpac]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:03 AM Wednesday, March 07, 2007
Last Modified	11:09:57 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
formobjid	int	4
pacbackoutplan	varchar(2000)	2000
pacdatereported	datetime	8
pacdescription	varchar(2000)	2000
pacid	char(40)	40
pacimpactnotes	varchar(2000)	2000
pacimplementationdate	datetime	8
pacimplementationplan	varchar(2000)	2000
pacinitiator	char(30)	30
pacinvestigator	char(30)	30
pacowner	char(30)	30
pacplannedby	char(30)	30
pacpriority	char(10)	10
pacrejectedby	char(30)	30
pacrejectnotes	varchar(2000)	2000
pacreviewedby	char(30)	30
pacreviewnotes	varchar(2000)	2000
pacrisklevel	char(10)	10
pacscope	varchar(2000)	2000
pactestedby	char(30)	30
pactestplan	varchar(2000)	2000
pactestresults	varchar(2000)	2000
pactrainingplan	varchar(2000)	2000
pactype	varchar(52)	52

	Name	Columns	Unique
	XPKharpac	formobjid

Name	Delete	Columns
HARPAC_FORMID_FK	Cascade	formobjid->[dbo].[harform].[formobjid]

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].[harpac]
(
[formobjid] [int] NOT NULL,
[pacbackoutplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacdatereported] [datetime] NULL,
[pacdescription] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacid] [char] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacimpactnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacimplementationdate] [datetime] NULL,
[pacimplementationplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacinitiator] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacinvestigator] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacowner] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacplannedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacpriority] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacrejectedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacrejectnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacreviewedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacreviewnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacrisklevel] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pacscope] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pactestedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pactestplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pactestresults] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pactrainingplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pactype] [varchar] (52) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpac] ADD CONSTRAINT [XPKharpac] PRIMARY KEY CLUSTERED ([formobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpac] ADD CONSTRAINT [HARPAC_FORMID_FK] FOREIGN KEY ([formobjid]) REFERENCES [dbo].[harform] ([formobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harpac] TO [harvest_group]
GRANT INSERT ON  [dbo].[harpac] TO [harvest_group]
GRANT DELETE ON  [dbo].[harpac] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harpac] TO [harvest_group]
GRANT SELECT ON  [dbo].[harpac] TO [harvest_rep]
GO