growth_equity
id | firm_name | funding_amount | deal_date | notes |
1 | Company A | 5000000.0 | 2023-06-18 | Initial Investment |
2 | Company B | 7000000.0 | 2023-06-19 | Series B Funding Round |
3 | Company C | 2000000.0 | 2023-06-20 | Seed Capital |
4 | Company D | 4000000.0 | 2023-06-21 | Pre-Series A Financing |
5 | Company E | 9000000.0 | 2023-06-22 | Series C Funding |
venture_capital
id | trust_name | funding_amount | investment_period | exit_strategy |
1 | VC Trust 1 | 5000000.0 | 2021-01-01 | IPO Exit |
2 | VC Trust 2 | 3000000.0 | 2019-01-01 | Acquisition Exit |
3 | VC Trust 3 | 6000000.0 | 2020-01-01 | Merger Exit |
4 | VC Trust 4 | 8000000.0 | 2022-01-01 | Secondary Share Sale |
5 | VC Trust 5 | 10000000.0 | 2024-01-01 | Return of Capital |
customers
customer_id | company_name | address | contact_person_name | phone_number | email | equity_firm_id | venture_capital_id |
| | | | | | (→ growth_equity.id) | (→ venture_capital.id) |
1 | Customer 1 | 123 Main St | John Doe | 555-1234 | john@example.com | 1 | 1 |
2 | Customer 2 | 456 Elm St | Jane Smith | 555-5678 | jane@example.com | 2 | 2 |
3 | Customer 3 | 789 Oak St | Michael Johnson | 555-9101 | michael@example.com | 3 | 3 |
4 | Customer 4 | 246 Pine St | Emily Davis | 555-1314 | emily@example.com | 4 | 4 |
5 | Customer 5 | 678 Fir St | David Brown | 555-2425 | david@example.com | 5 | 5 |
employees
employee_id | name | hire_date | position | assigned_customer_id |
| | | | (→ customers.customer_id) |
1 | Alice | 2023-01-15 | Account Manager | 1 |
2 | Bob | 2023-02-15 | Business Analyst | 2 |
3 | Charlie | 2023-03-15 | Financial Advisor | 3 |
4 | Diana | 2023-04-15 | Marketing Specialist | 4 |
5 | Eva | 2023-05-15 | Data Scientist | 5 |