La solicitud
“A small business inventory database with products, suppliers, warehouses, purchase orders, sales orders, and inventory movements, showing the keys that track stock.”
Entonces pruebaAdd a stocktake tableAdd a reorder alert for low stock
Qué hay en este dibujo
Lee las decisiones que hay detrás.
01
Separated Product, Category, and Inventory to normalize stock tracking per warehouse
02
Used PurchaseOrder and PurchaseOrderLine to model many-to-many relationship between orders and products
03
Included reorder level in Inventory to support automatic reorder triggers
Suitable for any small-to-medium retail or wholesale business that needs to manage inventory across locations, track suppliers, and monitor purchase orders.