Hey, guys.
I've been wondering what would / should be the best way to store data in a table for credit / debit / balance purposes.
Please, consider the following scenario:
Now, three different examples:
As far as I remember, I've always designed my tables according to the "Storage Example 3", but is it the best way to do it?
By the way, I never store the description text; I store the description ID only, but for a better understanding of the examples, I kept the description text.
What is the correct / best practice / most used way to store such data? Example 1, 2 or 3? Or is there another way to do it that I'm not aware of?
Thanks for your time, guys.
brunces