Banks

idnamegreen_bond_percentagesocial_bond_percentage
1Bank A0.050.0
2Bank B0.10.02
3Bank C0.060.03
4Bank D0.070.04
5Bank E0.080.05

GreenBonds

idbank_idbond_nameamountinterest_rate
(→ Banks.id)
11Green Bond A1000000.04.0
21Green Bond B2000000.04.5
32Green Bond C1500000.05.0
42Green Bond D2500000.05.5
53Green Bond E3000000.06.0

SocialBonds

idbank_idbond_nameamountinterest_rate
(→ Banks.id)
11Social Bond A1000000.03.0
21Social Bond B2000000.03.5
32Social Bond C1500000.04.0
42Social Bond D2500000.04.5
53Social Bond E3000000.05.0

Customers

idfirst_namelast_nameemailphone_numberaddress
1JohnDoejohn@example.com123-456-7890123 Main St
2JaneSmithjane@example.com098-765-4321456 Elm St
3AliceWonderlandalice@example.com555-555-5555789 Oak St
4BobBuilderbob@example.com555-123-4567135 Pine St
5CharlieShepherdcharlie@example.com555-987-6543246 Maple St

Transactions

idcustomer_idbank_idtransaction_dateamounttype
(→ Customers.id)(→ Banks.id)
1112022-01-011000.0Deposit
2112022-01-02500.0Withdrawal
3212022-01-031500.0Deposit
4212022-01-04750.0Withdrawal
5312022-01-052000.0Deposit
6312022-01-061000.0Withdrawal
7422022-01-071000.0Deposit
8422022-01-08500.0Withdrawal
9522022-01-091500.0Deposit
10522022-01-10750.0Withdrawal
11632022-01-112000.0Deposit
12632022-01-121000.0Withdrawal
13732022-01-131500.0Deposit
14732022-01-14750.0Withdrawal
15842022-01-151000.0Deposit
16842022-01-16500.0Withdrawal
17942022-01-171500.0Deposit
18942022-01-18750.0Withdrawal
191052022-01-192000.0Deposit
201052022-01-201000.0Withdrawal