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
Name | Description | Type |
---|---|---|
block_number | The unique number assigned to the block. | bigint |
block_hash | The hash of all the block's contents. | string |
time_stamp | The block's timestamp (in ISO-8601 format). | timestamp |
miner | The address miner who mines the block. | string |
reward | The amount rewarded to the miner of the block. | decimal |
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. | decimal |
parent_hash | Hash of the parent block. | string |
transaction_count | The number of transactions in the block. | integer |
BLOCK_DETAILS
The block detail model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The unique number assigned to the block. | bigint |
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. | string |
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. | decimal |
gas | Gas provided by the sender. | decimal |
transaction_fee | Amount paid to the Validator. | decimal |
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_DETAILS
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 |
receipt_effective_gas_price | The actual value per gas deducted from the sender's account. | decimal |
receipt_contract_address | Address allocated when a smart contract is deployed. | string |
receipt_gas_used | The amount of gas used in the transaction. | biginteger |
max_fee_per_gas | The maximum fee used by the transaction(in wei). | decimal |
max_priority_fee_per_gas | The maximum priority fee used by the transaction. | decimal |
method_id | Method_id | string |
gas_price | Gas price provided by the sender in Wei. | decimal |
nonce | The number of transactions made by the sender before this one. | biginteger |
type_ | Transaction type. One of 0 (Legacy), 1 (Legacy), 2. | string |
transaction_index | Integer of the transactions index position in the block. | biginteger |
log_count | The number of logs produced in the transaction. | integer |
CONTRACTS
The contract model follows the following structure:
Name | Description | Type |
---|---|---|
contract_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. | timestamp |
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. | bigint |
transaction_hash | The hash of the transaction. | string |
ERC20_EVT_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. | integer |
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. | decimal |
time_stamp | ERC20 Token's approval timestamp (in ISO-8601 format). | timestamp |
block_number | The block's number where this token is. | bigint |
contract_address | Address allocated when a smart contract is deployed. | string |
ERC20_EVT_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. | integer |
from_ | The ERC20 token sender address. | string |
to_ | The ERC20 token receiver address. | string |
value_ | Number of ERC20 token transfer. | decimal |
time_stamp | ERC20 Token's transfer timestamp (in ISO-8601 format). | timestamp |
block_number | The block's number where this token is. | bigint |
contract_address | Address allocated when a smart contract is deployed. | string |
ERC721_EVT_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. | integer |
token_id | A token ID is a number that identifies an approved token. | decimal |
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. | bigint |
time_stamp | ERC721 Token's approval timestamp (in ISO-8601 format). | timestamp |
ERC721_EVT_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. | integer |
token_id | A token ID is a number that identifies each token minted from a smart contract. | decimal |
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. | bigint |
time_stamp | ERC721 Token's transfer timestamp (in ISO-8601 format). | timestamp |
ERC1155_EVT_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_EVT_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. | integer |
from_ | The ERC1155 token sender address. | string |
to_ | The ERC1155 token receiver address. | string |
value_ | Number of ERC1155 token. | decimal |
time_stamp | ERC1155 Token's transfer timestamp (in ISO-8601 format). | timestamp |
block_number | The block's number where this token is. | bigint |
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. | decimal |
ERC1155_EVT_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. | 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_stamp | ERC1155 Token's transfer timestamp (in ISO-8601 format). | timestamp |
block_number | The block's number where this token is. | bigint |
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. | string |
FUNGIBLETOKEN_WALLETS
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. | bigint |
balance | The amount of crypto your fungible token wallet account held. | decimal |
time_stamp | Transaction's timestamp (in ISO-8601 format). | timestamp |
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. | integer |
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. | bigint |
time_stamp | The log's timestamp (in ISO-8601 format). | timestamp |
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_WALLETS
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. | bigint |
balance | The amount of crypto your fungible token wallet account held. | integer |
time_stamp | Transaction's timestamp (in ISO-8601 format). | timestamp |
NATIVETOKEN_TRANSFERS
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. | bigint |
from_ | The token sender address. | string |
to_ | The token receiver address. | string |
value_ | Number of native token transfers. | decimal |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | string |
NFT_COLLECTIONS
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 |
NFTS
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. | decimal |
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. | timestamp |
TOKENS
The Token model follows the following structure:
Name | Description | Type |
---|---|---|
contract_address | Address on which this Fungible Token contract is deployed. | string |
name | The name of the Fungible Token contract. | string |
decimals | Decimals refer to how divisible a token can be, from 0 to 18. | decimal |
symbol | The symbol of the Fungible Token contract. | string |
CONTRACT_EVT_APPROVALFORALL
The Approvalforall model follows the following structure:
Name | Description | Type |
---|---|---|
event_index | The position of the event log in the Ethereum block. | integer |
block_number | The block number | bigint |
transaction_hash | The unique identifier of the Ethereum transaction that triggered the event. | string |
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 |
time_stamp | The time_stamp | timestamp |
CONTRACT_EVT_OWNERSHIPTRANSFERRED
Ownershiptransferred model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block number | bigint |
time_stamp | The time_stamp | timestamp |
transaction_hash | The transaction's unique identifier. | string |
event_index | Integer of the log index position in the block. | integer |
previousowner | 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