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

What

This convenience table contains fact-based records of unit registrations (Agents and Components) within the OLAS protocol, capturing essential information about each registered unit event and includes a join on the dim_registry_metadata table for additional details pertaining to each unit_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.
UNIT_IDNUMBERThe unique identifier of the registered Unit.
U_TYPENUMBERThe type of unit, in fixed number format.
UNIT_TYPETEXTThe type of unit, in human-readable format.
UNIT_HASHTEXTThe hash of the unit.
NAMETEXTThe registered name of the Unit (Agent, Component) or Service.
DESCRIPTIONTEXTThe registered description of the Unit (Agent, Component) or Service.
SUBCOMPONENT_IDSARRAYThe unique identifier of the sub-components that make up the Agent or Component.
TRAIT_TYPETEXTThe trait type for the registered Unit (Agent, Component) or Service.
TRAIT_VALUETEXTThe trait value for the registered Unit (Agent, Component) or Service.
IMAGE_LINKTEXTThe link to the image of the registered Unit (Agent, Component) or Service.
UNIT_METADATA_LINKTEXTThe link to the metadata for the registered Unit (Agent, Component).
EZ_UNIT_REGISTRATIONS_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.