CREATE TABLE [dbo].[HARMR]
(
[FORMOBJID] [int] NOT NULL,
[MRDATEREPORTED] [datetime] NULL,
[MRREPORTEDBY] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRCATEGORY] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MROTHERCATEGORY] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRAPPLICATION] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRRELEASENUM] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRHARDWARE] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MROPERATINGSYS] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRDOCUMENT] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRREVISIONNUM] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRDESCRIPT] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRKEYWORD] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRSEVERITY] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRINVESTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRINVESTIGATOR] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRRECOMMEND] [varchar] (76) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRRESOLUTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRUNITTEST] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRDEVELOPER] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRTESTRESULTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MRTESTER] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARMR] ADD CONSTRAINT [HARMR_PK] PRIMARY KEY CLUSTERED ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARMR] ADD CONSTRAINT [HARMR_FORMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARMR table stores an example of a custom form.', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRAPPLICATION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRCATEGORY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRDATEREPORTED'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRDESCRIPT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRDEVELOPER'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRDOCUMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRHARDWARE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRINVESTIGATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRINVESTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRKEYWORD'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MROPERATINGSYS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MROTHERCATEGORY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRRECOMMEND'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRRELEASENUM'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRREPORTEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRRESOLUTION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRREVISIONNUM'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRSEVERITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRTESTER'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRTESTRESULTS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARMR', 'COLUMN', N'MRUNITTEST'
GO