CREATE TABLE [dbo].[harbso]
(
[formobjid] [int] NOT NULL,
[BSODATEREPORTED] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOREPORTEDBY] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOORIGIN] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCATEGORY] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOPRIORITY] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOETCHOURS] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSODESCRIPTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOUSPSDRFC] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCLARITYTYPE] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCLARITYPRJID] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCLARITYFTRID] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCLARITYTASKID] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCLARITYPRJ] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOAPPLICATION] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSORELEASENUM] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCOMPONENT] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOREPORTEDOS] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSODOCUMENT] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOREVISIONNUM] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOFIXBY] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOINVESTIGATOR] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSODOCIMPACT] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOIMPACT] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSODEFECTKEY] [varchar] (19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOMILESTONE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOSEVERITY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOKEYWORD] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOINVESTNOTES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSORESOLUTION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOUNITTEST] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSODEVELOPER] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOTESTCASES] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOTESTRESULTS] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOTESTER] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSODATECONFIRMED] [datetime] NULL,
[BSODATECLOSED] [datetime] NULL,
[BSOCONFIRMEDBY] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCONFIRMEDOS] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSOCONFIRMEDVERSION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harbso] ADD CONSTRAINT [PK__harbso__53E983DD] PRIMARY KEY CLUSTERED ([formobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harbso] ADD CONSTRAINT [FK__harbso__formobji__54DDA816] FOREIGN KEY ([formobjid]) REFERENCES [dbo].[harform] ([formobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harbso] TO [harvest_group]
GRANT INSERT ON  [dbo].[harbso] TO [harvest_group]
GRANT DELETE ON  [dbo].[harbso] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harbso] TO [harvest_group]
GRANT SELECT ON  [dbo].[harbso] TO [harvest_rep]
GO