CREATE TABLE [dbo].[haritemrelationship]
(
[itemobjid] [int] NOT NULL,
[refitemid] [int] NOT NULL,
[relationship] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[versionobjid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[haritemrelationship] ADD CONSTRAINT [XPKharitemrelationship] PRIMARY KEY CLUSTERED ([itemobjid], [refitemid], [versionobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [haritemrelationship_refitm_idx] ON [dbo].[haritemrelationship] ([refitemid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [haritemrelationship_rel] ON [dbo].[haritemrelationship] ([relationship], [refitemid], [versionobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[haritemrelationship] ADD CONSTRAINT [HARITEMREL_ITEMID_FK] FOREIGN KEY ([itemobjid]) REFERENCES [dbo].[haritems] ([itemobjid]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[haritemrelationship] ADD CONSTRAINT [HARITEMREL_VERID_FK] FOREIGN KEY ([versionobjid]) REFERENCES [dbo].[harversions] ([versionobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[haritemrelationship] TO [harvest_group]
GRANT INSERT ON  [dbo].[haritemrelationship] TO [harvest_group]
GRANT DELETE ON  [dbo].[haritemrelationship] TO [harvest_group]
GRANT UPDATE ON  [dbo].[haritemrelationship] TO [harvest_group]
GRANT SELECT ON  [dbo].[haritemrelationship] TO [harvest_rep]
GO