CREATE TABLE [dbo].[HARPAC]
(
[FORMOBJID] [int] NOT NULL,
[PACBACKOUTPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACDATEREPORTED] [datetime] NULL,
[PACDESCRIPTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACID] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACIMPACTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACIMPLEMENTATIONDATE] [datetime] NULL,
[PACIMPLEMENTATIONPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACINITIATOR] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACINVESTIGATOR] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACOWNER] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACPLANNEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACPRIORITY] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACREJECTEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACREJECTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACREVIEWEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACREVIEWNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACRISKLEVEL] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACSCOPE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACTESTEDBY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACTESTPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACTESTRESULTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACTRAININGPLAN] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PACTYPE] [varchar] (52) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPAC] ADD CONSTRAINT [HARPAC_PK] 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
EXEC sp_addextendedproperty N'Caption', N'The HARPAC table stores an example of a custom form. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACBACKOUTPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACDATEREPORTED'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACDESCRIPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACIMPACTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACIMPLEMENTATIONDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACIMPLEMENTATIONPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACINITIATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACINVESTIGATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACOWNER'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACPLANNEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACPRIORITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACREJECTEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACREJECTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACREVIEWEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACREVIEWNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACRISKLEVEL'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACSCOPE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACTESTEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACTESTPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACTESTRESULTS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACTRAININGPLAN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARPAC', 'COLUMN', N'PACTYPE'
GO