Skip to main content
Schema: eclipse.core Table: fact_transactions Type: Base Table A table that contains high level information about every transaction on the Eclipse blockchain.

Columns

Column NameData TypeDescription
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block began.
BLOCK_IDNUMBERSlot for which a block can be created.
TX_IDTEXTA unique key that identifies a transaction
INDEXVARIANTThe order in which the transaction was executed in a given slot
RECENT_BLOCK_HASHTEXTPrevious block’s hash value
SIGNERSARRAYList of accounts that signed the transaction
FEENUMBERTransaction fee (in lamports)
SUCCEEDEDBOOLEANTrue when a transaction is successful, otherwise false.
ACCOUNT_KEYSARRAYList of accounts that are referenced by pre/post sol/token balances objects
PRE_BALANCESARRAYList of pre-transaction balances for different accounts
POST_BALANCESARRAYList of post-transaction balances for different accounts
PRE_TOKEN_BALANCESARRAYList of pre-transaction token balances for different token accounts
POST_TOKEN_BALANCESARRAYList of post-transaction token balances for different token accounts
INSTRUCTIONSARRAYSpecifies which program it is calling, which accounts it wants to read or modify, and additional data that serves as auxiliary input to the program
INNER_INSTRUCTIONSARRAYA call from one smart contract program to another
LOG_MESSAGESARRAYArray of log messages written by the program for this transaction
ADDRESS_TABLE_LOOKUPSARRAYArray of lookup keys used associate additional account keys with the transactions. Valid for version > 0 transactions.
UNITS_CONSUMEDNUMBERThe number of compute units consumed by the program.
UNITS_LIMITNUMBERThe max number of compute units that can be consumed by the program.
TX_SIZENUMBERThe size of the transaction in bytes.
VERSIONTEXTTransaction version, legacy version is listed as NULL or ‘legacy’
FACT_TRANSACTIONS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which this record was last modified by an internal process.