Skip to main content
Schema: ton.core Table: fact_account_states Type: Base Table

What

Contains information about TON account states, tracking changes in account balances, statuses, and transaction histories. Based on the account_states table from TON-ETL.

Columns

Column NameData TypeDescription
BLOCK_TIMESTAMPTIMESTAMP_NTZBLOCK_TIMESTAMP column
ACCOUNTTEXTACCOUNT column
TIMESTAMPNUMBERTIMESTAMP column
LAST_TRANS_LTNUMBERLAST_TRANS_LT column
LAST_TX_HASHTEXTLAST_TX_HASH column
ACCOUNT_STATUSTEXTACCOUNT_STATUS column
BALANCENUMBERBALANCE column
FROZEN_HASHTEXTFROZEN_HASH column
ACCOUNT_STATE_HASHTEXTACCOUNT_STATE_HASH column
FACT_ACCOUNT_STATES_IDTEXTFACT_ACCOUNT_STATES_ID column
INSERTED_TIMESTAMPTIMESTAMP_NTZINSERTED_TIMESTAMP column
MODIFIED_TIMESTAMPTIMESTAMP_NTZMODIFIED_TIMESTAMP column
CODE_BOCBINARYThe code boc
CODE_HASHTEXTThe code hash
DATA_BOCBINARYThe data bloc”
DATA_HASHTEXTThe data hash