Customers
id | firstName | lastName | dateOfBirth |
1 | John | Doe | 2000-01-01 |
2 | Jane | Smith | 1998-06-15 |
Accounts
id | customerId | accountNumber | balance |
| (→ Customers.id) | | |
1 | 1 | ACC1234567890 | 1000.0 |
2 | 2 | ACC1234567891 | 2000.0 |
Products
id | name |
1 | Premium Credit Card |
2 | Regular Checking Account |
Revenue_Streams
id | productId | revenueStreamType | amount |
| (→ Products.id) | | |
1 | 1 | Card Fees | 10.0 |
2 | 1 | Card Fees | 5.0 |
3 | 2 | Card Fees | 7.5 |
4 | 1 | Monthly Interest Rate | 15.0 |
5 | 2 | Monthly Interest Rate | 10.0 |
Transactions
id | accountId | transactionDate | type | amount |
| (→ Accounts.id) | | | |
1 | 1 | 2022-01-01 | Deposit | 500.0 |
2 | 1 | 2022-01-15 | Withdrawal | 200.0 |
3 | 2 | 2022-01-01 | Deposit | 1000.0 |
4 | 2 | 2022-01-15 | Withdrawal | 300.0 |
Loans
id | customerId | loanAmount | interestRate | termYears | startDate | endDate |
| (→ Customers.id) | | | | | |
1 | 1 | 5000.0 | 3.5 | 5 | 2022-01-01 | 2027-01-01 |
2 | 2 | 10000.0 | 3.0 | 10 | 2022-01-01 | 2032-01-01 |