| BLOCK_NUMBER | NUMBER | Sequential counter representing the position of a block in the blockchain since genesis (block 0). Key Facts: Immutable once finalized Primary ordering mechanism for blockchain data Increments by 1 for each new block Used as a proxy for time in many analyses Usage in Queries: Important: Block numbers are chain-specific. Block 15000000 on Ethereum ≠ block 15000000 on Polygon. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the block was produced by validators/miners. Format: TIMESTAMP_NTZ (no timezone) Precision: Second-level accuracy Reliability: Set by block producer Can have minor variations (±15 seconds) Always increasing (newer blocks = later timestamps) Best Practices: Note: Use for time-series analysis, but be aware that block production rates vary by chain. |
| TX_HASH | TEXT | Unique 66-character identifier for the transaction. Format: 0x + 64 hexadecimal characters Usage: Primary key for transaction lookups Join key for traces, logs, and token transfers Immutable once confirmed Example: 0x5c504ed432cb51138bcf09aa5e8a410dd4a1e204ef84bfed1be16dfba1b22060 |
| STATUS | TEXT | The status of the tx, can be “Success” or “Failed” |
| EVENT_NAME | TEXT | EVENT_NAME column |
| DELEGATOR | TEXT | The address of the delegator |
| DELEGATE | TEXT | The address of the delegate |
| DELEGATION_TYPE | TEXT | The type of delegation, can be “First Time Delegator”, “Self Delegation”, “Re-Delegation” or “First Time Delegator - Self Delegation” |
| NEW_BALANCE | FLOAT | The new amount the user has delegated after the transaction |
| PREVIOUS_BALANCE | FLOAT | The amount of OP the user had delegated before the transaction |
| RAW_NEW_BALANCE | NUMBER | The new amount the user has delegated after the transaction in raw format |
| RAW_PREVIOUS_BALANCE | NUMBER | The amount of OP the user had delegated before the transaction in raw format |
| TO_DELEGATE | TEXT | The address of the delegate to which the delegator has delegated their votes |
| FROM_DELEGATE | TEXT | The address of the delegate from which the delegator has delegated their votes |
| FACT_DELEGATIONS_ID | TEXT | Primary key - unique identifier for each row ensuring data integrity. Format: Usually VARCHAR containing composite key generated using MD5 hash of the relevant columns. Example: MD5(blocknumber, txhash, trace_index) Usage: Deduplication in incremental loads Join operations for data quality checks Troubleshooting specific records Important: Implementation varies by table - check table-specific documentation. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flipside database. Format: TIMESTAMP_NTZ Use Cases: Data freshness monitoring Incremental processing markers Debugging data pipeline issues SLA tracking Query Example: |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. Format: TIMESTAMP_NTZ Triggers for Updates: Data corrections Enrichment additions Reprocessing for accuracy Schema migrations Monitoring Usage: |
