Changes between Version 4 and Version 5 of Use-Case

Timestamp:

09/24/26 13:48:49 (3 days ago)

Author:

231285

Comment:

--

Use-Case

@@ -84 +84 @@
 
 ||=Use case=||=Importance=||=Why it was selected=||
-||UC0001 – Register||High||Nothing else works without it; demonstrates `INSERT` with a uniqueness check.||
-||UC0002 – Log in||High||Authenticates every Trader action; demonstrates `SELECT` with parameter binding.||
-||UC0003 – Deposit||High||Shows a multi-row transaction: `UPDATE users` plus `INSERT INTO transactions`.||
-||UC0004 – Buy||Very high||Core of the exchange: `INSERT orders`, `UPDATE users`, upsert `holdings`, ledger entry, market trade.||
-||UC0005 – Sell||Very high||Dual of Buy; demonstrates row-level `FOR UPDATE` locking, reservation of committed crypto (`holdings.reserved_quantity`) and cost-basis bookkeeping.||
-||UC0006 – Portfolio||High||Demonstrates joins over `holdings`, `markets` and `crypto`, and the `v_portfolio` view.||
-||UC0007 – Watchlist||Medium||Demonstrates N–M relation handling and `ON CONFLICT` upsert semantics.||
+||[wiki:UC0001] – Register||High||Nothing else works without it; demonstrates `INSERT` with a uniqueness check.||
+||[wiki:UC0002] – Log in||High||Authenticates every Trader action; demonstrates `SELECT` with parameter binding.||
+||[wiki:UC0003] – Deposit||High||Shows a multi-row transaction: `UPDATE users` plus `INSERT INTO transactions`.||
+||[wiki:UC0004] – Buy||Very high||Core of the exchange: `INSERT orders`, `UPDATE users`, upsert `holdings`, ledger entry, market trade.||
+||[wiki:UC0005] – Sell||Very high||Dual of Buy; demonstrates row-level `FOR UPDATE` locking, reservation of committed crypto (`holdings.reserved_quantity`) and cost-basis bookkeeping.||
+||[wiki:UC0006] – Portfolio||High||Demonstrates joins over `holdings`, `markets` and `crypto`, and the `v_portfolio` view.||
+||[wiki:UC0007] – Watchlist||Medium||Demonstrates N–M relation handling and `ON CONFLICT` upsert semantics.||
 
 == AI usage ==