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