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 |