| CHECKPOINT_NUMBER | NUMBER | The sequential number of the checkpoint in which this record was finalized on the Sui blockchain. Checkpoints are consensus milestones that bundle and finalize multiple transactions, providing the primary unit of finality and recovery in Sui. Starts at 0 (genesis checkpoint) and increments by one for each new checkpoint. Used for time series analysis, transaction ordering, and measuring network throughput. Once a transaction is included in a checkpoint, it is permanently recorded and cannot b… |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The network-agreed timestamp (in milliseconds since Unix epoch) when the checkpoint containing this record was finalized by Sui consensus. Represents the authoritative time of transaction finality, as determined by validator signatures. Used for temporal analytics, trend analysis, and aligning on-chain activity with real-world time. Example: ‘2024-06-01 12:34:56.789’. |
| TX_DIGEST | TEXT | A 32-byte cryptographic hash (Base58-encoded) uniquely identifying the transaction’s contents and structure. Serves as the primary key for transaction lookup, integrity verification, and cross-model joins. Enables cryptographic proof of transaction inclusion and supports lineage tracing across all Sui analytics. Example: ‘6Qk8…9Xz’. |
| TX_SENDER | TEXT | The 32-byte Sui address (hex with 0x prefix) that initiated and signed the transaction. Identifies the account responsible for the transaction and gas payment. Used for user activity tracking, wallet analytics, and authorization analysis. Example: ‘0xabc123…’. |
| EVENT_INDEX | NUMBER | Zero-based index ordering events within a transaction. Ensures deterministic event ordering for sequence reconstruction and analytics. Example: 1. |
| BRIDGE_ADDRESS | TEXT | BRIDGE_ADDRESS column |
| PLATFORM | TEXT | PLATFORM column |
| PROTOCOL | TEXT | PROTOCOL column |
| PROTOCOL_VERSION | TEXT | PROTOCOL_VERSION column |
| DIRECTION | TEXT | DIRECTION column |
| SOURCE_CHAIN | TEXT | SOURCE_CHAIN column |
| DESTINATION_CHAIN | TEXT | DESTINATION_CHAIN column |
| SENDER | TEXT | SENDER column |
| RECEIVER | TEXT | RECEIVER column |
| COIN_TYPE | TEXT | COIN_TYPE column |
| SYMBOL | TEXT | SYMBOL column |
| AMOUNT_UNADJ | NUMBER | AMOUNT_UNADJ column |
| AMOUNT | FLOAT | AMOUNT column |
| AMOUNT_USD | FLOAT | AMOUNT_USD column |
| TOKEN_IS_VERIFIED | BOOLEAN | TOKEN_IS_VERIFIED column |
| EZ_BRIDGE_ACTIVITY_ID | TEXT | EZ_BRIDGE_ACTIVITY_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
