Table Columns

Column NameDescription
transaction_hashUnique hash of the transaction that contains this input.
block_hashHash of the block containing this input’s transaction.
block_numberNumber of the block containing this input’s transaction.
block_timestampTimestamp when the block containing this input was mined.
indexThe position of this input within its transaction.
spent_transaction_hashHash of the transaction that created the output being spent by this input.
spent_output_indexThe index of the output being spent within its transaction.
script_asmThe script in assembly format that unlocks the spent output.
script_hexThe script in hexadecimal format that unlocks the spent output.
sequenceThe sequence number of this input, used for relative time-locks.
coinbaseFor coinbase transactions, contains the coinbase data. NULL for non-coinbase inputs.
input_idUnique identifier for this input, composed of transaction_hash and index.
spent_utxo_idUnique identifier for the spent output, composed of spent_transaction_hash and spent_output_index.
_created_atTimestamp when this record was created in the database.
_updated_atTimestamp when this record was last updated in the database.