UShop DB Schema
 

I just recently installed UShop/UCash 0.95c on vBulletin 3.07. I'm looking at the system in the hopes of adding onto it some functionality. I'd like the ability for users to earn cash from other pages/actions on my website.

While assessing the system (and trying to figure out what makes it tick) I noticed that there's a table "utt_store_history", while at the same time there's a field in the user table "uttstore_history".

I'm not trying to judge or be rude, I'm just trying to understand (and learn a thing or two), why is there a history table as well as a history field in the user table?

The field is just a cache of the user's history - to be shown on their history page, while the history table is used to get the history of actions and other things.

Ah, so a sacrafice of space in order to save processing time. Have you found that the history is used that much to warrant such a move?