Jump to content

How advanced to you plan out your inventory systems?


Digital
 Share

Recommended Posts

  • 2 weeks later...

In the past I have typically designed inventory systems to be two-part. The first being the item itself, and the second being a function category. The item data like it's image and name is held with the item, while the function category determines if the item can do anything, like act as food for a pet or be used to paint, in a specific feature, etc. 

It can be a little tricky depending on how you want to vary these up but because I've never needed to search by the field I usually just store some kind of array or JSON in an extra field with any additional data needed for the item. Like a food item may fill up a pet's belly by 10pts or 50pts, etc. 

It makes it easy to grab items from a user's inventory then that only apply to that function category(s) when say feeding a pet. 

Link to comment
Share on other sites

I make a two part inventory system. One table is the items and all the details about the items. The other table is the user's inventory of the items that keeps track of which items they have and how many uses they have. It's pretty simple and also highly flexible, customizable and expandable. 

Edited by Design1online
Link to comment
Share on other sites

  • 4 weeks later...
On 3/22/2018 at 5:41 AM, Design1online said:

I make a two part inventory system. One table is the items and all the details about the items. The other table is the user's inventory of the items that keeps track of which items they have and how many uses they have. It's pretty simple and also highly flexible, customizable and expandable. 

That's what we do, too. We also have another table for shops and collections.

Edited by Hare
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...