Customers

CustomerIDFirstNameLastNameDateOfBirth
1JohnDoe2000-01-01
2JaneSmith1985-06-15
3MichaelJohnson1975-11-23

Accounts

AccountIDCustomerIDAccountNumberAccountTypeBalance
(→ Customers.CustomerID)
111234567890Checking1000.0
229876543210Savings500.0
337654321098Credit2000.0

Transactions

TransactionIDAccountIDAmountTransactionDate
(→ Accounts.AccountID)
11-100.02022-01-10 10:00:00
2250.02022-01-11 11:00:00
33-200.02022-01-12 12:00:00

Revenues

RevenueIDAccountIDRevenueStreamProductValue
(→ Accounts.AccountID)
11Card FeesPremium Credit Card20.0
22Card FeesPlatinum Visa10.0
31Monthly Interest RatePremium Credit Card5.0
42Monthly Interest RateClassic Savings2.5