Goerli Core Data Model

BLOCKS

The blocks model follows the following structure

Name	Description	Type
block_number	The unique number assigned to the block.	integer
block_hash	The hash of all the block's contents.	string
time_stamp	The block's timestamp (in ISO-8601 format).	date-time
miner	The address miner who mines the block.	string
reward	The amount rewarded to the miner of the block.	integer
size	The size of a block in bytes.	integer
gas_used	Total gas used in the block.	integer
gas_limit	The maximum gas allowed in this block.	integer
base_fee_per_gas	The base fee to include a transaction in the block.	integer
parent_hash	Hash of the parent block.	string
transaction_count	The number of transactions in the block.	integer

BLOCK_DETAIL

The block detail model follows the following structure:

Name	Description	Type
block_number	The unique number assigned to the block.	integer
sha3_uncles	The hash of the block's uncle blocks.	string
state_root	The root of the final state trie of the block.	string
transactions_root	The root of the transaction trie of the block.	string
logs_bloom	The bloom filter for the logs of the block.	string
receipts_root	The root of the receipts trie of the block.	string
uncle_count	The number of uncle blocks included in the block.	integer
version	The block version number.	string
nonce	The block's nonce, is used in the proof of work algorithm.	biginteger

TRANSACTIONS

The Transactions model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
block_number	Block number where this transaction was in.	biginteger
from_address	Address of the sender.	string
to_address	Address of the receiver.	string
value	Value transferred in Wei.	bigdecimal
gas	Gas provided by the sender.	biginteger
transaction_fee	Amount paid to the Validator.	integer
cumulative_gas_used	Amount of gas used when Tx was executed in a block.	biginteger
status	Status of transaction.	string
time_stamp	Transaction's timestamp (in ISO-8601 format).	date-time

TRANSACTION_DETAIL

The Transaction detail model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
chain_id	ChainID is an additional way to tell chains apart.	string
function_name	Method name which invoked.	string
effective_gas_price	The actual value per gas deducted from the sender's account.	biginteger
contract_address	Address allocated when a smart contract is deployed.	string
gas_used	The amount of gas used in the transaction.	biginteger
max_fee_per_gas	The maximum fee used by the transaction(in wei).	integer
max_priority_fee_per_gas	The maximum priority fee used by the transaction.	integer
method_id
gas_price	Gas price provided by the sender in Wei.	biginteger
nonce	The number of transactions made by the sender before this one.	biginteger
type	Transaction type. One of 0 (Legacy), 1 (Legacy), 2.	biginteger
transaction_index	Integer of the transactions index position in the block.	biginteger
log_count	The number of logs produced in the transaction.	integer

CONTRACT

The contract model follows the following structure:

Name	Description	Type
address	Address from which this contract originated.	string
contract_creator_address	The address that deployed the contract.	string
time_stamp	The time at which the contract is created.	string
proxy_contract_impl_address	If the contract is a proxy contract, proxy implementation address.	string
block_number	The block's number in which the contract is created.	integer
transaction_hash	The hash of the transaction.	string

ERC20_APPROVAL

The ERC20 Approval model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
owner	The token owner who hold ERC20 tokens.	string
spender	The address which gets approval from the owner to spend that ERC20 tokens.	string
value	Number of ERC20 token for approval.	integer
time_stamp	ERC20 Token's approval timestamp (in ISO-8601 format).	string
block_number	The block's number where this token is.	integer
contract_address	Address allocated when a smart contract is deployed.	string

ERC20_TRANSFER

The ERC20 Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer 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_stamp	ERC20 Token's transfer timestamp (in ISO-8601 format).	string
block_number	The block's number where this token is.	integer
contract_address	Address allocated when a smart contract is deployed.	string

ERC721_APPROVAL

The ERC721 Approval model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
token_id	A token ID is a number that identifies an approved token.	integer
contract_address	Address allocated when a smart contract is deployed.	string
owner	The token owner who hold ERC721 tokens.	string
approved	The ERC721 token that the owner was approved.	boolean
block_number	The block's number where this token is.	integer
time_stamp	ERC721 Token's approval timestamp (in ISO-8601 format).	string

ERC721_TRANSFER

The ERC721 Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
token_id	A token ID is a number that identifies each token minted from a smart contract.	integer
contract_address	Address allocated when a smart contract is deployed.	string
to_	The ERC721 token receiver address.	string
from_	The ERC721 token sender address.	string
block_number	The block's number where this token is.	integer
time_stamp	ERC721 Token's transfer timestamp (in ISO-8601 format).	string

ERC1155_APPROVAL

The ERC1155 Approval model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
operator	The address which gets approval from the account to spend that ERC1155 tokens.	string
account	The account who hold ERC1155 tokens.	string
approved	The ERC1155 token that account was approved.	boolean
time_stamp	ERC1155 Token's approval timestamp (in ISO-8601 format).	string
block_number	The block's number where this token is.	integer
contract_address	Address allocated when a smart contract is deployed.	string

ERC1155_TRANSFER

The ERC1155 Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer 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_stamp	ERC1155 Token's transfer timestamp (in ISO-8601 format).	string
block_number	The block's number where this token is.	integer
contract_address	Address allocated when a smart contract is deployed.	string
operator	The address which gets approval from the account to transfer that ERC1155 tokens.	string
id	The ID of the ERC1155 token that was transferred.	integer

ERC1155_TRANSFERBATCH

The ERC1155 Transfer Batch model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer 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_stamp	ERC1155 Token's transfer timestamp (in ISO-8601 format).	string
block_number	The block's number where this token is.	integer
contract_address	Address allocated when a smart contract is deployed.	string
operator	The address which gets approval from the account to transfer	string
ids	A 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:

Name	Description	Type
wallet_address	The unique identity that's used to send and receive cryptocurrency.	string
token_address	The unique identity of the deployed token smart contract.	string
block_number	The block's Number.	integer
balance	The amount of crypto your fungible token wallet account held.	integer
time_stamp	Transaction's timestamp (in ISO-8601 format).	string

LOGS

The Logs model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
address	Address from which this log originated.	string
data	Contains one or more 32 Bytes non-indexed arguments of the log.	string
status	Status of the event log.	integer
block_number	The block number the parent transaction was included in.	integer
time_stamp	The log's timestamp (in ISO-8601 format).	integer
topic_0	The topic_0 of the log.	string
topic_1	The topic_1 of the log.	string
topic_2	The topic_2 of the log.	string
anonymous	The event is anonymous.	boolean

NATIVE_WALLET

The Native Wallet model follows the following structure:

Name	Description	Type
wallet_address	The unique identity that's used to send and receive cryptocurrency.	string
block_number	The block's Number.	integer
balance	The amount of crypto your fungible token wallet account held.	integer
time_stamp	Transaction's timestamp (in ISO-8601 format).	string

NATIVETOKEN_TRANSFER

The Native Token Transfer model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
block_number	The 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_stamp	NativeToken's transfer timestamp (in ISO-8601 format).	string

NFT_COLLECTION

The NFT Collection model follows the following structure:

Name	Description	Type
address	Address from which this NFT Collection contract originated.	string
name	The name of the Non-Fungible Token Collection.	string
symbol	The symbol of a Non-Fungible Token.	string
token_standard	ERC standard used to create the NFT (ERC721, ERC1155).	string

NFT

The NFT model follows the following structure:

Name	Description	Type
contract_address	Address from which this Non-Fungible Token contract originated.	string
token_id	A token ID is a number that identifies a Non-Fungible token.	integer
name	The name of Non-Fungible Token.	string
image	The Unique image of a Non-fungible asset.	string
description	Describe the Non-fungible Token Attributes.	string
token_uri	The token URI on an NFT is a unique identifier of what the token "looks" like.	string
time_stamp	The time at which the Non-Fungible Token contract is created.	string

TOKEN

The Token model follows the following structure:

Name	Description	Type
address	Address on which this Fungible Token contract is deployed.	string
contract_creator	The address that deployed the Fungible Token contract.	string
name	The name of the Fungible Token contract.	string
time_stamp	The time at which the Fungible Token contract is created.	string
decimal	Decimals refer to how divisible a token can be, from 0 to 18.	integer
symbol	The symbol of the Fungible Token contract.	string
proxy_contract_impl_address	Proxy address.	string
block_number	The block's number where the Fungible Token contract is created.	integer
transaction_hash	The hash of the transaction.	string

APPROVALFORALL

The Approvalforall model follows the following structure:

Name	Description	Type
transaction_hash	The unique identifier of the Ethereum transaction that triggered the event.	string
event_index	The position of the event log in the Ethereum block.	bigint
operator	The address that is called the setApprovalForAll function.	string
account	The address that owns the assets that were approved.	string
approved	A boolean indicating whether the approval is granted or revoked.	boolean
contract_address	The address of the smart contract that manages the approved assets.	string

OWNERSHIPTRANSFERRED

Ownershiptransferred model follows the following structure:

Name	Description	Type
transaction_hash	The transaction's unique identifier.	string
event_index	Integer of the log index position in the block.	bigint
previosowner	The address of the previous owner of the token.	string
newowner	The address of the new owner of the token.	string
contract_address	Token address.	string