Goerli Data Model

These tables are built and maintained by Space and Time.

Goerli Core Data Model

BLOCKS

The blocks model follows the following structure

NameDescriptionType
block_numberThe unique number assigned to the block.integer
block_hashThe hash of all the block's contents.string
time_stampThe block's timestamp (in ISO-8601 format).date-time
minerThe address miner who mines the block.string
rewardThe amount rewarded to the miner of the block.integer
sizeThe 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.integer
parent_hashHash of the parent block.string
transaction_countThe number of transactions in the block.integer

BLOCK_DETAIL

The block detail model follows the following structure:

NameDescriptionType
block_numberThe unique number assigned to the block.integer
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.biginteger

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
valueValue transferred in Wei.bigdecimal
gasGas provided by the sender.biginteger
transaction_feeAmount paid to the Validator.integer
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_DETAIL

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
effective_gas_priceThe actual value per gas deducted from the sender's account.biginteger
contract_addressAddress allocated when a smart contract is deployed.string
gas_usedThe amount of gas used in the transaction.biginteger
max_fee_per_gasThe maximum fee used by the transaction(in wei).integer
max_priority_fee_per_gasThe maximum priority fee used by the transaction.integer
method_id
gas_priceGas price provided by the sender in Wei.biginteger
nonceThe number of transactions made by the sender before this one.biginteger
typeTransaction type. One of 0 (Legacy), 1 (Legacy), 2.biginteger
transaction_indexInteger of the transactions index position in the block.biginteger
log_countThe number of logs produced in the transaction.integer

CONTRACT

The contract model follows the following structure:

NameDescriptionType
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.string
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.integer
transaction_hashThe hash of the transaction.string

ERC20_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.bigint
ownerThe token owner who hold ERC20 tokens.string
spenderThe address which gets approval from the owner to spend that ERC20 tokens.string
valueNumber of ERC20 token for approval.integer
time_stampERC20 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

ERC20_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.bigint
from_The ERC20 token sender address.string
to_The ERC20 token receiver address.string
value_Number of ERC20 token transfer.integer
time_stampERC20 Token's transfer 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

ERC721_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.bigint
token_idA token ID is a number that identifies an approved token.integer
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.integer
time_stampERC721 Token's approval timestamp (in ISO-8601 format).string

ERC721_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.bigint
token_idA token ID is a number that identifies each token minted from a smart contract.integer
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.integer
time_stampERC721 Token's transfer timestamp (in ISO-8601 format).string

ERC1155_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_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.bigint
from_The ERC1155 token sender address.string
to_The ERC1155 token receiver address.string
value_Number of ERC1155 token.integer
time_stampERC1155 Token's transfer 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
operatorThe address which gets approval from the account to transfer that ERC1155 tokens.string
idThe ID of the ERC1155 token that was transferred.integer

ERC1155_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.bigint
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).string
block_numberThe block's number where this token is.integer
contract_addressAddress allocated when a smart contract is deployed.string
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.integer

FUNGIBLETOKEN_WALLET

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.integer
balanceThe amount of crypto your fungible token wallet account held.integer
time_stampTransaction's timestamp (in ISO-8601 format).string

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.bigint
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.integer
time_stampThe log's timestamp (in ISO-8601 format).integer
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_WALLET

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.integer
balanceThe amount of crypto your fungible token wallet account held.integer
time_stampTransaction's timestamp (in ISO-8601 format).string

NATIVETOKEN_TRANSFER

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.integer
from_The token sender address.string
to_The token receiver address.string
value_Number of native token transfers.integer
time_stampNativeToken's transfer timestamp (in ISO-8601 format).string

NFT_COLLECTION

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

NFT

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.integer
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.string

TOKEN

The Token model follows the following structure:

NameDescriptionType
addressAddress on which this Fungible Token contract is deployed.string
contract_creatorThe address that deployed the Fungible Token contract.string
nameThe name of the Fungible Token contract.string
time_stampThe time at which the Fungible Token contract is created.string
decimalDecimals refer to how divisible a token can be, from 0 to 18.integer
symbolThe symbol of the Fungible Token contract.string
proxy_contract_impl_addressProxy address.string
block_numberThe block's number where the Fungible Token contract is created.integer
transaction_hashThe hash of the transaction.string

APPROVALFORALL

The Approvalforall model follows the following structure:

NameDescriptionType
transaction_hashThe unique identifier of the Ethereum transaction that triggered the event.string
event_indexThe position of the event log in the Ethereum block.bigint
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

OWNERSHIPTRANSFERRED

Ownershiptransferred model follows the following structure:

NameDescriptionType
transaction_hashThe transaction's unique identifier.string
event_indexInteger of the log index position in the block.bigint
previosownerThe address of the previous owner of the token.string
newownerThe address of the new owner of the token.string
contract_addressToken address.string