Skip to main content
Schema: movement.core Table: fact_events Type: Base Table

What

This table contains the flattened events from the transaction. Each event will have a unique event index within a transaction.

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERBLOCK_NUMBER column
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
VERSIONNUMBERThe 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.
SUCCESSBOOLEANThe boolean value indicating whether the transaction was successful or not.
TX_TYPETEXTThe type of the transaction. Values will be one of “blockmetadatatransaction”,“statecheckpointtransaction”,“user_transaction”.
SENDERTEXTSender is the address of the originator account for a transaction. A transaction must be signed by the originator.
PAYLOAD_FUNCTIONTEXTThe function that is being called in the transaction payload.
EVENT_INDEXNUMBERUnique identifier for the event. This is a monotonically increasing integer that is incremented for each event. This is useful for determining the order of changes.
EVENT_TYPETEXTThe full three-part descriptive type from event. The event type consists of the eventaddress :: eventmodule :: event_resource.
EVENT_ADDRESSTEXTThe first segment of the event type
EVENT_MODULETEXTThe second segment of the event type
EVENT_RESOURCETEXTThe third segment of the event type
EVENT_DATAVARIANTThe “data” object within this event.
ACCOUNT_ADDRESSTEXTThe top level address for this event.
CREATION_NUMBERNUMBERCeation number corresponding to the event stream originating from the given account.
SEQUENCE_NUMBERNUMBERThe sequence number for an account indicates the number of transactions that have been submitted and committed on chain from that account. It is incremented every time a transaction sent from that account is executed or aborted and stored in the blockchain.
FACT_EVENTS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.