[dbo].[haresd]

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
esdbackoutplan	varchar(2000)	2000
esdcertificationresults	varchar(2000)	2000
esddeploymentplan	varchar(2000)	2000
esddescription	varchar(2000)	2000
esdhwdependencynotes	varchar(2000)	2000
esdid	char(40)	40
esdimpactnotes	varchar(2000)	2000
esdimplementationdate	datetime	8
esdinitiator	char(30)	30
esdinvestigator	char(30)	30
esdplannedby	char(30)	30
esdpriority	char(10)	10
esdrejectedby	char(30)	30
esdrejectnotes	varchar(2000)	2000
esdrequestdate	datetime	8
esdrequiredspace	char(40)	40
esdreviewedby	char(30)	30
esdreviewnotes	varchar(2000)	2000
esdrisklevel	char(10)	10
esdscope	varchar(2000)	2000
esdscriptnotes	varchar(2000)	2000
esdswdependencynotes	varchar(2000)	2000
esdtestedby	char(30)	30
esdtestplan	varchar(2000)	2000
esdtrainingplan	varchar(2000)	2000
esdtype	varchar(52)	52

	Name	Columns	Unique
	XPKharesd	formobjid

Name	Delete	Columns
HARESD_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].[haresd]
(
[formobjid] [int] NOT NULL,
[esdbackoutplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdcertificationresults] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esddeploymentplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esddescription] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdhwdependencynotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdid] [char] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdimpactnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdimplementationdate] [datetime] NULL,
[esdinitiator] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdinvestigator] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdplannedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdpriority] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdrejectedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdrejectnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdrequestdate] [datetime] NULL,
[esdrequiredspace] [char] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdreviewedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdreviewnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdrisklevel] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdscope] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdscriptnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdswdependencynotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdtestedby] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdtestplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdtrainingplan] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[esdtype] [varchar] (52) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[haresd] ADD CONSTRAINT [XPKharesd] PRIMARY KEY CLUSTERED ([formobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[haresd] ADD CONSTRAINT [HARESD_FORMID_FK] FOREIGN KEY ([formobjid]) REFERENCES [dbo].[harform] ([formobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[haresd] TO [harvest_group]
GRANT INSERT ON  [dbo].[haresd] TO [harvest_group]
GRANT DELETE ON  [dbo].[haresd] TO [harvest_group]
GRANT UPDATE ON  [dbo].[haresd] TO [harvest_group]
GRANT SELECT ON  [dbo].[haresd] TO [harvest_rep]
GO