inventory-management
php mysql inventory
I\'m creating an app for a trading card game called Magic: the Gathering and I have made a query that checks all user-submitted decks and gives you the percentage of cards you have in your inventory o[详细]
2023-04-11 06:47 分类:问答Database design for products composition
here is a little challenge for you fellow overflower. I am working with a database of products that we sell into our Web based quotation application. Each product has the following attributes:[详细]
2023-03-31 06:13 分类:问答Integrating REST services with an inventory database and SQL using Android
I\'m getting started on a contracting project bid, and I was hoping for some advice on the best way to go about it.[详细]
2023-03-29 08:11 分类:问答SQL PnL Inventory Query
I have a table containing a list of trades: Security ;Quantity ; Price ;Consid 1. IBM;+1,000 ;20;-20k 2. IBM;+2,000 ;22;-44k[详细]
2023-02-26 04:07 分类:问答inventory system: transaction-based or store quantity, update with trigger?
How would you design the data model for an inventory management system in RDBMS? Would you: store each purchase & usage, and uses SUM() and GROUP BY to calculate the warehouse quantity on-the-f[详细]
2023-02-17 16:01 分类:问答Database design question - using checkpoints in the calculation of on-hand
I have been thinking about the开发者_C百科 best way to calculate the amount of on-hand units for a given inventory item. The tables will be very large, with many transactions so it may not be realisti[详细]
2023-01-13 10:45 分类:问答How to structure database for multilevel packing items
I want to make an inventory system where items have multilevel packings e.g A carton has medium boxes , medium boxes 开发者_如何学Pythonhas small boxes and small boxes has 2 items. Please tell how to[详细]
2022-12-14 00:51 分类:问答