CREATE TABLE [dbo].[HARDEFECT]
(
[FORMOBJID] [int] NOT NULL,
[DTAPPLICATION] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTCATEGORY] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTCOMPONENT] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTCONFIRMEDBY] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTCONFIRMEDOS] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTCONFIRMEDVERSION] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTDATECLOSED] [datetime] NULL,
[DTDATECONFIRMED] [datetime] NULL,
[DTDATEREPORTED] [datetime] NULL,
[DTDEFECTKEY] [char] (19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTDESCRIPTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTDEVELOPER] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTDOCIMPACT] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTDOCUMENT] [char] (130) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTFIXBY] [datetime] NULL,
[DTIMPACT] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTINVESTIGATOR] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTINVESTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTKEYWORD] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTLIKELIHOOD] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTMILESTONE] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTORIGIN] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTOTHERCATEGORY] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTPRIORITY] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTRECOMMEND] [varchar] (77) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTRELEASENUM] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTREPORTEDBY] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTREPORTEDOS] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTRESOLUTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTREVISIONNUM] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTSEVERITY] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTTESTCASES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTTESTER] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTTESTRESULTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTUNITTEST] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARDEFECT] ADD CONSTRAINT [HARDEFECT_PK] PRIMARY KEY CLUSTERED ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARDEFECT] ADD CONSTRAINT [HARDEFECT_FORMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARDEFECT table stores an example of a custom form.', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTAPPLICATION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTCATEGORY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTCOMPONENT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTCONFIRMEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTCONFIRMEDOS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTCONFIRMEDVERSION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDATECLOSED'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDATECONFIRMED'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDATEREPORTED'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDEFECTKEY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDESCRIPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDEVELOPER'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDOCIMPACT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTDOCUMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTFIXBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTIMPACT'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTINVESTIGATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTINVESTNOTES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTKEYWORD'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTLIKELIHOOD'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTMILESTONE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTORIGIN'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTOTHERCATEGORY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTPRIORITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTRECOMMEND'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTRELEASENUM'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTREPORTEDBY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTREPORTEDOS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTRESOLUTION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTREVISIONNUM'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTSEVERITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTTESTCASES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTTESTER'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTTESTRESULTS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'DTUNITTEST'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARDEFECT', 'COLUMN', N'FORMOBJID'
GO