inventory

Keeping inventory data in separate table from product data

Keeping inventory data in separate table from product data
TL;DR: what are some reasons to keep "stock" data table separate from products tables?I've built an application a while back that stores a catalog of retail products. It includes standard attributes such as size, color, image link, description,

Inventory Management - Sale Pricing

Inventory Management - Sale Pricing
This is more of an abstract architectural question.I'm working on an Inventory management system for pharmacy related area. I have all the usual components such as Product Definition(Product type, Category, etc.) Warehouse, Purchase Order, Goods Rece
What Others Are Reading