I'm setting up a checking/saving/budget database for myself to replace one I set up for myself some years ago.
I've run into a dilemma while setting up the tables.
Transactions have attributes like date, payee, amount, and type (debit or deposit). Of course, debit-type transactions have one payee and one amount. But for deposit-type transactions, I'd like to be able to record where the money came from when multiple sources and amounts make up the deposit. For instance, say I go to the bank to make a $100 deposit. Maybe $50 of the $100 was cash from returning something to a store, $20 was a rebate check for a DVD player, and $20 was a check from my employer reimbursing me for something, and the last $10 was misc cash from a drawer in my house.
So that's a $100 transaction that has 3 payees (or sources, but since I want to pull suggestions from past transactions, they're really the same thing) with 3 amounts I want to record, and the remaining $10 that has no specified payee/source.
What's the best way to set these tables up?
Part 2: What is the term for what I'm asking about? Is it "db schema"? just "db design"? "db structure"? none of these? all of these?