Credit Debit

The credit-debit model provides a double-entry accounting system for tracking asset movements on the blockchain. This model is particularly useful for analyzing token flows, calculating balances, and understanding asset distribution patterns.

Table Details

Property	Value
Table Name	`worldchain.assets.credit_debit`
Table Status	Production-Ready
Unique Key	`transaction_hash`, `unique_id`

Overview

Advantages Over Transfer Tables

Balance Calculation
- Easy summation of all credits and debits for an address
- Simplified queries for net position calculations
- Natural handling of complex transactions
Flow Analysis
- Clear visualization of token inflows and outflows
- Simple aggregation of total volume by address
- Easy identification of major senders/receivers
Data Consistency
- Built-in verification through balanced entries
- Self-auditing through equal total credits and debits
- Simplified reconciliation process

Table Columns

Column Name	Data Type	Description
address	VARCHAR(42)	The wallet address holding the tokens
counterparty_address	VARCHAR(42)	Counterparty address of this credit debit row
token_address	VARCHAR(42)	Contract address of the token
token_name	VARCHAR(16777216)	Name of the token
token_symbol	VARCHAR(16777216)	Symbol of the token
token_id	VARCHAR(16777216)	Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Null for fungible tokens. Each unique token_id within a collection represents a distinct asset.
raw_amount	FLOAT	Amount of tokens moved (unnormalized)
raw_amount_str	VARCHAR(16777216)	Amount of tokens moved (unnormalized) in string
amount	FLOAT	Amount of tokens moved, normalized by the decimal points defined in the token contract
amount_str	VARCHAR(16777216)	Amount of tokens moved, normalized in string
usd_amount	FLOAT	The amount of tokens moved, in $USD
usd_exchange_rate	FLOAT	Exchange rate used for USD conversion
transaction_from_address	VARCHAR(42)	The address that initiated the transaction
transaction_to_address	VARCHAR(42)	The address that received the transaction
transaction_hash	VARCHAR(66)	Transaction hash that this transfer belongs to
transaction_index	NUMBER(38,0)	The position of this transaction in the block. The first transaction has index 0
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block
block_number	NUMBER(38,0)	Number of the block
block_hash	VARCHAR(66)	Hash of the block
token_type	VARCHAR(16777216)	Identifies whether the balance record is for a `native` or `erc20` token
unique_id	VARCHAR(16777216)	Unique identifier combining block, address, token address
_tokens_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the token metadata was last updated.
_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.
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full data refresh.

EVM Assets Credit Debit

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Overview

Advantages Over Transfer Tables

Table Columns

​Table Details

​Overview

​Advantages Over Transfer Tables

​Table Columns

​Related Docs

Table Details

Overview

Advantages Over Transfer Tables

Table Columns

Related Docs