Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Credit Debit Model
The credit debit model combines Hedera transfers, allowing you to easily track the inflows and outflows of every Hedera token belonging to all addresses. This model provides a comprehensive view of token movements, including both credits (positive amounts) and debits (negative amounts).Schema Details
| Column Name | Type | Description |
|---|---|---|
| account | VARCHAR | The address of the account |
| token_id | VARCHAR | The id of the token |
| raw_amount_str | VARCHAR | The amount of the token in the raw format. This is negative for debits and positive for credits |
| raw_amount | FLOAT | The amount of the token in the raw format. This is negative for debits and positive for credits |
| amount_str | VARCHAR | The amount of the token in the normalized format. This is negative for debits and positive for credits |
| amount | FLOAT | The amount of the token in the normalized format. This is negative for debits and positive for credits |
| usd_amount | FLOAT | The amount of the token in the normalized format, in $USD |
| is_approval | BOOLEAN | Whether the transaction is an approval |
| payer_account_id | VARCHAR | The id of the payer account |
| entity_id | VARCHAR | The id of the entity |
| nonce | BIGINT | The nonce of the transaction |
| result | VARCHAR | The result of the transaction |
| block_hash | VARCHAR | The hash of the block |
| block_number | BIGINT | The number of the block |
| block_timestamp | TIMESTAMP | The timestamp of the block |
| consensus_timestamp | TIMESTAMP | The consensus timestamp of the transaction |
| transaction_type | VARCHAR | The type of the transaction |
| transaction_hash | VARCHAR | The hash of the transaction |
| transaction_id | VARCHAR | The id of the transaction |
| transfers_index | BIGINT | The index of the transfer |
| unique_id | VARCHAR | The unique id of the transaction |