| SLOT_NUMBER | NUMBER | The slot number that the deposit was made in. |
| 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 |
| EVENT_INDEX | NUMBER | The index of the deposit event within the transaction. |
| DEPOSIT_AMOUNT | FLOAT | Decimal adjusted Ether deposit amount. |
| DEPOSITOR | TEXT | The address of the depositor. |
| DEPOSIT_ADDRESS | TEXT | The address where the deposit was sent to. |
| PLATFORM_ADDRESS | TEXT | The address of the platform associated with the deposit to the Beacon Chain. |
| PLATFORM | TEXT | The name or identifier of the platform. |
| PLATFORM_CATEGORY | TEXT | The type or category of the platform. |
| PLATFORM_ADDRESS_TYPE | TEXT | PLATFORM_ADDRESS_TYPE column |
| CONTRACT_ADDRESS | TEXT | The Beacon Chain Deposit contract address: 0x00000000219ab540356cBB839Cbe05303d7705Fa. |
| PUBKEY | TEXT | The public key associated with the Validator. |
| WITHDRAWAL_CREDENTIALS | TEXT | A 32-byte field verifying the destination of valid withdrawals. |
| WITHDRAWAL_TYPE | TEXT | The type or category of the withdrawal, derived from the Withdrawal Credentials. |
| WITHDRAWAL_ADDRESS | TEXT | The address where the withdrawal can be made, derived from the Withdrawal Credentials. |
| SIGNATURE | TEXT | The signature associated with the Validator deposit. |
| DEPOSIT_INDEX | NUMBER | The index of the deposit. |
| PROCESSED_SLOT | NUMBER | The slot number that the deposit was processed in. |
| PROCESSED | BOOLEAN | Whether the deposit has been processed. |
| EZ_DEPOSITS_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: |
