How is this warehouse management system database designed?

gzjingpeng

Add a column to the inventory table to store the warehouse code

a warehouse adds a filter condition when reading data: warehouse code = 'a'
In the column where the data is saved, it is marked as warehouse a

In this way, each warehouse is independent and does not interfere with each other

siyonggang

Create a table warehouse
Warehouse id, item id number of items

raper2003

Requires pretty perverted ha.
Cargo ID Cargo specifications …… Quantity …… Warehouse 001 …… Warehouse 100 ……

Simpler

chengyu876

This is designed for multi-user concurrency issues
Using serialized update is only a bit less efficient, and it should be enough to solve this problem

elucernd

A column of data in the inventory table stores the warehouse code, recording what warehouse each piece of data belongs to

justindx

Such a simple question .........

wait4you

One field represents the warehouse, one field represents the category of goods, and one field represents the quantity of goods

joe2086

A warehouse information table (warehouse number, address, person in charge...), a goods flow information (goods number, batch, warehouse number, operation date, warehouse entry or exit, quantity, stretcher, amount),

sd1471123

No problem in design

wu_redfox

Fields: note number, note year number, note type (out, in) note date, note sequence (used for multiple goods warehousing with the same note number), material code, warehouse code, entry and exit type, transaction quantity loan, transaction Quantity loan, transaction amount loan, transaction amount loan, tax rate.

It should be able to meet the needs. When making statistics, you can group by the document type, access type, warehouse code, etc.