How is this warehouse management system database designed?

special111

100 warehouses, the goods are the same, there are different, require statistical storage, storage, inventory,
There can only be one inventory table, and the cargo statistics of 100 warehouses cannot interfere with each other
For example, warehouse a has goods a, and warehouse b also has goods a.

面面爱面面

Can it be distinguished by goods field and affiliated warehouse field?

Rainfulce

The landlord has no experience in WMS design.
Go online and find some examples to literate first. These are the basic requirements.

atlobs

Use the two attributes of warehouse number and goods number as a key attribute.

freeway01

I agree with the above two statements. When entering the warehouse, determine which warehouse is the right one.

delraich

Before inserting data, use SELECT to find it in the database. If there is the same data, skip it and execute the next statement.

andypeng

top! As long as the database has the fields you need You write the code to calculate what you want to count!

crosswinds

Product Name / Number of Products / Warehouse

This table structure is enough

crosswinds

Count the goods in different warehouses: where goods warehouse = 'warehouse A'

Or other huh

dream88

Cargo / Warehouse / Inventory