ERC1155 Credit Debit
The ERC1155 credit debit model combines ERC1155 transfers, allowing you to easily track the inflows and outflows of every ERC1155 token belonging to all addresses.
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | Address of the account that was credited or debited amount of ERC1155 token |
| counterparty_address | VARCHAR | The address of counter party of this credit or debit transfer |
| token_address | VARCHAR | Token address of the ERC1155 token |
| token_name | VARCHAR | Name of the ERC1155 token |
| token_symbol | VARCHAR | Token symbol of this token |
| token_id | VARCHAR | Unique ID of the ERC1155 token |
| raw_amount | FLOAT | Balance of tokens (unnormalized). For ERC1155 tokens, there are no decimals division involved |
| raw_amount_str | VARCHAR | Balance of tokens (unnormalized) in string |
| amount | FLOAT | Amount of tokens moved |
| amount_str | VARCHAR | Amount of tokens moved in string |
| transaction_hash | VARCHAR | Transaction hash that this transfer belongs to |
| transaction_index | BIGINT | The position of this transaction in the block. The first transaction has index 0. |
| log_index | BIGINT | The position of this log within the block. The first log has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred |
| block_number | BIGINT | The block number that the corresponding transaction of this transfer belongs to |
| block_hash | VARCHAR | The block hash that the corresponding transaction of this transfer belongs to |
| unique_id | VARCHAR | Unique id generated to each transfer. Includes transaction hash, log index and credit and debit transaction type |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full refresh |