Finalise transaction creation and tracking

[SWvheerden]

Tari universe needs to use the minotari cli to create transactions.

We should do the following:

• MC creates offline sign transaction as pending
• TU takes offline pre signed tx, signs it using seed words + offline signing library
• TU updates pending tx in MC
• MC broadcasts + monitors tx

Step 1 is already exists in MC.
Step 2 is already exposed as a library in core, this needs to be implemented in TU
Step 3 has code in place in MC, but need code in TU
Step 4 is missing in MC and needs to be done.

[SWvheerden]

Step 3 we should update the pending transaction with the signed tranctions and mark it as completed.
We should then create a completed_transactions table containing the following:

unique_id
pending_tx_id -> foreign key to pending tx
status (completed, broadcast, mined_unconfirmed, mined_confirmed, rejected, canceled)
last_rejected reason
kernel_excess
sent_payref (payref of the output sent)
mined_height

[SWvheerden]

Step 4 should do the following

MC should on reorg, mark completed transactions that have a mined height higher than the reorg as completed.

On new height detected, MC should

• Check all tx that are completed/broadcast transactions, what their status is and update
  * Completed should be rebroadcast
  * Broadcast should be left as is
  * mined should be updated as mined_unconfirmed.
• If a transaction has now passed the confirmation window, it should be updated as mined_confirmed

On broadcast, if the TX is rejected, it should mark it as rejected and note the reason the base node supplied.