Changes between Version 1 and Version 2 of design

Timestamp:

12/26/25 02:25:48 (3 days ago)

Author:

231020

Comment:

--

design

@@ -2 +2 @@
 == Релациско мапирање 
 
-=== Ознаки
+=== Oзнаки
+
+ - PK (Primary Key): bold + underline 
+ - FK (Foreign Key): означени со * со табела во заграда
+ - bold: задолжителен (NOT NULL) атрибут
 
 === Табели
+ - User(**__id__**, **username**, **password**, **email**, **role**)
+
+ - Portfolio(**__id__**, balance, **user_id* (User)**)
+
+ - PortfolioHolding(**__id__**, **quantity**, **avg_price**, **portfolio_id* (Portfolio)**, **stock_id**)
+
+ - Stock(**__id__**, **symbol**, name, current_price, last_price, percentage, turnover, last_updated)
+
+ - StockHistory(**__id__**, **price**, **timestamp**, stock_id)
+
+ - TradeRequest(**__id__**, **type**, **status**, **quantity**, **price_per_unit**, timestamp, **user_id**, **portfolio_id**, **stock_id**)
+
+ - 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)**)
+
+ - PendingLink(__token__, **email**, **provider**, **expires_at**, **created_at**)
+
+
+
+
+
+