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
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 |
Updated about 1 year ago