id | firstName | lastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Alice | Brown | alice.brown@example.com |
4 | Charlie | Black | charlie.black@example.com |
5 | David | White | david.white@example.com |
accountNumber | customerId | balance |
---|---|---|
(→ Customers.id) | ||
123456789 | 1 | 10000.0 |
123456790 | 2 | 5000.0 |
123456791 | 3 | 20000.0 |
123456792 | 4 | 15000.0 |
123456793 | 5 | 10000.0 |
investmentId | accountNumber | growthEquityFirm | ventureCapitalTrust | fundingAmount |
---|---|---|---|---|
(→ Accounts.accountNumber) | ||||
1 | 123456789 | CompanyA | None | 5000000.0 |
2 | 123456790 | CompanyB | None | 2000000.0 |
3 | 123456791 | CompanyC | None | 1000000.0 |
4 | 123456792 | CompanyD | TrustX | 5000000.0 |
5 | 123456793 | CompanyE | TrustY | 3000000.0 |
transactionId | accountNumber | amount | transactionDate |
---|---|---|---|
(→ Accounts.accountNumber) | |||
1 | 123456789 | 2000.0 | 2024-03-13 20:42:30 |
2 | 123456790 | -1500.0 | 2024-03-13 20:42:30 |
3 | 123456791 | 1000.0 | 2024-03-13 20:42:30 |
4 | 123456792 | 1200.0 | 2024-03-13 20:42:30 |
5 | 123456793 | -800.0 | 2024-03-13 20:42:30 |