## CustomerInfo

customerID | name | address | phoneNumber | email
--- | --- | --- | --- | ---
1 | John Doe | 123 Main St | 555-1234 | john@example.com
2 | Jane Smith | 456 Elm St | 555-5678 | jane@example.com

## SavingsAccounts

accountID | customerID | balance
--- | --- | ---
| (→ CustomerInfo.customerID) |
1 | 1 | 1000.0
2 | 2 | 2000.0

## Loans

loanID | customerID | amount | rate
--- | --- | --- | ---
| (→ CustomerInfo.customerID) |  |
1 | 1 | 15000 | 0.05
2 | 2 | 20000 | 0.04

## Transactions

transactionID | accountID | type | amount | date
--- | --- | --- | --- | ---
| (→ SavingsAccounts.accountID) |  |  |
1 | 1 | Deposit | 100.0 | 2024-03-07 23:55:31
2 | 1 | Withdrawal | 50.0 | 2024-03-07 23:55:31
3 | 2 | Deposit | 200.0 | 2024-03-07 23:55:31
4 | 2 | Withdrawal | 100.0 | 2024-03-07 23:55:31

## InterestRates

id | terms | monthlyRate | annualPercentageRate | Bank_Account | additionalColumn
--- | --- | --- | --- | --- | ---
1 | Monthly Interest Rate | 0.015 | 0.18 | 1834293214 | InterestRate1
2 | Monthly Interest Rate | 0.01 | 0.12 | 9876543210 | InterestRate2
3 | Annual Percentage Rate | 0.05 | 0.6 | 1834293214 | APR1
4 | Annual Percentage Rate | 0.04 | 0.48 | 9876543210 | APR2