ER Schema - bank system Hello i'm trying to model a simple banking scheme
where I have 3 transactions: withdraw, transfer, deposit.
of these 3 operations, the transfer is the only one that needs more attributes, I need to know the accounts participating in the transfer, and who received and who sent it.
At first I thought of something simple like that, but it seems very strange:

but this seems very vague to me, and when do I need the statement from the two accounts participating in the transfer?
could someone help me with this?
The way I would initially think of this (as an accountant in a previous life) is not as a transfer, but as what is going on in MY bank's account? One stored procedure would deduct funds from one of my member's accounts, and a second stored procedure (initiated by the application) would send something to the other bank system to deposit funds. The record of the transfer would go into the individual account's records as just another transaction, like a deposit or withdrawal. There would be no lasting connection between the two accounts.
Even if the transfer was between a member's checking and savings accounts, they would still be treated as essentially two transactions going on at nearly the same time. One deposit, one withdrawal.