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

​
What

This fact-based convenience table contains Service staking events, including epoch, owner and multisig addresses, the relevant staking program, and an additional join on the dim_registry_metadata table for 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.
OWNER_ADDRESSTEXTThe address of the owner.
MULTISIG_ADDRESSTEXTThe address of the multi-signature wallet, typically a GnosisSafe.
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.
EPOCHTEXTThe period or unit of time.
REWARD_UNADJTEXTThe value of the reward, non-decimal adjusted.
REWARDFLOATThe value of the reward, decimal adjusted.
TOTAL_AVAILABLE_REWARDS_UNADJTEXTThe total rewards available in the event, non-decimal adjusted.
TOTAL_AVAILABLE_REWARDSFLOATThe total rewards available in the event, decimal adjusted.
NONCESARRAYThe position of the event.
PROGRAM_NAMETEXTThe name of the staking program.
EZ_SERVICE_STAKING_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.