id | month |
---|---|
1 | January |
2 | February |
3 | March |
4 | April |
5 | May |
id | fundName | totalAmount | monthId |
---|---|---|---|
(→ Months.id) | |||
1 | ABC Fund | 1000000.0 | 1 |
2 | XYZ Fund | 800000.0 | 2 |
3 | PQR Fund | 700000.0 | 3 |
4 | STU Fund | 600000.0 | 4 |
5 | WTF Fund | 500000.0 | 5 |
id | fundName | totalAmount | monthId |
---|---|---|---|
(→ Months.id) | |||
1 | AAA Fund | 900000.0 | 1 |
2 | BBB Fund | 750000.0 | 2 |
3 | CCC Fund | 650000.0 | 3 |
4 | DDD Fund | 550000.0 | 4 |
5 | EEE Fund | 450000.0 | 5 |
id | name | |
---|---|---|
1 | John Doe | john.doe@example.com |
2 | Jane Smith | jane.smith@example.com |
3 | Alice Johnson | alice.johnson@example.com |
4 | Bob Brown | bob.brown@example.com |
5 | Carol White | carol.white@example.com |
id | customerId | moneyMarketFundId | bondFundId | amount | transactionDate |
---|---|---|---|---|---|
(→ Customers.id) | (→ Money_Market_Fund.id) | (→ Bond_Fund.id) | |||
1 | 1 | 1 | None | 2000.0 | 2022-01-01 |
2 | 2 | 2 | None | 2500.0 | 2022-02-01 |
3 | 3 | 3 | None | 3000.0 | 2022-03-01 |
4 | 4 | 4 | None | 3500.0 | 2022-04-01 |
5 | 5 | 5 | None | 4000.0 | 2022-05-01 |
id | customerId | moneyMarketFundId | bondFundId | investmentAmount | startDate | endDate |
---|---|---|---|---|---|---|
(→ Customers.id) | (→ Money_Market_Fund.id) | (→ Bond_Fund.id) | ||||
1 | 1 | 1 | None | 10000.0 | 2022-01-01 | 2023-01-01 |
2 | 2 | 2 | None | 12000.0 | 2022-02-01 | 2023-02-01 |
3 | 3 | 3 | None | 14000.0 | 2022-03-01 | 2023-03-01 |
4 | 4 | 4 | None | 16000.0 | 2022-04-01 | 2023-04-01 |
5 | 5 | 5 | None | 18000.0 | 2022-05-01 | 2023-05-01 |