Im building an inventory system.
I have one table which has a list of unique IDs for each inventory item and it has an attribute "taken" which is a true/false type that shows whether this ID has been used.
And I have an inventory table which has a field entry_id which is the key of that table and that field shows a list from a slice of that inventory ID pool.
Just to clerify this is the schema :
inventory(entry_id ( ref type to the pool) , rest of the fields)
inventoryIDs(entry_id(text),taken(yes/no))
I want that every time a user adds an inventory item then itll update the inventory id pool for that specific row and say its been taken .
I cant seem to figure out how to do that..
LinkedIn
Twitter
