ton.core Table: fact_blocks Type: Base Table
What
Contains information about blocks in the TON blockchain (masterchain and workchains). Represents the blockchain structure.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | BLOCK_TIMESTAMP column |
| GEN_UTIME | NUMBER | GEN_UTIME column |
| WORKCHAIN | NUMBER | WORKCHAIN column |
| VERSION | NUMBER | VERSION column |
| SHARD | NUMBER | SHARD column |
| SEQNO | NUMBER | SEQNO column |
| VERT_SEQNO | NUMBER | VERT_SEQNO column |
| START_LT | NUMBER | START_LT column |
| END_LT | NUMBER | END_LT column |
| MC_BLOCK_SEQNO | NUMBER | MC_BLOCK_SEQNO column |
| MC_BLOCK_SHARD | NUMBER | MC_BLOCK_SHARD column |
| TX_COUNT | NUMBER | TX_COUNT column |
| GLOBAL_ID | NUMBER | GLOBAL_ID column |
| CREATED_BY | TEXT | CREATED_BY column |
| WANT_MERGE | BOOLEAN | WANT_MERGE column |
| ROOT_HASH | TEXT | ROOT_HASH column |
| KEY_BLOCK | BOOLEAN | KEY_BLOCK column |
| VERT_SEQNO_INCR | BOOLEAN | VERT_SEQNO_INCR column |
| VALIDATOR_LIST_HASH_SHORT | NUMBER | VALIDATOR_LIST_HASH_SHORT column |
| AFTER_MERGE | BOOLEAN | AFTER_MERGE column |
| WANT_SPLIT | BOOLEAN | WANT_SPLIT column |
| AFTER_SPLIT | BOOLEAN | AFTER_SPLIT column |
| MASTER_REF_SEQNO | NUMBER | MASTER_REF_SEQNO column |
| MC_BLOCK_WORKCHAIN | NUMBER | MC_BLOCK_WORKCHAIN column |
| FILE_HASH | TEXT | FILE_HASH column |
| PREV_KEY_BLOCK_SEQNO | NUMBER | PREV_KEY_BLOCK_SEQNO column |
| FLAGS | NUMBER | FLAGS column |
| RAND_SEED | TEXT | RAND_SEED column |
| GEN_CATCHAIN_SEQNO | NUMBER | GEN_CATCHAIN_SEQNO column |
| MIN_REF_MC_SEQNO | NUMBER | MIN_REF_MC_SEQNO column |
| BEFORE_SPLIT | BOOLEAN | BEFORE_SPLIT column |
| FACT_BLOCKS_ID | TEXT | FACT_BLOCKS_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |