| checkpoint_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of when the Sui checkpoint was created. |
| checkpoint_sequence | NUMBER(38,0) | Monotonically increasing sequence number of the Sui checkpoint. |
| transaction_block_digest | VARCHAR(16777216) | Base58-encoded digest of the Sui transaction block. |
| holder_id | VARCHAR(16777216) | Object that directly holds the balance. |
| root_object_id | VARCHAR(16777216) | Top-level object the holder belongs to (e.g. the pool or BalanceManager owning a dynamic field). Use this to roll balances up to a holder. |
| coin_type | VARCHAR(16777216) | Fully-qualified Move type of the coin whose balance or supply is recorded (e.g. 0x2::sui::SUI). Addresses inside the type are shortened to canonical form with leading zeros stripped, and generic parameters are separated by a comma and space, matching Sui JSON-RPC rendering. |
| raw_balance | NUMBER(38,0) | Total Balance of this coin type held in the object after the transaction, in raw units. 0 when deleted or wrapped; null on rows that only carry a Supply. |
| raw_pre_balance | NUMBER(38,0) | Same as raw_balance, before the transaction. Null when created or unwrapped. |
| raw_supply | NUMBER(38,0) | Supply after the transaction. Null unless the object holds a Supply. |
| raw_pre_supply | NUMBER(38,0) | Supply before the transaction. Null unless the object held a Supply. |
| raw_balance_str | VARCHAR(16777216) | raw_balance as an exact decimal string. |
| raw_pre_balance_str | VARCHAR(16777216) | raw_pre_balance as an exact decimal string. |
| raw_supply_str | VARCHAR(16777216) | raw_supply as an exact decimal string. |
| raw_pre_supply_str | VARCHAR(16777216) | raw_pre_supply as an exact decimal string. |
| state | VARCHAR(16777216) | What the transaction did to the object: created, mutated, deleted, wrapped or unwrapped. |
| object_id | VARCHAR(16777216) | ID of the changed object. |
| object_type | VARCHAR(16777216) | Move type of the changed object. |
| version | NUMBER(38,0) | Object version after the transaction. Null when deleted or wrapped. |
| input_version | NUMBER(38,0) | Object version before the transaction. Null when created or unwrapped. |
| source | VARCHAR(16777216) | Snapshot source. Always object for now. |
| holder_type | VARCHAR(16777216) | Kind of holder. Always object for now. |
| transaction_block_status | VARCHAR(16777216) | Execution result of the transaction block: success or failure. |
| checkpoint_digest | VARCHAR(16777216) | Hash digest of the Sui checkpoint. |
| balance_snapshot_index | NUMBER(38,0) | Zero-based position of the row within its transaction and source. An object that cannot be decoded is skipped but still takes an index slot, so gaps in the sequence mark undecodable objects. |
| owner | VARIANT | Owner of the changed object as JSON: {"AddressOwner": "0x..."}, {"ObjectOwner": "0x..."}, {"Shared": {"initial_shared_version": n}}, {"ConsensusAddressOwner": {"owner": "0x...", "start_version": n}}, or the string "Immutable". For deleted or wrapped objects, this is the owner before the change. |
| unique_id | VARCHAR(16777216) | transaction_block_digest, source, holder_id and coin_type joined into one key. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
