movement.core Table: fact_transactions_state_checkpoint Type: Base Table
What
These transactions are appended at the end of the block and is used as a checkpoint milestone.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | BLOCK_NUMBER column |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| VERSION | NUMBER | The version also know as the height of the transactions that have been executed on the Movement blockchain. The first transaction in the blockchain has a version of 0. The version number is incremented by 1 for each transaction that is executed on the blockchain. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| SUCCESS | BOOLEAN | The boolean value indicating whether the transaction was successful or not. |
| TX_TYPE | TEXT | The type of the transaction. Values will be one of “blockmetadatatransaction”,“statecheckpointtransaction”,“user_transaction”. |
| VM_STATUS | TEXT | For failed transactions, this fields provides context to why the transaction failed. For successful transactions, this field will be set to Executed successfully. |
| STATE_CHECKPOINT_HASH | TEXT | Hash of the state checkpoint transaction |
| ACCUMULATOR_ROOT_HASH | TEXT | The root hash of a Merkle accumulator. |
| EVENT_ROOT_HASH | TEXT | The root hash for the event. |
| FACT_TRANSACTIONS_STATE_CHECKPOINT_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |