portfolioID | name | value |
---|---|---|
1 | Portfolio A | 100000.0 |
2 | Portfolio B | 200000.0 |
3 | Portfolio C | 300000.0 |
4 | Portfolio D | 400000.0 |
5 | Portfolio E | 500000.0 |
assetTypeID | typeName | description |
---|---|---|
1 | Stocks | A group of shares in a company |
2 | Bonds | A debt security |
3 | Mutual Funds | An open-ended fund that pools money from investors |
4 | Real Estate | Property owned by an individual or entity |
5 | Cryptocurrency | Digital currency designed to work as a medium of exchange |
investmentID | assetTypeID | quantity |
---|---|---|
(→ Investment_Portfolios.portfolioID) | (→ Assets.assetTypeID) | |
1 | 1 | None |
2 | 1 | None |
3 | 1 | None |
4 | 1 | None |
5 | 1 | None |