Data Model

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:14.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;color:#434343;mso-ansi-language:EN;mso-fareast-language:
EN-US;mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.

<span lang="EN" style="font-size:11.0pt;line-height:115%;font-family:"Arial",sans-serif;
mso-fareast-font-family:Arial;mso-ansi-language:EN;mso-fareast-language:EN-US;
mso-bidi-language:AR-SA">

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.