Jump to content

  • Log In with Google      Sign In   
  • Create Account


#ActualGeraint

Posted 27 December 2012 - 10:59 AM

You can easily have multiple amounts of the same item.

CHARACTER_ITEMS { ID, CID, IID, Amount }

 

Then you merely modify the Amount value to increase or decrease the number of items a character has.

 

The alternative is you store the list of items as comma separated values in the Character Table. However this is highly inefficient and will cause repetition of data, which is what relational databases are designed to eliminate.

 

I don't really see why you're against using a joining table, could you explain your reasons?


#2Geraint

Posted 27 December 2012 - 10:48 AM

You can easily have multiple amounts of the same item.

CHARACTER_ITEMS { ID, CID, IID, Amount }

Then you merely modify the Amount value to increase or decrease the number of items a character has. 


#1Geraint

Posted 27 December 2012 - 10:38 AM

You can easily have multiple amounts of the same item.

 

CHARACTER_ITEMS { ID, CID, IID, Amount }

PARTNERS