How is this warehouse management system database designed?

newgreater

A warehouse number is OK, basically satisfying,
001 A warehouse A goods (if the goods are different, they can also be distinguished by the goods number, which is convenient for statistics)
002 Warehouse B B cargo
002 Warehouse B A cargo
.
.
.
100 NN warehouse N goods

The above is only an inventory table.

spikeleeh

The key to the problem is that the amount of data in warehouses is certainly not large, at least not reaching billions.
So, put it in a table, it's easy to find and call

endymionzxt

One table of goods information (one record for one kind of goods)
A table of beginning inventory (product name, warehouse number, beginning inventory)
One table in and out
Real-time inventory = beginning inventory + warehouse-in-warehouse
If you want to calculate the beginning inventory at a certain time, it is the ending inventory at that time

zjceo888

Just add a library

zxjcole

Name of goods/quantity of goods/warehouse
this is okay