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 |