Simple Database Design - Many to many? - First database (newbie)
Why have product_inventory at all?  

inventory

prod_code (foreign key of products.code) | warehouse_code (FK of warehouse.code) | &gt;inventory_count