Search results
Aug 21, 2021 · I am designing a inventory stock-management system. My current understanding is that it should be similar to bank transactions, in which you take inventory from location A and put it at location B. In that case I would have a transaction table like so: id product_id amount_of_units from_location_id to_location_id
Aug 16, 2018 · 1. First, this is a really broad question, so don't be too surprised if it gets flagged for that. With regard to what you have so far, though, I see a couple of minor issues. Products.Description is TEXT. The TEXT data type has been deprecated for quite some time now, so you should change that to NVARCHAR(MAX).
Jan 10, 2018 · 1. It is likely a bad idea to use two separate tables. You will have to perform a join which is unnecessary. Simply have one table with an 'ordered' column and a 'used' column. In your query you can very efficiently calculate the net value e.g. : SELECT ordered, used, (ordered - used) as net FROM inventory. answered Jan 10, 2018 at 19:56.
Mar 23, 2013 · There are two inter-related features that I want to figure out how to implement. First, we need to manage our inventory of parts, and second, we need to track donations of computer systems as they come into us, and also as we grant them out. First, we have a simple inventory of parts. We don't need to track individual parts ( we couldn't ...
Jun 27, 2013 · I need help with designing database for following data. Time1 : x,y,z. Time2 : x,x,y,z. Time3 : x,y,W. I need to store the above in database. How should I design my table. the list of inventory (x,y,z..) can be in hundreds. mostly I will be using this to get quick history change between 2 time stamps. and inserting new inventory into table ...
Apr 5, 2017 · 0. I suppose you have a single database which serves all warehouses. Create another table. warehouses. warehouseid (PK) name. other details. And then add the field - warehouseid to table stock_balance as a FK (Foreign Key) - this way you will bind each stock of an item to a warehouse. edited Apr 5, 2017 at 11:57.
Sep 21, 2013 · You will probably have to implement different logic in your front end program for each company. Better you should develop one schema for the entire database; each table would have a field called 'CompanyID' which naturally would define to which company each row belongs. This field would be a foreign key to the Companies table.
