Can anyone help me with an Inventory System Design?
Its got to track the location of items in the warehouse (and shop floor) for stocktake/empty peg etc... It has to handle refunds and sales.
So far ive come up with:
Product (ProductID, Name, ProductCategory,Description,Price,SupplierID)
ProductCategory(ProductCategory)
Location (LocationID, Description)
ProductLocation (ProductID, LocationID, Quantity)
Staff (StaffID,StaffName,PIN)
Customer (CustomerID, CustomerName,CustomerAddress)
Transaction (TransactionID,StaffID,CustomerID,Timestamp) - Negatives for refunds?
TransactionLine (TransactionID,ProductID,Price,Quantity)
CustomerDelivery(DeliveryID,TransactionID,CustomerID,SignedFor)
Supplier (SupplierID,SupplierName,CustomerID)
Further ideas?