Banks
id | name | green_bond_percentage | social_bond_percentage |
1 | Bank A | 0.05 | 0.0 |
2 | Bank B | 0.1 | 0.02 |
3 | Bank C | 0.06 | 0.03 |
4 | Bank D | 0.07 | 0.04 |
5 | Bank E | 0.08 | 0.05 |
GreenBonds
id | bank_id | bond_name | amount | interest_rate |
| (→ Banks.id) | | | |
1 | 1 | Green Bond A | 1000000.0 | 4.0 |
2 | 1 | Green Bond B | 2000000.0 | 4.5 |
3 | 2 | Green Bond C | 1500000.0 | 5.0 |
4 | 2 | Green Bond D | 2500000.0 | 5.5 |
5 | 3 | Green Bond E | 3000000.0 | 6.0 |
SocialBonds
id | bank_id | bond_name | amount | interest_rate |
| (→ Banks.id) | | | |
1 | 1 | Social Bond A | 1000000.0 | 3.0 |
2 | 1 | Social Bond B | 2000000.0 | 3.5 |
3 | 2 | Social Bond C | 1500000.0 | 4.0 |
4 | 2 | Social Bond D | 2500000.0 | 4.5 |
5 | 3 | Social Bond E | 3000000.0 | 5.0 |
Customers
id | first_name | last_name | email | phone_number | address |
1 | John | Doe | john@example.com | 123-456-7890 | 123 Main St |
2 | Jane | Smith | jane@example.com | 098-765-4321 | 456 Elm St |
3 | Alice | Wonderland | alice@example.com | 555-555-5555 | 789 Oak St |
4 | Bob | Builder | bob@example.com | 555-123-4567 | 135 Pine St |
5 | Charlie | Shepherd | charlie@example.com | 555-987-6543 | 246 Maple St |
Transactions
id | customer_id | bank_id | transaction_date | amount | type |
| (→ Customers.id) | (→ Banks.id) | | | |
1 | 1 | 1 | 2022-01-01 | 1000.0 | Deposit |
2 | 1 | 1 | 2022-01-02 | 500.0 | Withdrawal |
3 | 2 | 1 | 2022-01-03 | 1500.0 | Deposit |
4 | 2 | 1 | 2022-01-04 | 750.0 | Withdrawal |
5 | 3 | 1 | 2022-01-05 | 2000.0 | Deposit |
6 | 3 | 1 | 2022-01-06 | 1000.0 | Withdrawal |
7 | 4 | 2 | 2022-01-07 | 1000.0 | Deposit |
8 | 4 | 2 | 2022-01-08 | 500.0 | Withdrawal |
9 | 5 | 2 | 2022-01-09 | 1500.0 | Deposit |
10 | 5 | 2 | 2022-01-10 | 750.0 | Withdrawal |
11 | 6 | 3 | 2022-01-11 | 2000.0 | Deposit |
12 | 6 | 3 | 2022-01-12 | 1000.0 | Withdrawal |
13 | 7 | 3 | 2022-01-13 | 1500.0 | Deposit |
14 | 7 | 3 | 2022-01-14 | 750.0 | Withdrawal |
15 | 8 | 4 | 2022-01-15 | 1000.0 | Deposit |
16 | 8 | 4 | 2022-01-16 | 500.0 | Withdrawal |
17 | 9 | 4 | 2022-01-17 | 1500.0 | Deposit |
18 | 9 | 4 | 2022-01-18 | 750.0 | Withdrawal |
19 | 10 | 5 | 2022-01-19 | 2000.0 | Deposit |
20 | 10 | 5 | 2022-01-20 | 1000.0 | Withdrawal |