Schema ETHEREUM

BLOCKS

Contains information for block data, one record per block.

Column	Data Type	Description
BLOCK_HASH	VARCHAR	Hashed value of the current block payload with previous block_hash, to guarantee immutability.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
BASE_FEE_PER_GAS	VARCHAR	Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size.
REWARD	VARCHAR	Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block.
GAS_LIMIT	INTEGER	The maximum amount of work you're estimating a validator will do on a particular transaction.
PARENT_HASH	VARCHAR	Hashed value for parent node of the Merkle tree in the block.
GAS_USED	INTEGER	Amount of gas used in the mining of the block.
SIZE_	INTEGER	Size of block data in bytes.
MINER	VARCHAR	Address of the miner.
TRANSACTION_COUNT	INTEGER	Number of transactions present in the block.
TIME_STAMP	TIMESTAMP	Timestamp of the block creation.

BLOCK_DETAIL

Contains additional information for the block data, one record per block. FK block_number to blocks table.

Column	Data Type	Description
SHA3_UNCLES	VARCHAR	Hashed value of all the uncle blocks for a block.
RECEIPTS_ROOT	BIGINT	Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts.
NONCE	VARCHAR	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
STATE_ROOT	VARCHAR	It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
VERSION	VARCHAR	Internal purpose.
UNCLES_COUNT	INTEGER	Number of uncles block generated with the block.
TRANSACTIONS_ROOT	VARCHAR	Root hash of the transactions sequence in blocks.
LOGS_BLOOM	VARCHAR	Data structure containing event logs.

APPROVALFORALL

Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.

Column	Data Type	Description
ACCOUNT	VARCHAR	Hashed value of all the uncle blocks for a block.
CONTRACT_ADDRESS	VARCHAR	Address of the contract which emits this event.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	BOOLEAN	Contains information if changes in NFT are approved or not.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.

CONTRACT

Contains information regarding the contracts involved in transactions in a block.

Column	Data Type	Description
TIME_STAMP	TIMESTAMP	Timestamp of contract deployment/creation
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
ADDRESS	VARCHAR	Deployment address of the contract, unique identifier for a contract.
PROXY_CONTRACT_IMPL_ADDRESS	VARCHAR	Contains address of the proxy implementations of the contract.
CONTRACT_CREATOR_ADDRESS	VARCHAR	Address of an owner/deployer of the contract.

ERC1155_TRANSFER

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
VALUE_	VARCHAR	Value of ERC1155 token which is transferred.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
ID	VARCHAR	Token identifier (ID) similar to NFT.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or SFT which is involved in transfers.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

ERC1155_TRANSFERBATCH

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUES_	VARCHAR	Total value of the ERC1155 in the batch.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or SFT which is involved in transfers.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
IDs	VARCHAR	Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch.

ERC20_APPROVAL

Contains information regarding the approval status for the transfers of ERC20 or fungible tokens (FT).

Column	Data Type	Description
OWNER	VARCHAR	Address of the wallet of the owner of FT.
SPENDER	VARCHAR	Address of the wallet of FT buyer (spender).
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 20 contract or FT which is involved in transfers.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.

ERC20_TRANSFER

Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Address of the ERC20 contract which is involved in transfers.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.

ERC721_APPROVAL

Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
OWNER	VARCHAR	Address of the owner's wallet for the NFT.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	VARCHAR	If the NFT transfer is approved or not.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

ERC721_TRANSFER

Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.

FUNGIBLETOKEN_WALLET

Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.

Column	Data Type	Description
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BALANCE	VARCHAR	Current NFT balance of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TOKEN_ADDRESS	VARCHAR	Address of the ERC721 token.

LOGS

Contains information regarding the transaction logs generated in transactions of a block.

Column	Data Type	Description
DATA_	VARCHAR	Data emitted by the transaction log.
NAME	VARCHAR	Name of the event emitted.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
TOPIC_1	VARCHAR	Topic 1 (topic index 1) of the event.
ANONYMOUS	BOOLEAN	Contains a check for anonymous events.
ADDRESS	VARCHAR	Address of the log emitter.
STATUS	INTEGER	This represents whether the log is decoded or not. Added the sets of values the status column can have. Status value: 0 = decoded 1 = contract not verified 9 = ABI not found or the event does not exist in ABI.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TOPIC_2	VARCHAR	Topic 2 (topic index 2) of the event.
TOPIC_3	VARCHAR	Topic 3 (topic index 3) of the event.
TOPIC_0	VARCHAR	Topic 0 (topic index 0) of the event.

NATIVE_WALLET

Contains information regarding the native or Ethereum wallets that can store ethers.

Column	Data Type	Description
BALANCE	VARCHAR	Ether balance of the native wallet.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

NATIVETOKEN_TRANSFER

Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.

Column	Data Type	Description
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of amount of tokens involved in transfers.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.

NFT

Contains information regarding ERC 721 tokens/NFTs encountered in transactions.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	ERC 721 address or contract address for the token.
TOKEN_URI	VARCHAR	URI of the NFT token.
TOKEN_ID	VARCHAR	Token ID of the NFT.
TIME_STAMP	TIMESTAMP	Timestamp of the NFT creation.

NFT_COLLECTION

Contains information regarding ERC 721 tokens/NFTs collections, NFT collections are set of NFTs designed/created by an common owner.

Column	Data Type	Description
NAME	VARCHAR	Name of NFT collection
TOKEN_STANDARD	VARCHAR	Standard protocol for a collection.
ADDRESS	VARCHAR	Address of the NFT collection.
SYMBOL	VARCHAR	Unique symbol for the collection.

OWNERSHIPTRANSFERRED

Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Contract address of the token involved in transfer.
PREVIOUSOWNER	VARCHAR	Previous owner (wallet) address.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
NEWOWNER	VARCHAR	New owner (wallet) address.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

TOKEN

Contains information regarding tokens involved in transactions of the blocks.

Column	Data Type	Description
DECIMALS	VARCHAR	Decimal place value for the token.
SYMBOL	VARCHAR	Symbol of the token.
NAME	VARCHAR	Name of the token.
ADDRESS	VARCHAR	Contract address of the token.

TRANSACTION_DETAIL

Contains detailed information of transactions in the blocks.

Column	Data Type	Description
TYPE	VARCHAR	Type of the transaction.
MAX_FEE_PER_GAS	VARCHAR	Max gas fee to be paid in transaction execution.
GAS_PRICE	VARCHAR	Gas price on which transaction used gas.
TRANSACTION_INDEX	INTEGER	Index of the transaction.
MAX_PRIORITY_FEE_PER_GAS	VARCHAR	The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block.
RECEPIENT_CONTRACT_ADDRESS	VARCHAR	Contract address interacted with in the transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
METHOD_ID	VARCHAR	Method ID of the function involved in execution of transaction.
RECEIPT_EFFECTIVE_GAS_PRICE	VARCHAR	Gas price in effect on the transaction.
NONCE	INTEGER	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
CHAIN_ID	VARCHAR	Chain ID of the blockchain.
FUNCTION_NAME	VARCHAR	Function involved in execution of transaction.
LOGS_COUNT	SMALLINT	Number of logs in transaction.
RECEIPT_GAS_USED	INTEGER	Amount of gas used for execution of transaction.

TRANSACTIONS

Contains information about the transactions executed in the block.

Column	Data Type	Description
BLOCK_NUMBER	BIGINT	Integer value of the block number.
RECEIPT_STATUS	INTEGER	Receipt/Transaction status.
TRANSACTION_FEE	VARCHAR	Fee required to execute transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transaction creation.
TO_ADDRESS	VARCHAR	Address of the receiver of the transaction value.
RECEIPT_CUMULATIVE_GAS_USED	INTEGER	Total gas used in execution of transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of the amount involved in transaction.
FROM_ADDRESS	VARCHAR	Address of the source wallet from which value is deducted.
GAS	VARCHAR	Gas used in transaction.

Schema BINANCE (BNB)

BLOCKS

Contains information for block data, one record per block.

Column	Data Type	Description
BLOCK_HASH	VARCHAR	Hashed value of the current block payload with previous block_hash, to guarantee immutability.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
BASE_FEE_PER_GAS	VARCHAR	Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size.
REWARD	VARCHAR	Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block.
GAS_LIMIT	INTEGER	The maximum amount of work you're estimating a validator will do on a particular transaction.
PARENT_HASH	VARCHAR	Hashed value for parent node of the Merkle tree in the block.
GAS_USED	INTEGER	Amount of gas used in the mining of the block.
SIZE_	INTEGER	Size of block data in bytes.
MINER	VARCHAR	Address of the miner.
TRANSACTION_COUNT	INTEGER	Number of transactions present in the block.
TIME_STAMP	TIMESTAMP	Timestamp of the block creation.

BLOCK_DETAIL

Contains additional information for the block data, one record per block. FK block_number to blocks table.

Column	Data Type	Description
SHA3_UNCLES	VARCHAR	Hashed value of all the uncle blocks for a block.
RECEIPTS_ROOT	BIGINT	Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts.
NONCE	VARCHAR	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
STATE_ROOT	VARCHAR	It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
VERSION	VARCHAR	Internal purpose.
UNCLES_COUNT	INTEGER	Number of uncles block generated with the block.
TRANSACTIONS_ROOT	VARCHAR	Root hash of the transactions sequence in blocks.
LOGS_BLOOM	VARCHAR	Data structure containing event logs.

APPROVALFORALL

Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.

Column	Data Type	Description
ACCOUNT	VARCHAR	Hashed value of all the uncle blocks for a block.
CONTRACT_ADDRESS	VARCHAR	Address of the contract which emits this event.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	BOOLEAN	Contains information if changes in NFT are approved or not.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.

CONTRACT

Contains information regarding the contracts involved in transactions in a block.

Column	Data Type	Description
TIME_STAMP	TIMESTAMP	Timestamp of contract deployment/creation
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
ADDRESS	VARCHAR	Deployment address of the contract, unique identifier for a contract.
PROXY_CONTRACT_IMPL_ADDRESS	VARCHAR	Contains address of the proxy implementations of the contract.
CONTRACT_CREATOR_ADDRESS	VARCHAR	Address of an owner/deployer of the contract.

ERC1155_TRANSFER

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
VALUE_	VARCHAR	Value of ERC1155 token which is transferred.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
ID	VARCHAR	Token identifier (ID) similar to NFT.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or NFT which is involved in transfers.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

ERC1155_TRANSFERBATCH

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUES_	VARCHAR	Total value of the ERC1155 in the batch.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or SFT which is involved in transfers.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
IDs	VARCHAR	Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch.

ERC20_APPROVAL

Contains information regarding the approval status for the transfers of ERC20 or fungible tokens (FT).

Column	Data Type	Description
OWNER	VARCHAR	Address of the wallet of the owner of FT.
SPENDER	VARCHAR	Address of the wallet of FT buyer (spender).
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 20 contract or FT which is involved in transfers.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.

ERC20_TRANSFER

Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Address of the ERC20 contract which is involved in transfers.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.

ERC721_APPROVAL

Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
OWNER	VARCHAR	Address of the owner's wallet for the NFT.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	VARCHAR	If the NFT transfer is approved or not.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

ERC721_TRANSFER

Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.

FUNGIBLETOKEN_WALLET

Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.

Column	Data Type	Description
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BALANCE	VARCHAR	Current NFT balance of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TOKEN_ADDRESS	VARCHAR	Address of the ERC721 token.

LOGS

Contains information regarding the transaction logs generated in transactions of a block.

Column	Data Type	Description
DATA_	VARCHAR	Data emitted by the transaction log.
NAME	VARCHAR	Name of the event emitted.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
TOPIC_1	VARCHAR	Topic 1 (topic index 1) of the event.
ANONYMOUS	BOOLEAN	Contains a check for anonymous events.
ADDRESS	VARCHAR	Address of the log emitter.
STATUS	INTEGER	this represents whether the log is decoded or not. Added the sets of values the status column can have. Status value: 0 = decoded 1 = contract not verified 9 = ABI not found or event does not exist in ABI.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TOPIC_2	VARCHAR	Topic 2 (topic index 2) of the event.
TOPIC_3	VARCHAR	Topic 3 (topic index 3) of the event.
TOPIC_0	VARCHAR	Topic 0 (topic index 0) of the event.

NATIVE_WALLET

Contains information regarding the native or Ethereum wallets that can store ethers.

Column	Data Type	Description
BALANCE	VARCHAR	Ether balance of the native wallet.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

NATIVETOKEN_TRANSFER

Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.

Column	Data Type	Description
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of amount of tokens involved in transfers.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.

NFT

Contains information regarding ERC 721 tokens/NFTs encountered in transactions.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	ERC 721 address or contract address for the token.
TOKEN_URI	VARCHAR	URI of the NFT token.
TOKEN_ID	VARCHAR	Token ID of the NFT.
TIME_STAMP	TIMESTAMP	Timestamp of the NFT creation.

NFT_COLLECTION

Contains information regarding ERC 721 tokens/NFTs collections, NFT collections are set of NFTs designed/created by an common owner.

Column	Data Type	Description
NAME	VARCHAR	Name of NFT collection
TOKEN_STANDARD	VARCHAR	Standard protocol for the collection.
ADDRESS	VARCHAR	Address of the NFT collection.
SYMBOL	VARCHAR	Unique symbol for the collection.

OWNERSHIPTRANSFERRED

Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Contract address of the token involved in transfer.
PREVIOUSOWNER	VARCHAR	Previous owner (wallet) address.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
NEWOWNER	VARCHAR	New owner (wallet) address.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

TOKEN

Contains information regarding tokens involved in transactions of the blocks.

Column	Data Type	Description
DECIMALS	VARCHAR	Decimal place value for the token.
SYMBOL	VARCHAR	Symbol of the token.
NAME	VARCHAR	Name of the token.
ADDRESS	VARCHAR	Contract address of the token.

TRANSACTION_DETAIL

Contains detailed information of transactions in the blocks.

Column	Data Type	Description
TYPE	VARCHAR	Type of the transaction.
MAX_FEE_PER_GAS	VARCHAR	Max gas fee to be paid in transaction execution.
GAS_PRICE	VARCHAR	Gas price on which transaction used gas.
TRANSACTION_INDEX	INTEGER	Index of the transaction.
MAX_PRIORITY_FEE_PER_GAS	VARCHAR	The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block.
RECEPIENT_CONTRACT_ADDRESS	VARCHAR	Contract address interacted with in the transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
METHOD_ID	VARCHAR	Method ID of the function involved in execution of transaction.
RECEIPT_EFFECTIVE_GAS_PRICE	VARCHAR	Gas price in effect on the transaction.
NONCE	INTEGER	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
CHAIN_ID	VARCHAR	Chain ID of the blockchain.
FUNCTION_NAME	VARCHAR	Function involved in execution of transaction.
LOGS_COUNT	SMALLINT	Number of logs in transaction.
RECEIPT_GAS_USED	INTEGER	Amount of gas used for execution of transaction.

TRANSACTIONS

Contains information about the transactions executed in the block.

Column	Data Type	Description
BLOCK_NUMBER	BIGINT	Integer value of the block number.
RECEIPT_STATUS	INTEGER	Receipt/Transaction status.
TRANSACTION_FEE	VARCHAR	Fee required to execute transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transaction creation.
TO_ADDRESS	VARCHAR	Address of the receiver of the transaction value.
RECEIPT_CUMULATIVE_GAS_USED	INTEGER	Total gas used in execution of transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of the amount involved in transaction.
FROM_ADDRESS	VARCHAR	Address of the source wallet from which value is deducted.
GAS	VARCHAR	Gas used in transaction.

Schema POLYGON

BLOCKS

Contains information for block data, one record per block.

Column	Data Type	Description
BLOCK_HASH	VARCHAR	Hashed value of the current block payload with previous block_hash, to guarantee immutability.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
BASE_FEE_PER_GAS	VARCHAR	Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size.
REWARD	VARCHAR	Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block.
GAS_LIMIT	INTEGER	The maximum amount of work you're estimating a validator will do on a particular transaction.
PARENT_HASH	VARCHAR	Hashed value for parent node of the Merkle tree in the block.
GAS_USED	INTEGER	Amount of gas used in the mining of the block.
SIZE_	INTEGER	Size of block data in bytes.
MINER	VARCHAR	Address of the miner.
TRANSACTION_COUNT	INTEGER	Number of transactions present in the block.
TIME_STAMP	TIMESTAMP	Timestamp of the block creation.

BLOCK_DETAIL

Contains additional information for the block data, one record per block. FK block_number to blocks table.

Column	Data Type	Description
SHA3_UNCLES	VARCHAR	Hashed value of all the uncle blocks for a block.
RECEIPTS_ROOT	BIGINT	Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts.
NONCE	VARCHAR	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
STATE_ROOT	VARCHAR	It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
VERSION	VARCHAR	Internal purpose.
UNCLES_COUNT	INTEGER	Number of uncles block generated with the block.
TRANSACTIONS_ROOT	VARCHAR	Root hash of the transactions sequence in blocks.
LOGS_BLOOM	VARCHAR	Data structure containing event logs.

APPROVALFORALL

Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.

Column	Data Type	Description
ACCOUNT	VARCHAR	Hashed value of all the uncle blocks for a block.
CONTRACT_ADDRESS	VARCHAR	Address of the contract which emits this event.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	BOOLEAN	Contains information if changes in NFT are approved or not.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.

CONTRACT

Contains information regarding the contracts involved in transactions in a block.

Column	Data Type	Description
TIME_STAMP	TIMESTAMP	Timestamp of contract deployment/creation
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
ADDRESS	VARCHAR	Deployment address of the contract, unique identifier for a contract.
PROXY_CONTRACT_IMPL_ADDRESS	VARCHAR	Contains address of the proxy implementations of the contract.
CONTRACT_CREATOR_ADDRESS	VARCHAR	Address of an owner/deployer of the contract.

ERC1155_TRANSFER

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
VALUE_	VARCHAR	Value of ERC1155 token which is transferred.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
ID	VARCHAR	Token identifier (ID) similar to NFT.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or SFT which is involved in transfers.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

ERC1155_TRANSFERBATCH

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUES_	VARCHAR	Total value of the ERC1155 in the batch.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or NFT which is involved in transfers.
OPERATOR	VARCHAR	Address of an owner/deployer of the contract.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
IDs	VARCHAR	Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch.

ERC20_APPROVAL

Contains information regarding the approval status for the transfers of ERC20 or fungible tokens (FT).

Column	Data Type	Description
OWNER	VARCHAR	Address of the wallet of the owner of FT.
SPENDER	VARCHAR	Address of the wallet of FT buyer (spender).
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 20 contract or FT which is involved in transfers.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.

ERC20_TRANSFER

Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Address of the ERC20 contract which is involved in transfers.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.

ERC721_APPROVAL

Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
OWNER	VARCHAR	Address of the owner's wallet for the NFT.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	VARCHAR	If the NFT transfer is approved or not.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

ERC721_TRANSFER

Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.

FUNGIBLETOKEN_WALLET

Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.

Column	Data Type	Description
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BALANCE	VARCHAR	Current NFT balance of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TOKEN_ADDRESS	VARCHAR	Address of the ERC721 token.

LOGS

Contains information regarding the transaction logs generated in transactions of a block.

Column	Data Type	Description
DATA_	VARCHAR	Data emitted by the transaction log.
NAME	VARCHAR	Name of the event emitted.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
TOPIC_1	VARCHAR	Topic 1 (topic index 1) of the event.
ANONYMOUS	BOOLEAN	Contains a check for anonymous events.
ADDRESS	VARCHAR	Address of the log emitter.
STATUS	INTEGER	this represents whether the log is decoded or not. Added the sets of values the status column can have. Status value: 0 = decoded 1 = contract not verified 9 = ABI not found or event does not exist in ABI.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TOPIC_2	VARCHAR	Topic 2 (topic index 2) of the event.
TOPIC_3	VARCHAR	Topic 3 (topic index 3) of the event.
TOPIC_0	VARCHAR	Topic 0 (topic index 0) of the event.

NATIVE_WALLET

Contains information regarding the native or Ethereum wallets that can store ethers.

Column	Data Type	Description
BALANCE	VARCHAR	Ether balance of the native wallet.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

NATIVETOKEN_TRANSFER

Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.

Column	Data Type	Description
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of amount of tokens involved in transfers.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.

NFT

Contains information regarding ERC 721 tokens/NFTs encountered in transactions.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	ERC 721 address or contract address for the token.
TOKEN_URI	VARCHAR	URI of the NFT token.
TOKEN_ID	VARCHAR	Token ID of the NFT.
TIME_STAMP	TIMESTAMP	Timestamp of the NFT creation.

NFT_COLLECTION

Contains information regarding ERC 721 tokens/NFTs collections, NFT collections are set of NFTs designed/created by an common owner.

Column	Data Type	Description
NAME	VARCHAR	Name of NFT collection
TOKEN_STANDARD	VARCHAR	Standard protocol for the collection.
ADDRESS	VARCHAR	Address of the NFT collection.
SYMBOL	VARCHAR	Unique symbol for the collection.

OWNERSHIPTRANSFERRED

Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Contract address of the token involved in transfer.
PREVIOUSOWNER	VARCHAR	Previous owner (wallet) address.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
NEWOWNER	VARCHAR	New owner (wallet) address.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

TOKEN

Contains information regarding tokens involved in transactions of the blocks

Column	Data Type	Description
DECIMALS	VARCHAR	Decimal place value for the token.
SYMBOL	VARCHAR	Symbol of the token.
NAME	VARCHAR	Name of the token.
ADDRESS	VARCHAR	Contract address of the token.

TRANSACTION_DETAIL

Contains detailed information of transactions in the blocks.

Column	Data Type	Description
TYPE	VARCHAR	Type of the transaction.
MAX_FEE_PER_GAS	VARCHAR	Max gas fee to be paid in transaction execution.
GAS_PRICE	VARCHAR	Gas price on which transaction used gas.
TRANSACTION_INDEX	INTEGER	Index of the transaction.
MAX_PRIORITY_FEE_PER_GAS	VARCHAR	The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block.
RECEPIENT_CONTRACT_ADDRESS	VARCHAR	Contract address interacted with in the transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
METHOD_ID	VARCHAR	Method ID of the function involved in execution of transaction.
RECEIPT_EFFECTIVE_GAS_PRICE	VARCHAR	Gas price in effect on the transaction.
NONCE	INTEGER	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
CHAIN_ID	VARCHAR	Chain ID of the blockchain.
FUNCTION_NAME	VARCHAR	Function involved in execution of transaction.
LOGS_COUNT	SMALLINT	Number of logs in transaction.
RECEIPT_GAS_USED	INTEGER	Amount of gas used for execution of transaction.

TRANSACTIONS

Contains information about the transactions executed in the block.

Column	Data Type	Description
BLOCK_NUMBER	BIGINT	Integer value of the block number.
RECEIPT_STATUS	INTEGER	Receipt/Transaction status.
TRANSACTION_FEE	VARCHAR	Fee required to execute transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transaction creation.
TO_ADDRESS	VARCHAR	Address of the receiver of the transaction value.
RECEIPT_CUMULATIVE_GAS_USED	INTEGER	Total gas used in execution of transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of the amount involved in transaction.
FROM_ADDRESS	VARCHAR	Address of the source wallet from which value is deducted.
GAS	VARCHAR	Gas used in transaction.

Schema AVALANCHE_C (AVAX)

BLOCKS

Contains information for block data, one record per block.

Column	Data Type	Description
BLOCK_HASH	VARCHAR	Hashed value of the current block payload with previous block_hash, to guarantee immutability.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
BASE_FEE_PER_GAS	VARCHAR	Fee calculated by a formula that compares the size of the previous block (the amount of gas used for all the transactions) with the target size.
REWARD	VARCHAR	Refers to the cryptocurrency rewarded to a miner when they successfully validate a new block.
GAS_LIMIT	INTEGER	The maximum amount of work you're estimating a validator will do on a particular transaction.
PARENT_HASH	VARCHAR	Hashed value for parent node of the Merkle tree in the block.
GAS_USED	INTEGER	Amount of gas used in the mining of the block.
SIZE_	INTEGER	Size of block data in bytes.
MINER	VARCHAR	Address of the miner.
TRANSACTION_COUNT	INTEGER	Number of transactions present in the block.
TIME_STAMP	TIMESTAMP	Timestamp of the block creation.

BLOCK_DETAIL

Contains additional information for the block data, one record per block. FK block_number to blocks table.

Column	Data Type	Description
SHA3_UNCLES	VARCHAR	Hashed value of all the uncle blocks for a block.
RECEIPTS_ROOT	BIGINT	Receipts root is the Keccak 256-bit hash of the root node of the transaction receipt trie. Trie is composed of all receipts.
NONCE	VARCHAR	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
STATE_ROOT	VARCHAR	It is the Keccak 256-bit hash of the root node of the state trie after all the transactions are executed.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
VERSION	VARCHAR	Internal purpose.
UNCLES_COUNT	INTEGER	Number of uncles block generated with the block.
TRANSACTIONS_ROOT	VARCHAR	Root hash of the transactions sequence in blocks.
LOGS_BLOOM	VARCHAR	Data structure containing event logs.

APPROVALFORALL

Contains information regarding the event “approvalforall” which is triggered when an owner gives or changes approval for all of their NFTs to an operator.

Column	Data Type	Description
ACCOUNT	VARCHAR	Hashed value of all the uncle blocks for a block.
CONTRACT_ADDRESS	VARCHAR	Address of the contract which emits this event.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	BOOLEAN	Contains information if changes in NFT are approved or not.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.

CONTRACT

Contains information regarding the contracts involved in transactions in a block.

Column	Data Type	Description
TIME_STAMP	TIMESTAMP	Timestamp of contract deployment/creation
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
ADDRESS	VARCHAR	Deployment address of the contract, unique identifier for a contract.
PROXY_CONTRACT_IMPL_ADDRESS	VARCHAR	Contains address of the proxy implementations of the contract.
CONTRACT_CREATOR_ADDRESS	VARCHAR	Address of an owner/deployer of the contract.

ERC1155_TRANSFER

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
VALUE_	VARCHAR	Value of ERC1155 token which is transferred.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
ID	VARCHAR	Token identifier (ID) similar to NFT.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or NFT which is involved in transfers.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

ERC1155_TRANSFERBATCH

Contains information regarding the transfers of semi fungible tokens (SFT) in a block.

Column	Data Type	Description
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUES_	VARCHAR	Total value of the ERC1155 in the batch.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 1155 contract or NFT which is involved in transfers.
OPERATOR	VARCHAR	The address of the operator who will receive full rights for the owner’s tokens.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
IDs	VARCHAR	Token ID entifiers (IDs) similar to NFT of the tokens involved in transfers in the batch.

ERC20_APPROVAL

Contains information regarding the approval status for the transfers of ERC20 or Fungilble Tokens (FT)

Column	Data Type	Description
OWNER	VARCHAR	Address of the wallet of the owner of FT.
SPENDER	VARCHAR	Address of the wallet of FT buyer (spender).
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 20 contract or FT which is involved in transfers.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.

ERC20_TRANSFER

Contains information regarding the transfers of ERC20 fungible tokens (FT) in a block.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Address of the ERC20 contract which is involved in transfers.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
VALUE_	VARCHAR	Total value of the ERC20 transfer that is approved.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.

ERC721_APPROVAL

Contains information regarding the approval involving transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
OWNER	VARCHAR	Address of the owner's wallet for the NFT.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
APPROVED	VARCHAR	If the NFT transfer is approved or not.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

ERC721_TRANSFER

Contains information regarding the transfers of ERC721 non fungible tokens (NFT) in a block.

Column	Data Type	Description
TOKEN_ID	VARCHAR	Token ID of the NFT.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
CONTRACT_ADDRESS	VARCHAR	Address of the ERC 721 contract or NFT which is involved in transfer.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.

FUNGIBLETOKEN_WALLET

Contains information regarding the wallets which are involved in ERC721 non fungible tokens (NFT) transactions in a block.

Column	Data Type	Description
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BALANCE	VARCHAR	Current NFT balance of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
TOKEN_ADDRESS	VARCHAR	Address of the ERC721 token.

LOGS

Contains information regarding the transaction logs generated in transactions of a block.

Column	Data Type	Description
DATA_	VARCHAR	Data emitted by the transaction log.
NAME	VARCHAR	Name of the event emitted.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
TOPIC_1	VARCHAR	Topic 1 (topic index 1) of the event.
ANONYMOUS	BOOLEAN	Contains a check for anonymous events.
ADDRESS	VARCHAR	Address of the log emitter.
STATUS	INTEGER	this represents whether the log is decoded or not. Added the sets of values the status column can have. Status value: 0 = decoded 1 = contract not verified 9 = ABI not found or event does not exist in ABI.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.
TOPIC_2	VARCHAR	Topic 2 (topic index 2) of the event.
TOPIC_3	VARCHAR	Topic 3 (topic index 3) of the event.
TOPIC_0	VARCHAR	Topic 0 (topic index 0) of the event.

NATIVE_WALLET

Contains information regarding the native or Ethereum wallets that can store ethers.

Column	Data Type	Description
BALANCE	VARCHAR	Ether balance of the native wallet.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
WALLET_ADDRESS	VARCHAR	Address of the wallet.
BLOCK_NUMBER	BIGINT	Integer value of the block number.

NATIVETOKEN_TRANSFER

Contains information regarding native token (Ether, BNB, etc.) transfers encountered in the blocks.

Column	Data Type	Description
FROM_	VARCHAR	Source “from” address of the wallet involved in transfer.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of amount of tokens involved in transfers.
TIME_STAMP	TIMESTAMP	Timestamp of the transfer.
BLOCK_NUMBER	BIGINT	Integer value of the block number.
TO_	VARCHAR	Destination “to” address of the wallet involved in transfer.

NFT

Contains information regarding ERC 721 tokens/NFTs encountered in transactions.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	ERC 721 address or contract address for the token.
TOKEN_URI	VARCHAR	URI of the NFT token.
TOKEN_ID	VARCHAR	Token ID of the NFT.
TIME_STAMP	TIMESTAMP	Timestamp of the NFT creation.

NFT_COLLECTION

Contains information regarding ERC 721 tokens/NFTs collections, NFT collection is a set of NFTs designed/created by a common owner.

Column	Data Type	Description
NAME	VARCHAR	Name of NFT collection
TOKEN_STANDARD	VARCHAR	Standard protocol for the collection.
ADDRESS	VARCHAR	Address of the NFT collection.
SYMBOL	VARCHAR	Unique symbol for the collection.

OWNERSHIPTRANSFERRED

Contains information regarding an event “ownershiptransferred” which is triggered when tokens are transferred from one owner (account) to another.

Column	Data Type	Description
CONTRACT_ADDRESS	VARCHAR	Contract address of the token involved in transfer.
PREVIOUSOWNER	VARCHAR	Previous owner (wallet) address.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
NEWOWNER	VARCHAR	New owner (wallet) address.
EVENT_INDEX	SMALLINT	“Log index” refers to the index of a log in transaction.

TOKEN

Contains information regarding tokens involved in transactions of the blocks.

Column	Data Type	Description
DECIMALS	VARCHAR	Decimal place value for the token.
SYMBOL	VARCHAR	Symbol of the token.
NAME	VARCHAR	Name of the token.
ADDRESS	VARCHAR	Contract address of the token.

TRANSACTION_DETAIL

Contains detailed information of transactions in the blocks.

Column	Data Type	Description
TYPE	VARCHAR	Type of the transaction.
MAX_FEE_PER_GAS	VARCHAR	Max gas fee to be paid in transaction execution.
GAS_PRICE	VARCHAR	Gas price on which transaction used gas.
TRANSACTION_INDEX	INTEGER	Index of the transaction.
MAX_PRIORITY_FEE_PER_GAS	VARCHAR	The absolute maximum you are willing to pay per unit of gas to get your transaction included in a block.
RECEPIENT_CONTRACT_ADDRESS	VARCHAR	Contract address interacted with in the transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
METHOD_ID	VARCHAR	Method ID of the function involved in execution of transaction.
RECEIPT_EFFECTIVE_GAS_PRICE	VARCHAR	Gas price in effect on the transaction.
NONCE	INTEGER	Nonce is a random 32-bit number that miners use as a base for their hash calculations.
CHAIN_ID	VARCHAR	Chain ID of the blockchain.
FUNCTION_NAME	VARCHAR	Function involved in execution of transaction.
LOGS_COUNT	SMALLINT	Number of logs in transaction.
RECEIPT_GAS_USED	INTEGER	Amount of gas used for execution of transaction.

TRANSACTIONS

Contains information about the transactions executed in the block.

Column	Data Type	Description
BLOCK_NUMBER	BIGINT	Integer value of the block number.
RECEIPT_STATUS	INTEGER	Receipt/Transaction status.
TRANSACTION_FEE	VARCHAR	Fee required to execute transaction.
TIME_STAMP	TIMESTAMP	Timestamp of the transaction creation.
TO_ADDRESS	VARCHAR	Address of the receiver of the transaction value.
RECEIPT_CUMULATIVE_GAS_USED	INTEGER	Total gas used in execution of transaction.
TRANSACTION_HASH	VARCHAR	Hashed value transaction identifier.
VALUE_	VARCHAR	Value of the amount involved in transaction.
FROM_ADDRESS	VARCHAR	Address of the source wallet from which value is deducted.
GAS	VARCHAR	Gas used in transaction.