我正在试着为一个建筑仓库(那里有建筑材料的仓库)建立一个数据库。我需要知道所有储存的材料(产品),所有销售的产品和所有剩下的产品。我想这样做:
Products--> Deliver <--Depot (many to many) - here I see all the products in.
Depot--> Sell <--Products (many to many) - here I see what I have sold.
And what is left: To make a difference between "Deliver"