prv_explorer_v0.1
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)
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 — JSON
- timestamp — TIMESTAMP
coingecko
- denom — VARCHAR(1000) — Primary key — NOT NULL
- price — BIGINT unsigned
ibc
- tx_id — BIGINT unsigned — Primary key — NOT NULL
- status — VARCHAR(100)
- denom — VARCHAR(255)
- amount — VARCHAR(100)
ibc_channel
- channel_id — VARCHAR(64) — Primary key — NOT NULL
- state — TINYINT(1) unsigned
- escrow_address — VARBINARY(32)
- chain_id — VARCHAR(255)
map_transaction_address
- tx_id — VARCHAR(64) — Primary key — NOT NULL
- acc_id — VARBINARY(32) — Primary key
proposals
- proposal_id — BIGINT unsigned — Primary key — NOT NULL
- proposal — JSON
transactions
- tx_id — BIGINT unsigned — Primary key
- tx_idx — INT unsigned — Primary key — NOT NULL
- code — INT unsigned
- tx_hash — VARCHAR(64) — NOT NULL — index
- height — BIGINT
- messages — JSON — 맨 첫 번째 messages[0].type을 가져오면 됨
- message_type — VARCHAR(255)
- events — JSON
- gas_wanted — VARCHAR(100)
- gas_used — VARCHAR(100)
validators
- consensus_address — VARBINARY(32) — Primary key — NOT NULL
- address — VARBINARY(32)
- moniker — VARCHAR(70)
- jailed — TINYINT(1) unsigned
- status — TINYINT(1) unsigned
- voting_power — VARCHAR(100)
- tokens — VARCHAR(100)
- commission_rate — VARCHAR(100)
- info — JSON
validators_bak
- consensus_address — VARBINARY(32) — Primary key — NOT NULL
- address — VARBINARY(32)
- moniker — VARCHAR(70)
- details — VARCHAR(280)
- commission_rate — VARCHAR(100)
- commission_max_rate — VARCHAR(100)
- commission_max_change_rate — VARCHAR(100)
- commission_update_time — TIMESTAMP
- min_self_delegation — VARCHAR(100)
- voting_power — VARCHAR(100)
- jailed — TINYINT(1) unsigned
- status — TINYINT(1) unsigned
- tokens — VARCHAR(100)
- delegator_shares — VARCHAR(100)
- security_contact — VARCHAR(140)
- website — VARCHAR(140)
- identity — VARCHAR(3000)
- unbonding_height — VARCHAR(100)
- unbonding_time — TIMESTAMP
- validator_bond_shares — VARCHAR(100)
- liquid_shares — VARCHAR(100)
validators_proposal_vote
- consensus_address — VARBINARY(32) — Primary key — NOT NULL
- proposal_id — BIGINT unsigned — Primary key
- vote_option — VARCHAR(100)
- tx_id — BIGINT unsigned
validators_sign
- consensus_address — VARBINARY(32) — Primary key — NOT NULL
- height — BIGINT unsigned — Primary key