## Green_Bond_Portfolio

ID | Bond_Name | Issue_Date | Maturity_Date | Amount | Green_Bonds | Percentage
--- | --- | --- | --- | --- | --- | ---
1 | Bond A | 2021-03-01 | 2026-03-01 | 100000.0 | Renewable Energy Bonds | 5%
2 | Bond B | 2021-07-01 | 2028-07-01 | 150000.0 | Affordable Housing Bonds | 4%

## Social_Bond_Portfolio

ID | Bond_Name | Issue_Date | Maturity_Date | Amount | Social_Bonds | Percentage
--- | --- | --- | --- | --- | --- | ---
1 | Bond C | 2021-09-01 | 2025-09-01 | 200000.0 | Education Bonds | 5%
2 | Bond D | 2021-11-01 | 2024-11-01 | 250000.0 | Healthcare Bonds | 3.5%

## Savings_Accounts

Account_Number | Customer_ID | Opening_Balance | Interest_Rate | Created_At
--- | --- | --- | --- | ---
1 | 1 | 1000.0 | 0.5 | 2024-03-13 18:34:01
2 | 2 | 2000.0 | 0.3 | 2024-03-13 18:34:01

## Loans

Loan_Number | Customer_ID | Principal_Amount | Annual_Interest_Rate | Start_Date | End_Date | Monthly_Payment
--- | --- | --- | --- | --- | --- | ---
1 | 1 | 150000.0 | 5 | 2021-05-01 | 2026-05-01 | 1200.0
2 | 2 | 200000.0 | 4.5 | 2021-06-01 | 2027-06-01 | 1250.0

## Employees

Employee_ID | First_Name | Last_Name | Department | Hire_Date
--- | --- | --- | --- | ---
1 | John | Doe | Marketing | 2020-07-01
2 | Jane | Smith | HR | 2019-09-01

## Customers

Customer_ID | First_Name | Last_Name | Date_Of_Birth | Phone_Number | Email
--- | --- | --- | --- | --- | ---
1 | Michael | Johnson | 1990-05-15 | +1234567890 | mjohnson@example.com
2 | Emily | Williams | 1995-08-20 | +0987654321 | emwilliams@example.com