Yahoo Web Search

Search results

1. stackoverflow.com › questions › 4380091Best structure for inventory database - Stack Overflow

   stackoverflow.com › questions › 4380091

   • Cached

   Sales should have at least two tables. One for the general information about the sale, the customername (there should also be a customer table most of the time to get this data from), the date, where it was shipped to etc. Then a sales detail table that includes a record for each line item in the order.

   Code sample

   create table product (

     id integer primary key,

     name varchar(100) not null,

     price decimal(6,2) not null,

     inventory integer not null...

   See more on stackoverflow

2. stackoverflow.com › questions › 287097Inventory database design - Stack Overflow

   stackoverflow.com › questions › 287097

   • Cached

   Jul 1, 2016 · 9. It depends, inventory systems are about far more than just counting items. For example, for accounting purposes, you might need to know accounting value of inventory based on FIFO (First-in-First-out) model. That can't be calculated by simple "totaling inventory received - total of inventory sold" formula.

   • I have seen both approaches at my current company and would definitely lean towards the first (calculating totals based on stock transactions). If...
   • The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises. The Data Model Resource Book, Vol. 2: A Library of D...
   • both are valid, depending on the circumstances. The former is best when the following conditions hold: the number of items to sum is relatively sm...
   • It's important to consider the existing system and the cost and risk of changing it. I work with a database that stores inventory kind of like your...
   • I think this is actually a general best-practices question about doing a (relatively) expensive count every time you need a total vs. doing that co...
   • I would opt for the first way, where. the quantity on hand is calculated totaling inventory received - total of inventory sold. The Right Way, IM...
   • I've worked on systems that solve this problem before. I think the ideal solution is a precomputed column, which gets you the best of both worlds....
   • Django-inventory geared more to fixed assets, but might give you some ideas. IE: ItemTemplate (class) -> ItemsOnHand (instance). ItemsOnHand can...
   • I can see some benefit to having the two columns, but I'm not following the part about discrepancies - you seem to be implying that having the two...

3. People also ask

   Do you keep inventory of items?

   • In the past I have developed systems that in one way or another, keep some form of inventory of items (not relevant what items). Some using languages/DB's that do not support transactions. In those cases I opted not to save item quantity on hand in a field in the item record.

   Inventory database design - Stack Overflow

   stackoverflow.com/questions/287097/inventory-database-design

   See all results for this question

   Will the inventory be updated daily at the end of the day?

   • The inventory will be updated daily at the end of the day. The problem I am facing is the following. I have a table for my products, having an id, name, price, quantity. Now I have another table for my sales, but there is my problem. What kind of fields do I need to have. At the end of the day I want to store a record like this: $ 400,-

   Best structure for inventory database - Stack Overflow

   stackoverflow.com/questions/4380091/best-structure-for-inventory-database

   See all results for this question

   How do I handle inventory of Stock Records?

   • For handling overall inventory of stock records, either create an additional class, or simply write regular code/functions, to create a container (e.g. a list) of instances of those stock records and offer functions/methods to manipulate the inventory.

   I want to create a simple inventory management system using classes a…

   stackoverflow.com/questions/67851445/i-want-to-create-a-simple-inventory-management-system-using-classes-and-data-str

   See all results for this question

   What are some good books about relational database design?

   • I started with this book: Relational Database Design Clearly Explained (The Morgan Kaufmann Series in Data Management Systems) (Paperback) by Jan L. Harrington and found it very clear and helpful

   A beginner's guide to SQL database design - Stack Overflow

   stackoverflow.com/questions/377375/a-beginners-guide-to-sql-database-design

   See all results for this question

4. stackoverflow.com › questions › 377375A beginner's guide to SQL database design - Stack Overflow

   stackoverflow.com › questions › 377375

   • Cached

   29. Experience counts for a lot, but in terms of table design you can learn a lot from how ORMs like Hibernate and Grails operate to see why they do things. In addition: Keep different types of data separate - don't store addresses in your order table, link to an address in a separate addresses table, for example.

5. stackoverflow.com › questions › 6016441sql - Table structure for inventory management in MySQL ...

   stackoverflow.com › questions › 6016441

   • Cached

   Apr 5, 2017 · 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.

6. stackoverflow.com › questions › 2025416sql - design for 'simple' inventory system - Stack Overflow

   stackoverflow.com › questions › 2025416

   • Cached

   Mar 23, 2013 · I want to make a relational database system for a local computer hardware non-profit. 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.

7. stackoverflow.com › questions › 67851445I want to create a simple inventory management system using ...

   stackoverflow.com › questions › 67851445

   • Cached

   Jun 5, 2021 · For handling overall inventory of stock records, either create an additional class, or simply write regular code/functions, to create a container (e.g. a list) of instances of those stock records and offer functions/methods to manipulate the inventory. –

8. stackoverflow.com › questions › 14200330sql - Inventory Management Table Structure - Stack Overflow

   stackoverflow.com › questions › 14200330

   • Cached

   Jan 7, 2013 · 1. Our team needs to track inventory for essentially an in-house created ERP system. We will need to frequently access the amount of inventory in the system for a given item at a given warehouse and have the ability to track what changed the inventory and when. The initial thought was to just have the adjustments table and calculate the current ...