On 2021-08-12T07:58:57 +0000 Mark Raynsford <[email protected]> wrote: > > Each row of items table describes a class of item, and indicates how > many of that class of item we have. Same goes for the item_locations > table; each row of the table indicates how many of each class of item > are in each storage location.
I'm open to suggestions as to other ways to model this in terms of tables. The inventory system is primarily concerned with sets of items, because the individual items don't have meaningful identities of their own (an individual 4.7kohm resistor is exactly the same as any other 4.7kohm resistor in the same batch from the same manufacturer). The inventory system has to track "How many of each type of item should I have?" and "Of all of the items I'm supposed to have, where are they stored?". Obviously a useful invariant is that the number of stored items should equal the number of items that you think you're supposed to have. :) -- Mark Raynsford | https://www.io7m.com
pgpLwpclX73Z5.pgp
Description: OpenPGP digital signature
