Skip to main content
Schema: aurora.core Table: fact_receipts Type: View This table contains receipt level data for the Aurora Blockchain.

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
BLOCK_HASHTEXTBlock hash is a unique 66-character identifier that is generate when a block is produced.
CUMULATIVE_GAS_USEDNUMBERThe total amount of gas used when this transaction was executed in the block.
Note: this may be null for the transactions that are reverted, as described in the docs landing page.
FROM_ADDRESSTEXTAddress from where the transaction was sent
TO_ADDRESSTEXTTo address is a unique 42-character identifier that is generated when a transaction is produced.
GAS_USEDNUMBERTotal gas used in the block or transaction.
Note: this may be null for the transactions that are reverted, as described in the docs landing page.
LOGSVARIANTEvent data.
LOGS_BLOOMTEXTBloom filter for light clients to quickly retrieve related logs.
STATUSNUMBERStatus of the transaction.
Note: this may be null for the transactions that are reverted, as described in the docs landing page.
TX_SUCCESSBOOLEAN
TX_STATUSTEXTStatus of the transaction.
Note: this may be null for the transactions that are reverted, as described in the docs landing page.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
POSITIONNUMBERThe position of the transaction within the block.
TYPENUMBERType of transaction
NEAR_RECEIPT_HASHTEXTReceipt hash on NEAR blockchain
NEAR_TRANSACTION_HASHTEXTTransaction hash on NEAR blockchain
FACT_RECEIPTS_IDTEXTA uniquely generated identifier assigned by a surrogate key
INSERTED_TIMESTAMPTIMESTAMP_LTZThe timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMPTIMESTAMP_LTZThe timestamp at which this record was last modified by an internal process.