ETHEREUM - Core Tables (DEPRECATED)

These tables are built and maintained by Space and Time.

Ethereum Core Data Model

BLOCKS

The blocks model follows the following structure

NameDescriptionType
block_numberThe unique number assigned to the block.bigint
block_hashThe hash of all the block's contents.string
time_stampThe block's timestamp (in ISO-8601 format).timestamp
minerThe address miner who mines the block.string
rewardThe amount rewarded to the miner of the block.decimal
size_The size of a block in bytes.integer
gas_usedTotal gas used in the block.integer
gas_limitThe maximum gas allowed in this block.integer
base_fee_per_gasThe base fee to include a transaction in the block.decimal
parent_hashHash of the parent block.string
transaction_countThe number of transactions in the block.integer

BLOCK_DETAILS

The block detail model follows the following structure:

NameDescriptionType
block_numberThe unique number assigned to the block.bigint
sha3_unclesThe hash of the block's uncle blocks.string
state_rootThe root of the final state trie of the block.string
transactions_rootThe root of the transaction trie of the block.string
logs_bloomThe bloom filter for the logs of the block.string
receipts_rootThe root of the receipts trie of the block.string
uncle_countThe number of uncle blocks included in the block.integer
versionThe block version number.string
nonceThe block's nonce, is used in the proof of work algorithm.string

TRANSACTIONS

The Transactions model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
block_numberBlock number where this transaction was in.biginteger
from_addressAddress of the sender.string
to_addressAddress of the receiver.string
value_Value transferred in Wei.decimal
gasGas provided by the sender.decimal
transaction_feeAmount paid to the Validator.decimal
cumulative_gas_usedAmount of gas used when Tx was executed in a block.biginteger
statusStatus of transaction.string
time_stampTransaction's timestamp (in ISO-8601 format).date-time

TRANSACTION_DETAILS

The Transaction detail model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
chain_idChainID is an additional way to tell chains apart.string
function_nameMethod name which invoked.string
receipt_effective_gas_priceThe actual value per gas deducted from the sender's account.decimal
receipt_contract_addressAddress allocated when a smart contract is deployed.string
receipt_gas_usedThe amount of gas used in the transaction.biginteger
max_fee_per_gasThe maximum fee used by the transaction(in wei).decimal
max_priority_fee_per_gasThe maximum priority fee used by the transaction.decimal
method_idMethod_idstring
gas_priceGas price provided by the sender in Wei.decimal
nonceThe number of transactions made by the sender before this one.biginteger
type_Transaction type. One of 0 (Legacy), 1 (Legacy), 2.string
transaction_indexInteger of the transactions index position in the block.biginteger
log_countThe number of logs produced in the transaction.integer

CONTRACTS

The contract model follows the following structure:

NameDescriptionType
contract_addressAddress from which this contract originated.string
contract_creator_addressThe address that deployed the contract.string
time_stampThe time at which the contract is created.timestamp
proxy_contract_impl_addressIf the contract is a proxy contract, proxy implementation address.string
block_numberThe block's number in which the contract is created.bigint
transaction_hashThe hash of the transaction.string

ERC20_EVT_APPROVAL

The ERC20 Approval model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
ownerThe token owner who hold ERC20 tokens.string
spenderThe address which gets approval from the owner to spend that ERC20 tokens.string
value_Number of ERC20 token for approval.decimal
time_stampERC20 Token's approval timestamp (in ISO-8601 format).timestamp
block_numberThe block's number where this token is.bigint
contract_addressAddress allocated when a smart contract is deployed.string

ERC20_EVT_TRANSFER

The ERC20 Transfer model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
from_The ERC20 token sender address.string
to_The ERC20 token receiver address.string
value_Number of ERC20 token transfer.decimal
time_stampERC20 Token's transfer timestamp (in ISO-8601 format).timestamp
block_numberThe block's number where this token is.bigint
contract_addressAddress allocated when a smart contract is deployed.string

ERC721_EVT_APPROVAL

The ERC721 Approval model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
token_idA token ID is a number that identifies an approved token.decimal
contract_addressAddress allocated when a smart contract is deployed.string
ownerThe token owner who hold ERC721 tokens.string
approvedThe ERC721 token that the owner was approved.boolean
block_numberThe block's number where this token is.bigint
time_stampERC721 Token's approval timestamp (in ISO-8601 format).timestamp

ERC721_EVT_TRANSFER

The ERC721 Transfer model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
token_idA token ID is a number that identifies each token minted from a smart contract.decimal
contract_addressAddress allocated when a smart contract is deployed.string
to_The ERC721 token receiver address.string
from_The ERC721 token sender address.string
block_numberThe block's number where this token is.bigint
time_stampERC721 Token's transfer timestamp (in ISO-8601 format).timestamp

ERC1155_EVT_APPROVAL

The ERC1155 Approval model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.bigint
operatorThe address which gets approval from the account to spend that ERC1155 tokens.string
accountThe account who hold ERC1155 tokens.string
approvedThe ERC1155 token that account was approved.boolean
time_stampERC1155 Token's approval timestamp (in ISO-8601 format).string
block_numberThe block's number where this token is.integer
contract_addressAddress allocated when a smart contract is deployed.string

ERC1155_EVT_TRANSFER

The ERC1155 Transfer model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
from_The ERC1155 token sender address.string
to_The ERC1155 token receiver address.string
value_Number of ERC1155 token.decimal
time_stampERC1155 Token's transfer timestamp (in ISO-8601 format).timestamp
block_numberThe block's number where this token is.bigint
contract_addressAddress allocated when a smart contract is deployed.string
operatorThe address which gets approval from the account to transfer that ERC1155 tokens.string
idThe ID of the ERC1155 token that was transferred.decimal

ERC1155_EVT_TRANSFERBATCH

The ERC1155 Transfer Batch model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
from_The ERC1155 token sender address.string
to_The ERC1155 token receiver address.string
value_Number of ERC1155 token transfer in batch.integer
time_stampERC1155 Token's transfer timestamp (in ISO-8601 format).timestamp
block_numberThe block's number where this token is.bigint
operatorThe address which gets approval from the account to transferstring
idsA token ID is a number that identifies each token minted from a smart contract.string

FUNGIBLETOKEN_WALLETS

The Fungible Token Wallet model follows the following structure:

NameDescriptionType
wallet_addressThe unique identity that's used to send and receive cryptocurrency.string
token_addressThe unique identity of the deployed token smart contract.string
block_numberThe block's Number.bigint
balanceThe amount of crypto your fungible token wallet account held.decimal
time_stampTransaction's timestamp (in ISO-8601 format).timestamp

LOGS

The Logs model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
addressAddress from which this log originated.string
dataContains one or more 32 Bytes non-indexed arguments of the log.string
statusStatus of the event log.integer
block_numberThe block number the parent transaction was included in.bigint
time_stampThe log's timestamp (in ISO-8601 format).timestamp
topic_0The topic_0 of the log.string
topic_1The topic_1 of the log.string
topic_2The topic_2 of the log.string
anonymousThe event is anonymous.boolean

NATIVE_WALLETS

The Native Wallet model follows the following structure:

NameDescriptionType
wallet_addressThe unique identity that's used to send and receive cryptocurrency.string
block_numberThe block's Number.bigint
balanceThe amount of crypto your fungible token wallet account held.integer
time_stampTransaction's timestamp (in ISO-8601 format).timestamp

NATIVETOKEN_TRANSFERS

The Native Token Transfer model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
block_numberThe block's number where this token is.bigint
from_The token sender address.string
to_The token receiver address.string
value_Number of native token transfers.decimal
time_stampNativeToken's transfer timestamp (in ISO-8601 format).string

NFT_COLLECTIONS

The NFT Collection model follows the following structure:

NameDescriptionType
addressAddress from which this NFT Collection contract originated.string
nameThe name of the Non-Fungible Token Collection.string
symbolThe symbol of a Non-Fungible Token.string
token_standardERC standard used to create the NFT (ERC721, ERC1155).string

NFTS

The NFT model follows the following structure:

NameDescriptionType
contract_addressAddress from which this Non-Fungible Token contract originated.string
token_idA token ID is a number that identifies a Non-Fungible token.decimal
nameThe name of Non-Fungible Token.string
imageThe Unique image of a Non-fungible asset.string
descriptionDescribe the Non-fungible Token Attributes.string
token_uriThe token URI on an NFT is a unique identifier of what the token "looks" like.string
time_stampThe time at which the Non-Fungible Token contract is created.timestamp

TOKENS

The Token model follows the following structure:

NameDescriptionType
contract_addressAddress on which this Fungible Token contract is deployed.string
nameThe name of the Fungible Token contract.string
decimalsDecimals refer to how divisible a token can be, from 0 to 18.decimal
symbolThe symbol of the Fungible Token contract.string

CONTRACT_EVT_APPROVALFORALL

The Approvalforall model follows the following structure:

NameDescriptionType
event_indexThe position of the event log in the Ethereum block.integer
block_numberThe block numberbigint
transaction_hashThe unique identifier of the Ethereum transaction that triggered the event.string
operatorThe address that is called the setApprovalForAll function.string
accountThe address that owns the assets that were approved.string
approvedA boolean indicating whether the approval is granted or revoked.boolean
contract_addressThe address of the smart contract that manages the approved assets.string
time_stampThe time_stamptimestamp

CONTRACT_EVT_OWNERSHIPTRANSFERRED

Ownershiptransferred model follows the following structure:

NameDescriptionType
block_numberThe block numberbigint
time_stampThe time_stamptimestamp
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.integer
previousownerThe address of the previous owner of the token.string
newownerThe address of the new owner of the token.string
contract_addressToken address.string