eclipse.core Table: fact_blocks Type: Base Table
Contains general information about each block produced on Eclipse.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | Slot for which a block can be created. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| NETWORK | TEXT | Eclipse network name |
| CHAIN_ID | TEXT | chain identifier, this will always be eclipse. Field is used in joins with crosschain tables |
| BLOCK_HEIGHT | VARIANT | Height of the block |
| BLOCK_HASH | TEXT | Hash of the block |
| PREVIOUS_BLOCK_ID | VARIANT | previous slot value |
| PREVIOUS_BLOCK_HASH | TEXT | Previous block’s hash value |
| FACT_BLOCKS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |