Skip to main content
Schema: crosschain.olas Table: fact_service_events Type: View

What

This fact-based table contains all emitted events related to registered services and service multisigs within the OLAS protocol. For EVMs, this is accomplished by joining all events where the transaction’s origin_to_address = multisig_address to showcase the onchain interactions with each service. If a service does not have an associated multisig, it will not be included in this table. Various chain-specific columns may be null, as this table joins together the EVM and SVM.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain, Network, or Platform the transaction or event occurs on.
BLOCK_NUMBERNUMBERThe block number at which the transaction is finalized.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this transaction in UTC
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
ORIGIN_FROM_ADDRESSTEXTThe address that initiates the transaction. If a transaction generates multiple events, all of them will have the same originfromaddress.
ORIGIN_TO_ADDRESSTEXTThe address that receives the transaction. If a transaction generates multiple events, all of them will have the same origintoaddress.
CONTRACT_ADDRESSTEXTThe address of the contract interacted with.
EVENT_INDEXNUMBEREvent number within a transaction.
MULTISIG_ADDRESSTEXTThe address of the multi-signature wallet, typically a GnosisSafe.
SERVICE_IDNUMBERThe unique identifier of the registered Service.
TOPIC_0TEXTThe non-decoded event input topics.
TOPIC_1TEXTThe non-decoded event input topics.
TOPIC_2TEXTThe non-decoded event input topics.
TOPIC_3TEXTThe non-decoded event input topics.
DATATEXTThe non-decoded, raw data emitted from an event.
SEGMENTED_DATAARRAYThe raw emitted event log data, segmented into a variant column for further manual decoding and analysis.
FACT_SERVICE_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.