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 |