CREATE TABLE [dbo].[harbranch]
(
[branchobjid] [int] NOT NULL,
[packageobjid] [int] NOT NULL,
[itemobjid] [int] NOT NULL,
[ismerged] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harbranch] ADD CONSTRAINT [XPKharbranch] PRIMARY KEY CLUSTERED ([branchobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARBRANCH_ITEMID_FK] ON [dbo].[harbranch] ([itemobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harbranch_itemid_ind] ON [dbo].[harbranch] ([itemobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harbranch] ADD CONSTRAINT [HARBRANCH_ITEMID_FK] FOREIGN KEY ([itemobjid]) REFERENCES [dbo].[haritems] ([itemobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harbranch] TO [harvest_group]
GRANT INSERT ON  [dbo].[harbranch] TO [harvest_group]
GRANT DELETE ON  [dbo].[harbranch] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harbranch] TO [harvest_group]
GRANT SELECT ON  [dbo].[harbranch] TO [harvest_rep]
GO