ClientID | FirstName | LastName | EmailAddress |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Alice | Brown | alice.brown@example.com |
4 | Bob | White | bob.white@example.com |
5 | Charlie | Black | charlie.black@example.com |
AccountNumber | ClientID | Balance |
---|---|---|
(→ Clients.ClientID) | ||
108765432 | 5 | 0.0 |
123456789 | 1 | 0.0 |
543210987 | 3 | 0.0 |
654321098 | 4 | 0.0 |
987654321 | 2 | 0.0 |
InvestmentID | AccountNumber | InvestmentType | InvestmentValue |
---|---|---|---|
(→ Accounts.AccountNumber) | |||
1 | 123456789 | Stocks | 10000.0 |
2 | 987654321 | Bonds | 20000.0 |
3 | 543210987 | Mutual Funds | 30000.0 |
4 | 654321098 | Real Estate | 40000.0 |
5 | 108765432 | Cryptocurrency | 50000.0 |
FundingID | AccountNumber | FundingAmount | InvestmentType |
---|---|---|---|
(→ Accounts.AccountNumber) | |||
1 | 123456789 | 5000000.0 | Growth Equity Firm |
2 | 123456789 | 7500000.0 | Venture Capital Trust |
3 | 987654321 | 5000000.0 | Growth Equity Firm |
4 | 987654321 | 7500000.0 | Venture Capital Trust |
5 | 543210987 | 1000000.0 | Private Equity |
CompanyID | Name | Type |
---|---|---|
1 | Growth Equity Firm | Equity |
2 | Venture Capital Trust | Trust |
3 | Angel Investor | Individual |
4 | Seed Accelerator | Accelerator |
5 | Private Equity Firm | Firm |
TransactionID | InvestmentID | CompanyID | Amount | Date |
---|---|---|---|---|
(→ Investments.InvestmentID) | (→ InvestmentCompanies.CompanyID) | |||
1 | 1 | 1 | 10000.0 | 2022-01-01 00:00:00 |
2 | 2 | 2 | 15000.0 | 2022-01-01 00:00:00 |
3 | 3 | 3 | 20000.0 | 2022-01-01 00:00:00 |
4 | 4 | 4 | 25000.0 | 2022-01-01 00:00:00 |
5 | 5 | 5 | 30000.0 | 2022-01-01 00:00:00 |