movement.core Table: fact_transactions_state_checkpoint Type: View
State checkpoint transactions. Contains information about state checkpoint transactions used for
network synchronization.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | The block number. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The timestamp of the block. |
| TX_HASH | TEXT | The transaction hash. |
| VERSION | NUMBER | The transaction version number. |
| SUCCESS | BOOLEAN | Whether the transaction succeeded. |
| TX_TYPE | TEXT | The type of transaction. |
| VM_STATUS | TEXT | The VM execution status. |
| STATE_CHECKPOINT_HASH | TEXT | The state checkpoint hash. |
| ACCUMULATOR_ROOT_HASH | TEXT | The accumulator root hash. |
| EVENT_ROOT_HASH | TEXT | The event root hash. |
| FACT_TRANSACTIONS_STATE_CHECKPOINT_ID | TEXT | Unique identifier for the row. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified. |