Skip to main content

Table Details

PropertyValue
Table Namemonad_testnet.assets.erc721_credit_debit
Table StatusProduction-Ready
Unique Keytransaction_hash, log_index

Table Columns

Column NameData TypeDescription
addressVARCHAR(42)Address of the account that was credited or debited amount of ERC721 token
counterparty_addressVARCHAR(42)The address of counter party of this credit or debit transfer
token_addressVARCHAR(42)Token address of the ERC721 token
token_nameVARCHAR(16777216)Name of the ERC721 token
token_symbolVARCHAR(16777216)Token symbol of this token
token_idVARCHAR(16777216)Unique ID of the ERC721 token
raw_amount_strVARCHAR(16777216)Balance of tokens (unnormalized) in string
raw_amountFLOATBalance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved.
amount_strVARCHAR(16777216)Amount of tokens moved in string
amountFLOATAmount of tokens moved
usd_amountVARCHAR(16777216)The amount of tokens moved, in USD.
usd_exchange_rateVARCHAR(16777216)Exchange rate used to calculate the USD amount.
transaction_from_addressVARCHAR(42)The address of the sending party of this transaction.
transaction_to_addressVARCHAR(42)The address of the receiving party of this transaction.
transaction_hashVARCHAR(66)Transaction hash that this transfer belongs to
transaction_indexNUMBER(38,0)The position of this transaction in the block. The first transaction has index 0
log_indexNUMBER(38,0)The position of this log within the block. The first log has index 0
block_timestampTIMESTAMP_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_numberNUMBER(38,0)The block number that the corresponding transaction of this transfer belongs to
block_hashVARCHAR(66)The block hash that the corresponding transaction of this transfer belongs to
unique_idVARCHAR(16777216)Unique id generated to each transfer. Includes transaction hash, log index and credit and debit transaction type
_tokens_updated_atTIMESTAMP_NTZ(9)Timestamp of when the token metadata was last updated.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full data refresh.