CREATE TABLE [dbo].[HARESD]
(
[FORMOBJID] [int] NOT NULL,
[ESDBACKOUTPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDCERTIFICATIONRESULTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDDEPLOYMENTPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDDESCRIPTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDHWDEPENDENCYNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDID] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDIMPACTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDIMPLEMENTATIONDATE] [datetime] NULL,
[ESDINITIATOR] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDINVESTIGATOR] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDPLANNEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDPRIORITY] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDREJECTEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDREJECTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDREQUESTDATE] [datetime] NULL,
[ESDREQUIREDSPACE] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDREVIEWEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDREVIEWNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDRISKLEVEL] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDSCOPE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDSCRIPTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDSWDEPENDENCYNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDTESTEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDTESTPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDTRAININGPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ESDTYPE] [varchar] (52) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARESD] ADD CONSTRAINT [HARESD_PK] 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
EXEC sp_addextendedproperty N'Caption', N'The HARESD table stores an example of a custom form.', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDBACKOUTPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDCERTIFICATIONRESULTS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDDEPLOYMENTPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDDESCRIPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDHWDEPENDENCYNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDIMPACTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDIMPLEMENTATIONDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDINITIATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDINVESTIGATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDPLANNEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDPRIORITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDREJECTEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDREJECTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDREQUESTDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDREQUIREDSPACE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDREVIEWEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDREVIEWNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDRISKLEVEL'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDSCOPE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDSCRIPTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDSWDEPENDENCYNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDTESTEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDTESTPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDTRAININGPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'ESDTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARESD', 'COLUMN', N'FORMOBJID'
GO