investors
investorID | name | email |
1 | Alice Spencer | alice@example.com |
2 | Bob Johnson | bob@example.com |
3 | Carol Williams | carol@example.com |
4 | David Brown | david@example.com |
5 | Emily Davis | emily@example.com |
stocks
stockID | tickerSymbol | companyName | industry |
1 | AAPL | Apple Inc. | Technology |
2 | GOOG | Google LLC | Technology |
3 | AMZN | Amazon.com, Inc. | Retail |
4 | MSFT | Microsoft Corporation | Technology |
5 | FB | Facebook, Inc. | Technology |
portfolio
id | investorID | stockID | sharesOwned |
| (→ investors.investorID) | (→ stocks.stockID) | |
1 | 1 | 1 | 100 |
2 | 2 | 3 | 50 |
3 | 3 | 1 | 75 |
4 | 4 | 2 | 100 |
5 | 5 | 3 | 50 |
earnings
earningsID | date | EPS | investorID | stockID |
| | | (→ investors.investorID) | (→ stocks.stockID) |
1 | 2021-06-30 | 3.0 | 1 | 1 |
2 | 2021-09-30 | 4.0 | 2 | 2 |
3 | 2021-12-31 | 3.5 | 3 | 1 |
4 | 2021-09-30 | 2.8 | 4 | 2 |
5 | 2021-12-31 | 4.2 | 5 | 3 |
prices
priceID | date | sharePrice | investorID | stockID |
| | | (→ investors.investorID) | (→ stocks.stockID) |
1 | 2021-06-30 | 150.0 | 1 | 1 |
2 | 2021-09-30 | 160.0 | 2 | 2 |
3 | 2021-12-31 | 155.0 | 3 | 1 |
4 | 2021-09-30 | 170.0 | 4 | 2 |
5 | 2021-12-31 | 165.0 | 5 | 3 |