Customers

idfirstNamelastNamedateOfBirth
1JohnDoe2000-01-01
2JaneSmith1998-06-15

Accounts

idcustomerIdaccountNumberbalance
(→ Customers.id)
11ACC12345678901000.0
22ACC12345678912000.0

Products

idname
1Premium Credit Card
2Regular Checking Account

Revenue_Streams

idproductIdrevenueStreamTypeamount
(→ Products.id)
11Card Fees10.0
21Card Fees5.0
32Card Fees7.5
41Monthly Interest Rate15.0
52Monthly Interest Rate10.0

Transactions

idaccountIdtransactionDatetypeamount
(→ Accounts.id)
112022-01-01Deposit500.0
212022-01-15Withdrawal200.0
322022-01-01Deposit1000.0
422022-01-15Withdrawal300.0

Loans

idcustomerIdloanAmountinterestRatetermYearsstartDateendDate
(→ Customers.id)
115000.03.552022-01-012027-01-01
2210000.03.0102022-01-012032-01-01