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

​
What

This fact-based convenience table contains decoded service Checkpoint events from various applicable staking contracts and programs, and includes a join on the dim_registry_metadata table for additional details pertaining to each service_id, such as name and description.

​
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.
EVENT_NAMETEXTThe name of the event.
SERVICE_IDNUMBERThe unique identifier of the registered Service.
NAMETEXTThe registered name of the Unit (Agent, Component) or Service.
DESCRIPTIONTEXTThe registered description of the Unit (Agent, Component) or Service.
REWARD_UNADJNUMBERThe value of the reward, non-decimal adjusted.
REWARDFLOATThe value of the reward, decimal adjusted.
EPOCHNUMBERThe period or unit of time.
EPOCH_LENGTHNUMBERThe length of the period or unit of time.
TOTAL_AVAILABLE_REWARDS_UNADJNUMBERThe total rewards available in the event, non-decimal adjusted.
TOTAL_AVAILABLE_REWARDSFLOATThe total rewards available in the event, decimal adjusted.
PROGRAM_NAMETEXTThe name of the staking program.
EZ_SERVICE_CHECKPOINTS_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.