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 [HARBRANCH_PK] PRIMARY KEY CLUSTERED ([BRANCHOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARBRANCH_ISMERGED] ON [dbo].[HARBRANCH] ([ISMERGED]) INCLUDE ([BRANCHOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARBRANCH_ITEMID_FK] ON [dbo].[HARBRANCH] ([ITEMOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARBRANCH_PKG] ON [dbo].[HARBRANCH] ([PACKAGEOBJID], [ITEMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARBRANCH] ADD CONSTRAINT [HARBRANCH_ITEMID_FK] FOREIGN KEY ([ITEMOBJID]) REFERENCES [dbo].[HARITEMS] ([ITEMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the resource type associated with the fourth-level ancestor associated with the resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.', 'SCHEMA', N'dbo', 'TABLE', N'HARBRANCH', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of branch', 'SCHEMA', N'dbo', 'TABLE', N'HARBRANCH', 'COLUMN', N'BRANCHOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Branch has been merged (1/ 0)', 'SCHEMA', N'dbo', 'TABLE', N'HARBRANCH', 'COLUMN', N'ISMERGED'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of item associates to this branch', 'SCHEMA', N'dbo', 'TABLE', N'HARBRANCH', 'COLUMN', N'ITEMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package associates to this branch', 'SCHEMA', N'dbo', 'TABLE', N'HARBRANCH', 'COLUMN', N'PACKAGEOBJID'
GO