thorchain.core Table: dim_block Type: Base Table
Records of all blocks that have occurred on Thorchain, dating back to the genesis block.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| DIM_BLOCK_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| BLOCK_ID | NUMBER | ID of the confirmed block |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of block minting(without a timezone) |
| BLOCK_DATE | DATE | Date of block minting(without a timezone) |
| BLOCK_HOUR | NUMBER | Date of block minting(without a timezone) |
| BLOCK_WEEK | NUMBER | Date of block minting(without a timezone) |
| BLOCK_MONTH | NUMBER | The numeric month of block minting(without a timezone) |
| BLOCK_QUARTER | NUMBER | The numeric quarter of block minting(without a timezone) |
| BLOCK_YEAR | NUMBER | The numeric year of block minting(without a timezone) |
| BLOCK_DAYOFMONTH | NUMBER | The numeric day of month of block minting(without a timezone) |
| BLOCK_DAYOFWEEK | NUMBER | The numeric day of week of block minting(without a timezone) |
| BLOCK_DAYOFYEAR | NUMBER | The numeric day of year of block minting(without a timezone) |
| TIMESTAMP | NUMBER | integer value of the block_teimstamp |
| HASH | BINARY | block hash |
| AGG_STATE | BINARY | |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| _AUDIT_RUN_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |