CREATE TABLE [dbo].[acc_bordereaux_products]
(
[bdrp_bordereau_id] [int] NOT NULL,
[bdrp_product_code] [dbo].[ais_code_short] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[acc_bordereaux_products] ADD CONSTRAINT [PK_acc_bordereaux_products] PRIMARY KEY CLUSTERED  ([bdrp_bordereau_id], [bdrp_product_code]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[acc_bordereaux_products] ADD CONSTRAINT [FK_acc_bordereaux_products_acc_bordereaux] FOREIGN KEY ([bdrp_bordereau_id]) REFERENCES [dbo].[acc_bordereaux] ([bdr_bordereau_id])
GO
ALTER TABLE [dbo].[acc_bordereaux_products] ADD CONSTRAINT [FK_acc_bordereaux_products_pr_products] FOREIGN KEY ([bdrp_product_code]) REFERENCES [dbo].[pr_products] ([prd_product_code])
GO
