Green_Bond_Portfolio

IDBond_NameIssue_DateMaturity_DateAmountGreen_BondsPercentage
1Bond A2021-03-012026-03-01100000.0Renewable Energy Bonds5%
2Bond B2021-07-012028-07-01150000.0Affordable Housing Bonds4%

Social_Bond_Portfolio

IDBond_NameIssue_DateMaturity_DateAmountSocial_BondsPercentage
1Bond C2021-09-012025-09-01200000.0Education Bonds5%
2Bond D2021-11-012024-11-01250000.0Healthcare Bonds3.5%

Savings_Accounts

Account_NumberCustomer_IDOpening_BalanceInterest_RateCreated_At
111000.00.52024-03-13 18:34:01
222000.00.32024-03-13 18:34:01

Loans

Loan_NumberCustomer_IDPrincipal_AmountAnnual_Interest_RateStart_DateEnd_DateMonthly_Payment
11150000.052021-05-012026-05-011200.0
22200000.04.52021-06-012027-06-011250.0

Employees

Employee_IDFirst_NameLast_NameDepartmentHire_Date
1JohnDoeMarketing2020-07-01
2JaneSmithHR2019-09-01

Customers

Customer_IDFirst_NameLast_NameDate_Of_BirthPhone_NumberEmail
1MichaelJohnson1990-05-15+1234567890mjohnson@example.com
2EmilyWilliams1995-08-20+0987654321emwilliams@example.com