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)

latest_heights

  • height

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