Changes between Version 9 and Version 10 of design

Timestamp:

02/27/26 01:46:51 (29 hours ago)

Author:

231020

Comment:

--

design

@@ -13 +13 @@
  - portfolios(**__id__**, balance, **user_id* (User)**)
 
- - portfolio_holdings(**__id__**, **quantity**, **avg_price**, **portfolio_id* (Portfolio)**, **stock_id**)
+ - portfolio_holdings(**__id__**, **quantity**, **avg_price**, **portfolio_id* (Portfolio)**, **stock_id*(Stock)**)
 
  - stock(**__id__**, **symbol**, name, current_price, last_price, percentage, turnover, last_updated)
 
- - stock_history(**__id__**, **price**, **timestamp**, **stock_id*(Stock))
+ - stock_history(**__id__**, **price**, **timestamp**, **stock_id*(Stock)**)
 
- - trade_request(**__id__**, **type**, **status**, **quantity**, **price_per_unit**, timestamp, **portfolio_id*(Portfolio), **stock_id**)
+ - trade_request(**__id__**, **type**, **status**, **quantity**, **price_per_unit**, timestamp, **portfolio_id*(Portfolio), **stock_symbol**)
 
  - transaction(**__id__**, **type**, **quantity**, **price**, **timestamp**, **origin**, **user_id* (User)**, **stock_id* (Stock)**)