Changes between Version 5 and Version 6 of design

Timestamp:

01/29/26 17:05:53 (10 days ago)

Author:

231020

Comment:

--

design

@@ -9 +9 @@
 
 === Табели
- - User(**__id__**, **username**, **password**, **email**, **role**)
+ - users(**__id__**, **username**, **password**, **email**, **role**)
 
- - Portfolio(**__id__**, balance, **user_id* (User)**)
+ - portfolios(**__id__**, balance, **user_id* (User)**)
 
- - PortfolioHolding(**__id__**, **quantity**, **avg_price**, **portfolio_id* (Portfolio)**, **stock_id**)
+ - portfolio_holdings(**__id__**, **quantity**, **avg_price**, **portfolio_id* (Portfolio)**, **stock_id**)
 
- - Stock(**__id__**, **symbol**, name, current_price, last_price, percentage, turnover, last_updated)
+ - stock(**__id__**, **symbol**, name, current_price, last_price, percentage, turnover, last_updated)
 
- - StockHistory(**__id__**, **price**, **timestamp**, stock_id)
+ - stock_history(**__id__**, **price**, **timestamp**, **stock_id*(Stock))
 
- - TradeRequest(**__id__**, **type**, **status**, **quantity**, **price_per_unit**, timestamp, **user_id**, **portfolio_id**, **stock_id**)
+ - trade_request(**__id__**, **type**, **status**, **quantity**, **price_per_unit**, timestamp, **user_id**, **portfolio_id*(Portfolio), **stock_id**)
 
- - Transaction(**__id__**, **type**, **quantity**, **price**, **timestamp**, **origin**, **user_id* (User)**, **stock_id* (Stock)**)
+ - transaction(**__id__**, **type**, **quantity**, **price**, **timestamp**, **origin**, **user_id* (User)**, **stock_id* (Stock)**)
 
- - WatchlistEntry(__id__, price_above, price_below, **user_id* (User)**, **stock_id* (Stock)**)
+ - watchlist(__id__, price_above, price_below, **user_id* (User)**, **stock_id* (Stock)**)
 
- - PendingLink(__token__, **email**, **provider**, **expires_at**, **created_at**)
+ - oauth_pending_links(__token__, **email**, **provider**, **expires_at**, **created_at**,**user_id*(User))
 
 
@@ -35 +35 @@
 
 === DDL скрипта за бришење на табелите и креирање на табелите 
-[[html(<a href="https://develop.finki.ukim.mk/projects_finished/TradingMK/attachment/wiki/design/ddl.sql">ddl.sql</a>)]]
+[attachment:ddl.sql]
+=== DML скрипта за полнење на табелите со податоци
 
-=== DML скрипта за полнење на табелите со податоци
-[[html(<a href="https://develop.finki.ukim.mk/projects_finished/TradingMK/attachment/wiki/design/dml.sql">dml.sql</a>)]]
+[attachment:dml.sql]
 
 == Релациски дијаграм
 
-[[Image("tradingmk - public.png")]]
+[[Image("relational_schema.png")]]