prv_explorer
Tables (14)
accounts
- acc_id — BIGINT unsigned — Primary key — NOT NULL
- address — VARBINARY(32) — NOT NULL — index
assets
- denom — VARCHAR(255) — Primary key — NOT NULL
- amount — VARCHAR(100)
- channel_id — VARCHAR(64)
- height — BIGINT unsigned
balances
- address — VARBINARY(32) — Primary key — NOT NULL
- denom — VARCHAR(255) — Primary key
- amount — VARCHAR(100)
- height — BIGINT unsigned
blocks
- height — BIGINT unsigned — Primary key — NOT NULL
- proposer_consensus_address — VARBINARY(32)
- block_hash — VARBINARY(32)
- block — JSON
- timestamp — TIMESTAMP
coingecko
- denom — VARCHAR(1000) — Primary key — NOT NULL
- price — BIGINT unsigned
ibc_channels (ibc_channel)
- channel_id — VARCHAR(64) — Primary key — NOT NULL
- status — TINYINT(1) unsigned
- escrow_address — VARBINARY(32)
- chain_id — VARCHAR(255)
ibc_transfers
- sequence — BIGINT unsigned — Primary key — NOT NULL
- status — VARCHAR(100)
- denom — VARCHAR(255)
- amount — VARCHAR(100)
- tx_id_pen — BIGINT unsigned — NOT NULL
- tx_id_com — BIGINT unsigned
- denom_packet — VARCHAR(255)
proposals
- proposal_id — BIGINT unsigned — Primary key — NOT NULL
- proposal — JSON
- status
transaction_addresses_mappers
- tx_id — BIGINT unsigned — Primary key — NOT NULL
- acc_id — BIGINT unsigned — Primary key
transactions
- tx_id — BIGINT unsigned — Primary key
- tx_idx — INT unsigned — Primary key — NOT NULL
- code — INT unsigned
- tx_hash — VARBINARY(32) — NOT NULL — index
- height — BIGINT
- messages — JSON — 맨 첫 번째 messages[0].type을 가져오면 됨
- message_type — VARCHAR(255)
- events — JSON
- gas_wanted — VARCHAR(100)
- gas_used — VARCHAR(100)
- fees — VARCHAR(100)
- memo — VARCHAR(1000)
validator_proposal_votes
- address — VARBINARY(32) — Primary key — NOT NULL
- proposal_id — BIGINT unsigned — Primary key
- vote_option — TINYINT(1) unsigned
- tx_id — BIGINT unsigned
validator_signs
- consensus_address — VARBINARY(32) — Primary key — NOT NULL
- height — BIGINT unsigned — Primary key
validators
- consensus_address — VARBINARY(32) — Primary key — NOT NULL
- address — VARBINARY(32)
- moniker — VARCHAR(70)
- jailed — TINYINT(1) unsigned
- status — TINYINT(1) unsigned
- tokens — VARCHAR(100)
- commission_rate — VARCHAR(100)
- info — JSON