Accounts

idnamebalance
1John Doe1000.0
2Jane Smith2000.0
3Alice Johnson3000.0
4Bob Brown4000.0
5Charlie Davis5000.0

Transactions

iddateamounttype
12022-01-01100.0Deposit
22022-01-02-50.0Withdrawal
32022-01-0375.0Transfer
42022-01-04-25.0Fee
52022-01-0550.0Interest

Information

info_iddescriptionvalue
1Transaction HistoryTransaction 1 Description
2Other Value1234.56
3Transaction HistoryTransaction 2 Description
4Other Value5678.9
5Transaction HistoryTransaction 3 Description

Bank_Statements

statement_idaccount_idtransaction_id
(→ Accounts.id)(→ Transactions.id)
111
222
333
444
555

Bank_Statement_Information

bank_statement_info_idbank_statements_idinformation_id
(→ Bank_Statements.statement_id)(→ Information.info_id)
111
212
323
424
535
621
731
841
951