id | name | balance |
---|---|---|
1 | John Doe | 1000.0 |
2 | Jane Smith | 2000.0 |
3 | Alice Johnson | 3000.0 |
4 | Bob Brown | 4000.0 |
5 | Charlie Davis | 5000.0 |
id | date | amount | type |
---|---|---|---|
1 | 2022-01-01 | 100.0 | Deposit |
2 | 2022-01-02 | -50.0 | Withdrawal |
3 | 2022-01-03 | 75.0 | Transfer |
4 | 2022-01-04 | -25.0 | Fee |
5 | 2022-01-05 | 50.0 | Interest |
info_id | description | value |
---|---|---|
1 | Transaction History | Transaction 1 Description |
2 | Other Value | 1234.56 |
3 | Transaction History | Transaction 2 Description |
4 | Other Value | 5678.9 |
5 | Transaction History | Transaction 3 Description |
statement_id | account_id | transaction_id |
---|---|---|
(→ Accounts.id) | (→ Transactions.id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
bank_statement_info_id | bank_statements_id | information_id |
---|---|---|
(→ Bank_Statements.statement_id) | (→ Information.info_id) | |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 3 |
4 | 2 | 4 |
5 | 3 | 5 |
6 | 2 | 1 |
7 | 3 | 1 |
8 | 4 | 1 |
9 | 5 | 1 |