pilot

Tables (5)

Blocks (blocks)

  • Number (number) — numeric — Primary key — NOT NULL
  • Hash (hash) — bytea
  • Parent Hash (parent_hash) — bytea
  • Gas Limit (gas_limit) — numeric
  • Gas Used (gas_used) — numeric
  • Miner (miner) — bytea
  • Difficulty (difficulty) — numeric
  • Total Difficulty (total_difficulty) — numeric
  • Nonce (nonce) — bytea
  • Size (size) — numeric
  • Base Fee Per Gas (base_fee_per_gas) — numeric
  • Time (time) — timestamp without timezone

Comments (comments)

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Field (block_id)
  • Field3 (ref)
  • Field4 (step)
  • Field5 (ref_order)
  • Field (answer_num)
  • Field2 (parent_num)

Cursor (cursor)

  • Key (id) — Primary key — NOT NULL
  • Field (cursor_string)
  • Field2 (table_name)
  • Field (column_comb)

Transactions (transactions)

  • Block Number (block_number) — bigint
  • Index (index) — numeric
  • Block Time (block_time) — timestamp without timezone
  • Nonce (nonce) — numeric
  • Hash (hash) — bytea
  • Success (success) — boolean
  • From (from) — bytea
  • To (to) — bytea
  • Value (value) — numeric
  • Block Hash (block_hash) — bytea
  • Gas Limit (gas_limit) — numeric
  • Gas Price (gas_price) — numeric
  • Gas Used (gas_used) — numeric
  • Data (data) — bytea
  • Type (type) — text
  • Access List (access_list) — jsonb
  • Max Fee Per Gas (max_fee_per_gas) — numeric
  • Max Priority Fee Per Gas (max_priority_fee_per_gas) — numeric
  • Priority Fee Per Gas (priority_fee_per_gas) — numeric

User (user)

  • Key (id) — Primary key — NOT NULL