Transaction Table

[JS]

My business has many deposits and withdrawls to post each
month. Should I use one transaction table, or should I
use a deposit table and a withdrawl table with a jumper
table connecting the two?

 

[Allen Browne]

Works either way, but the one transaction table will be more efficient.

 

[Armen Stein]

Works either way, but the one transaction table will be more efficient.

I agree with Allen - you can just have a Transaction table that holds
all kinds of transactions, positive and negative.

If you do go with two tables, you can use a UNION ALL query to mix the
two types together. This will be handy when you want to sort them by
date, for example.