CREATE TABLE [dbo].[act_branches_cies]
(
[brc_branch_id] [int] NOT NULL,
[brc_company_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[act_branches_cies] ADD CONSTRAINT [PK_act_branches_cies] PRIMARY KEY CLUSTERED  ([brc_branch_id], [brc_company_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[act_branches_cies] ADD CONSTRAINT [FK_act_branches_cies_act_branches] FOREIGN KEY ([brc_branch_id]) REFERENCES [dbo].[act_branches] ([br_actor_id])
GO
ALTER TABLE [dbo].[act_branches_cies] ADD CONSTRAINT [FK_act_branches_cies_act_cies] FOREIGN KEY ([brc_company_id]) REFERENCES [dbo].[act_cies] ([cie_actor_id])
GO
