Clients

idfirstNamelastNameemail
1JohnDoejohn@example.com
2JaneSmithjane@example.com
3AliceBrownalice@example.com
4CharlieBlackcharlie@example.com
5DavidWhitedavid@example.com

Accounts

accountNumberclientIdbalance
(→ Clients.id)
100115000.0
100226000.0
100337000.0
100448000.0
100559000.0

Finance_Instruments

instrumentTypepercentage
(→ Percentages.value)
Green Bonds5.0
Green Bonds6.0
Social Bonds5.0
Social Bonds6.0

Percentages

value
5.0
6.0

Loans

loanNumberaccountIdinterestRatetermYears
(→ Accounts.accountNumber)
10114.55
10225.010
10334.7515
10444.520
10555.025

Deposits

depositNumberaccountIdmaturityDaterateamount
(→ Accounts.accountNumber)
20112025-01-014.55000
20222030-01-0156000
20332035-01-014.757000
20442040-01-014.58000
20552045-01-0159000