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