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 4 months ago