Staker and Brdge backend

[Andrei-Dolgolev]

Historcal tables steps:

Order by block_timestamp DESC all tx_calls

type | submited time | token | from | to | transaction_hash | status |
withdraw | timestamp | address | L3 | L1 | hash | failed |
deposit

Under question.
1 withdraw can be extend to initialized tx_call point and to finalized tx_call.

Claimable or not uder question

moonstreamdb_v3=> select distinct ON (label_name) label_name, label_data from arbitrum_sepolia_labels where address=e'\\x64105c6c3d494469d5f21323f0e917563489d9f5';
-[ RECORD 1 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
label_name | executeTransaction
label_data | {"args": {"to": "0x857ec4ccd6c481daa2b3834440eb4d8a7db55678", "data": "", "index": 47, "proof": [[146, 145, 149, 172, 123, 234, 100, 112, 112, 217, 125, 94, 46, 40, 59, 250, 228, 101, 182, 203, 29, 110, 230, 209, 64, 162, 182, 176, 146, 40, 195, 32], [22, 20, 216, 246, 192, 96, 82, 193, 233, 171, 66, 154, 251, 91, 37, 9, 240, 92, 205, 169, 48, 51, 32, 164, 231, 234, 46, 164, 90, 223, 109, 171], [60, 196, 106, 109, 244, 142, 140, 254, 183, 142, 138, 171, 78, 23, 21, 84, 175, 181, 61, 186, 204, 189, 19, 121, 50, 172, 252, 100, 181, 170, 228, 34], [156, 68, 93, 74, 58, 98, 45, 210, 241, 241, 131, 95, 146, 109, 23, 206, 127, 55, 247, 11, 78, 216, 247, 100, 44, 219, 116, 215, 109, 41, 41, 45], [82, 173, 160, 204, 86, 185, 131, 193, 187, 135, 247, 171, 64, 176, 59, 206, 111, 253, 117, 77, 159, 14, 98, 92, 119, 145, 30, 43, 97, 254, 250, 193], [56, 60, 81, 96, 255, 88, 251, 247, 81, 149, 207, 65, 37, 225, 32, 10, 67, 27, 104, 122, 91, 41, 166, 81, 212, 149, 179, 54, 150, 173, 253, 126]], "value": 1000000000000000000, "l1Block": 6840034, "l2Block": 46371, "l2Sender": "0x857ec4ccd6c481daa2b3834440eb4d8a7db55678", "l2Timestamp": 1728416812}, "type": "tx_call", "status": 1, "gas_used": 0}
-[ RECORD 2 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
label_name | OutBoxTransactionExecuted
label_data | {"args": {"to": "0x4d790f180C71029F983c0A70901E3DcA1aAe12f5", "zero": 0, "l2Sender": "0x4d790f180C71029F983c0A70901E3DcA1aAe12f5", "transactionIndex": 21}, "name": "OutBoxTransactionExecuted", "type": "event"}
-[ RECORD 3 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
label_name | SendRootUpdated
label_data | {"args": {"outputRoot": "0x603998d0a1bb009ab96f851b5cf30db71a11c2a1a431a99e6dafc3ab48c087ed", "l2BlockHash": "0x345af363fd7dd1a333052fbdadfc3b95295ae0c69949767f072d37dce62bdd06"}, "name": "SendRootUpdated", "type": "event"}

moonstreamdb_v3=> select label_name, count(*) from arbitrum_sepolia_labels where address=e'\\x64105c6c3d494469d5f21323f0e917563489d9f5' group by 1;
-[ RECORD 1 ]-------------------------
label_name | executeTransaction
count      | 36
-[ RECORD 2 ]-------------------------
label_name | SendRootUpdated
count      | 739
-[ RECORD 3 ]-------------------------
label_name | OutBoxTransactionExecuted
count      | 33