Core
List of core tables for Stacks blockchain
ACCOUNTS
A view of all wallets in Stacks blockchain with total STX balance as of now.
account
text
STX wallet address
total
numeric
Total STX balance
BLOCKS
All successfully mined blocks. Alternative blocks are not included.
block_hash
text
Block hash (as "0x...")
block_id
binary
Block hash in binary form
block_time
timestamp
UTC timestamp
block_height
integer
The height of the block
burn_block_time
integer
epoch
burn_block_hash
binary
miner_txid
binary
BURNCHAIN_REWARDS
Miner rewards table
burn_block_hash
text
Burnchain block hash (as "0x...")
burn_block_height
integer
burn_amount
numeric
reward_recipient
text
reward_amount
numeric
reward_index
integer
LAST_BLOCK
A special table with only one row: latest successful block
block_hash
text
Block hash (as "0x...")
block_id
binary
Block hash in binary form
block_height
integer
The height of the block
burn_block_time
integer
epoch
burn_block_hash
binary
miner_txid
binary
TRANSACTIONS
For types of transactions check stacks documentation.
tx_type
text
token transfer, smart contract, contract call, poison, or coinbase
block_time
timestamp
UTC time of the transaction's block
tx_hash
text
Transaction hash (as "0x...")
tx_id
binary
Transaction hash in binary form
block_hash
text
Corresponding block's hash
block_height
integer
Corresponding block's height
status
integer
1 for success, -1 for failed (aborted), -2 for failed (reverted due to post conditions)
sender_address
text
The address of transaction initiator
token_transfer_recipient_address
text
The transfer recipient (for token transfer tx type)
token_transfer_amount
text
The transfer amount in ustx (for token transfer tx type)
token_transfer_memo
text
Optional memo
contract_call_contract_id
text
The id of the contract (for contract call tx type)
contract_call_function_name
text
The name of the function (for contract call tx type)
smart_contract_contract_id
text
The id of the contract to be deployed (for smart contract tx type)
smart_contract_source_code
text
The source code to be deployed (for smart contract tx type)
microblock_sequence
integer
Corresponding microblock's sequence (2147483647 for coinbase)
tx_index
integer
The index within the corresponding microblock
id
integer
Internal transaction id, convenient for proper ordering.
TXS
Same as transactions with an additional row for the raw hex encoded serialized transaction.
raw_tx
binary
Raw transaction content
SMART_CONTRACTS
All successfully deployed smart contracts.
tx_hash
text
Deployment transaction hash
contract_id
text
Contract readable id
block_height
integer
Deployment block height
source_code
text
The source code of the contract
abi
json
The ABI of the contract
FUNCTION_ARGS
A helper table with parameters passed to the contract's functions
tx_hash
text
Function call transaction hash
name
text
The name of the parameter
type
text
The type of the parameter
repr
text
The string representation of the parameter passed to the function
POST_CONDITIONS
A helper table with post-conditions of contracts' functions. This table contains a row per each post-condition in a transaction.
tx_hash
text
Function call transaction hash
condition_index
integer
TOKEN_PROPERTIES
A helper table with all existing token properties such as symbol and decimals. Could be helpful for joining FT_EVENTS.
contract
text
shorter contract name (like SP1YK770QXSJY7G1SJD664CQKQGWM2N25DBFTMBMB.token-wstx)
contract_id
text
full name (like SP1YK770QXSJY7G1SJD664CQKQGWM2N25DBFTMBMB.token-wstx::wstx)
properties
json
{"name": , "symbol": , "decimals": }
POX
Staking delegation transactions
tx_hash
text
Function call transaction hash
amount
numeric
amount delegated in ustx
address
text
pool address
POX_INFO
Staked amount in POX contract
cycle_id
int
Reward cycle
stacked
numeric
amount stacked in ustx
STXOP.BNS_ADDRESS
address
text
owner's principal
tx_hash
text
registration transaction
bns
text
unqualified name (e.g. muneeb, larry, friedger)
namespace
text
the namespace (e.g. btc, stx, id)
Last updated