Sei Core Tables
These tables are built and maintained by Space and Time.
SEI Core Data Model
BLOCKS
The blocks model follows the following structure
Name | Description | Type |
---|---|---|
block_number | The unique number assigned to the block. | bigint |
time_stamp | The block's timestamp (in ISO-8601 format). | timestamp |
block_hash | The hash of all the block's contents. | varchar |
proposer_address | Original proposer of the block. | varchar |
gas_used | Total gas used in the block. | decimal |
gas_wanted | Max amount of gas estimated | decimal |
parent_hash | Hash of the parent block. | string |
transaction_count | The number of transactions in the block. | integer |
last_commit_hash | commit from validators from the last block. | varchar |
data_hash | Transactions. | varchar |
validators_hash | Validators for the current block. | varchar |
next_validators_hash | Validators for the next block. | varchar |
consensus_hash | Consensus params for current block. | varchar |
app_hash | State after txs from the previous block. | varchar |
last_results_hash | Root hash of all results from the txs from the previous block. | varchar |
evidence_hash | Evidence included in the block. | varchar |
TRANSACTIONS
The Transactions model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | Block number where this transaction was in. | biginteger |
time_stamp | Transaction's timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
transaction_fee | Amount paid to the Validator. | decimal |
gas_used | Gas provided by the sender. | decimal |
gas_wanted | Max gas amount of gas estimated | decimal |
message_count | Number of messages committed in a single transaction | integer |
succeeded | Transaction Status | boolean |
FAILED_TRANSACTIONS
The Failed_Transaction detail model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | Block number where this failed transaction was in | bigint |
time_stamp | Failed Transaction timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
code | Id of the code | int |
log_ | Information about the execution of actions. | varchar |
codespace | Namespace for the Code. | varchar |
MESSAGES
The Codes model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | Block Number where this message was in. | bigint |
time_stamp | Transaction timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | int |
action_ | Action executed within the message. | varchar |
module | Type for VersionInfo. | varchar |
sender | Address of the sender of this message. | varchar |
log_ | Information about the execution of actions. | varchar |
CODES
The Codes model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this code was created. | bigint |
time_stamp | Execution Timestamp | timestamp |
transaction_hash | Transaction hash of the store code message | varchar |
message_id | Unique identifier of the message. | int |
code_id | Unique identifier of the code. | bigint |
code_hash | Hash of the code. | varchar |
uploaded_by | Account address of the creator of the code. | varchar |
CONTRACTS
The Contract model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number in which the contract is created. | bigint |
time_stamp | The time at which the contract is created or updated | timestamp |
transaction_hash | Transaction hash of the instantiate or migrate message | varchar |
message_id | Unique identifier of the message | int |
contract_address | Unique Identifier, address of the contract | varchar |
code_id | Code ID | bigint |
admin_address | Contract admin account | varchar |
cw2_info_contract | Contract Type | varchar |
cw2_info_version | Contract version | varchar |
instatiated_by | Contract creator account | varchar |
label | The name of the contract | varchar |
CONTRACT_EXECUTIONS
The Contract Execution model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number in which the contract is created. | bigint |
time_stamp | The time at which the contract is created. | timestamp |
transaction_hash | Transaction hash of the instantiate or migrate message | varchar |
message_id | Unique identifier of the message. | int |
contract_address | Unique Identifier, address of the contract | varchar |
sender | The sender of the execution request. | varchar |
execute_message | The details of the executed message within the contract. The type of the message, like claim/swap/transfer, and the details of the execution, such as the amount minted or swapped | varchar |
CONTRACT_EXECUTION_ATTACHED_FUNDS
The Contract Execution Attached Funds model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number in which the contract is created. | bigint |
time_stamp | The time at which the contract is created. | timestamp |
transaction_hash | Transaction hash of the instantiate or migrate message | varchar |
message_id | Unique identifier of the message. | int |
contract_address | Unique identifier, address of the contract. | varchar |
sender | The sender of the execution request. | varchar |
amount | Amount of tokens transferred/minted/used/burned, etc. 18-digit-precision decimal number | decimal |
denom | Unique token identifier with its denomination key. | varchar |
NATIVETOKEN_TRANSFERS
The Native Token Transfer model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique Identifier of the Message | integer |
from_ | The token sender address. | varchar |
to_ | The token receiver address. | varchar |
amount | Amount of tokens transferred. | decimal |
denom | Unique token identifier with its denomination key. | varchar |
NATIVE_WALLETS
The Native Wallets model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
address_ | Address of the wallet. | varchar |
balance | balance by address for a given denomination. | decimal |
denom | Unique token identifier with its denomination key. | varchar |
TOKENFACTORY_MSG_CREATEDENOM
The TokenFactory Msg CreatedNom model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message | integer |
sender | Sender of the denom creation request. | varchar |
subdenom | Token identifier without the factory info and creator address. | varchar |
TOKENFACTORY_MSG_MINT
The TokenFactory Msg Mint model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
sender | Sender of the token mint request. | varchar |
amount | Amount minted for a given denomination. | decimal |
TOKENFACTORY_MSG_BURN
The TokenFactory Msg Burn model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
sender | Sender of the token burn request. | varchar |
amount | Amount burned for a given denomination. | decimal |
denom | Unique token identifier with a denom. | varchar |
TOKENFACTORY_MSG_CHANGEADMIN
The TokenFactory Msg Burn model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
old_admin | Old account of the adminship of a denom. | varchar |
new_admin | New account of the adminship of a denom. | varchar |
denom | Unique token identifier with a denom. | varchar |
NFT_COLLECTIONS
The TokenFactory Msg Burn model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | NativeToken's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
contract_address | Unique Identifier, address of the contract. | varchar |
name_ | Name of the NFT collection. | varchar |
symbol | Symbol of the NFT collection. | varchar |
CW721_MSG_TRANSFERNFT
The CW721 Msg TransferNFT model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | Token's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
contract_address | Unique Identifier, address of the contract. | varchar |
recipient | Unique Identifier, address of the recipient. | varchar |
token_id | Unique token ID of the NFT. | varchar |
CW721_MSG_SENDNFT
The CW721 Msg SendNFT model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | Token's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
token_contract_address | Unique Identifier, address of the token contract | varchar |
recipient_contract_address | Unique Identifier, address of the recipient contract | varchar |
token_id | Token ID of the NFT | varchar |
msg | varchar |
CW721_MSG_APPROVE
The CW721 Msg Approval model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | Token's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
contract_address | Unique Identifier, address of the token contract | varchar |
spender | Address which is spending coins. | varchar |
token_id | Token ID of the NFT | varchar |
expires | varchar |
CW721_MSG_REVOKE
The CW721 Msg Revoke model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | Token's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
contract_address | Unique Identifier, address of the contract | varchar |
spender | Spender of the revoking of the message. | varchar |
token_id | Unique Token ID. | varchar |
CW721_MSG_APROVEALL
The CW721 Msg ApprovalAll model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | Token's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
contract_address | Unique Identifier, address of the contract | varchar |
operator | The operator who has permission to transfer or send all tokens. | varchar |
expires | varchar |
CW721_MSG_REVOKEALL
The CW721 Msg RevokeAll model follows the following structure:
Name | Description | Type |
---|---|---|
block_number | The block's number where this token is. | bigint |
time_stamp | Token's transfer timestamp (in ISO-8601 format). | timestamp |
transaction_hash | The transaction's unique identifier. | varchar |
message_id | Unique identifier of the message. | integer |
contract_address | Unique Identifier, address of the contract. | varchar |
operator | The operator who has permission to transfer or send all tokens. | varchar |
Updated 8 months ago