| 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 |