how does deal with withdrawals ?

[issolutioncombr]

Congratulations on your work, your project is truly incredible!

Considering an online sales platform, and user1 as a seller, how do you handle withdrawals when user1 requests a withdrawal?

ORDER BY transfer
\crosstabview transfer name amount
                      transfer                      | user1.external | user1.receivables | user1.available | user1.pending_outbound 
----------------------------------------------------+----------------+-------------------+-----------------+------------------------
 pglt_01KEA9YZK3F4KBW6A65G655ZA8 - payment_created  |         -50.00 |             50.00 |                 |                       
 pglt_01KEA9YZK5FGDA9B51N1SM4KN4 - payment_received |                |            -49.50 |           49.50 |                       
 pglt_01KEA9YZK6EQ6S32PRXTMZA169 - refund_created   |                |                   |          -20.00 |                  20.00
 pglt_01KEA9YZK6FJNBS4KF6GTKK7QR - refund_sent      |          20.00 |                   |                 |                 -20.00
 --- SUMS ---                                       |         -30.00 |              0.50 |           29.50 |                   0.00
(5 rows)

[pgr0ss]

pgledger isn't prescriptive on how you model your flows or which accounts you use, so you can model your flows however you like. One option would be:

user1.available -> user1.pending_outbound - withdrawal is initiated
user1.pending_outbound -> user1.withdrawal - withdrawal is finalized