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