Skip to main content
Schema: crosschain.unifai Table: fact_purchases Type: Base Table

What

This table contains fact-based records of purchase transactions within the UnifAI protocol. It captures essential information about each purchase event, including transaction details and user information.

Columns

Column NameData TypeDescription
CREATED_AT_TIMESTAMPTIMESTAMP_NTZThe timestamp when the transaction was created.
TX_HASHTEXTThe unique transaction hash that identifies the transaction on the blockchain.
CHAINTEXTThe blockchain network on which the transaction occurred.
STATUSTEXTThe status of the transaction, indicating whether it was successful, pending, or failed.
FROM_ADDRESSTEXTThe blockchain address from which the transaction was initiated.
TO_ADDRESSTEXTThe blockchain address to which the transaction was directed.
TOKEN_AMOUNTFLOATThe amount of tokens involved in the transaction.
TOKEN_SYMBOLTEXTThe symbol of the token involved in the transaction.
TOKEN_VALUEFLOATThe value of the tokens involved in the transaction, typically denominated in a stable currency or fiat equivalent.
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.
FACT_PURCHASES_IDTEXTThe unique identifier for each row in the table.