CREATE TABLE [dbo].[hardefect]
(
[formobjid] [int] NOT NULL,
[dtapplication] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtcategory] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtcomponent] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtconfirmedby] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtconfirmedos] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtconfirmedversion] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtdateclosed] [datetime] NULL,
[dtdateconfirmed] [datetime] NULL,
[dtdatereported] [datetime] NULL,
[dtdefectkey] [char] (19) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtdescription] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtdeveloper] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtdocimpact] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtdocument] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtfixby] [datetime] NULL,
[dtimpact] [char] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtinvestigator] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtinvestnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtkeyword] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtlikelihood] [char] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtmilestone] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtorigin] [char] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtothercategory] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtpriority] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtrecommend] [varchar] (77) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtreleasenum] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtreportedby] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtreportedos] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtresolution] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtrevisionnum] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtseverity] [char] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dttestcases] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dttester] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dttestresults] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dtunittest] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[hardefect] ADD CONSTRAINT [XPKhardefect] 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
GRANT SELECT ON  [dbo].[hardefect] TO [harvest_group]
GRANT INSERT ON  [dbo].[hardefect] TO [harvest_group]
GRANT DELETE ON  [dbo].[hardefect] TO [harvest_group]
GRANT UPDATE ON  [dbo].[hardefect] TO [harvest_group]
GRANT SELECT ON  [dbo].[hardefect] TO [harvest_rep]
GO