proj-wallet

Tables (11)

address_coin_balances (Untitled2)

  • address_hash (hash) — bytea — Foreign key → addresses.hash — NOT NULL
  • block_number (Field) — int8
  • value (Field2) — numeric
  • value_fetched_at (Field3) — timestamp
  • inserted_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

address_token_balances (CopyOfUntitled2)

  • id (Key2) — bigserial — Primary key — NOT NULL
  • block_number (Field) — int8
  • value (Field2) — numeric
  • value_fetched_at (Field3) — timestamp
  • inserted_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • token_id (numeric)
  • address_hash (hash2) — bytea — Foreign key → addresses.hash — NOT NULL
  • token_contract_address_hash (hash) — bytea — Foreign key → tokens.contract_address_hash — NOT NULL

addresses (Untitled)

  • hash — bytea — Primary key — NOT NULL
  • fetched_coin_balance — numeric
  • fetched_coin_balance_block_number (Field5) — int8
  • inserted_at (Field2) — timestamp
  • updated_at (Field3) — timestamp
  • nonce (Field4) — int4
  • contract_code (Field) — bytea
  • verified (Field6) — bool

blocks (Untitled6)

  • hash (Key) — bytea — Primary key — NOT NULL
  • consensus (Field) — bool
  • timestamp (Field2) — timestamp
  • number (Field3) — int8
  • parent_hash (Field4) — bytea

contract_methods (Untitled10)

  • id (Key) — bigserial — Primary key — NOT NULL
  • identifier (Field) — int4
  • abi (Field2) — jsonb
  • type (Field3) — varchar
  • inserted_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

internal_transactions (Untitled9)

  • block_index (Key2) — int4 — Primary key — NOT NULL
  • block_hash (Key) — bytea — Foreign key → blocks.hash — NOT NULL
  • transaction_hash (Key22) — bytea — Foreign key → transactions.hash — NOT NULL
  • from_address_hash (hash) — bytea — Foreign key → addresses.hash — NOT NULL
  • to_address_hash (hash2) — bytea — Foreign key → addresses.hash — NOT NULL
  • created_contract_address_hash (hash3) — bytea — Foreign key → addresses.hash — NOT NULL
  • block_number (Field) — int4
  • transaction_index (Field2) — int4
  • call_type (Field3) — varchar
  • gas (Field4) — numeric
  • gas_used (Field5) — numeric
  • index (Field6) — int4
  • input (Field7) — bytea
  • output (Field8) — bytea
  • inserted_at (Field9) — timestamp
  • updated_at (Field10) — timestamp
  • trace_address (Field11) — _int4
  • type (Field12) — varchar
  • value (Field13) — numeric

logs (Untitled8)

  • index (Key) — int4 — Primary key — NOT NULL
  • block_hash (Key2) — bytea — Foreign key → blocks.hash — NOT NULL
  • transaction_hash (Key22) — bytea — Foreign key → transactions.hash — NOT NULL
  • data (Field) — bytea
  • type (Field2) — varchar
  • first_topic (Field3) — varchar
  • second_topic (Field4) — varchar
  • third_topic (Field5) — varchar
  • fourth_topic (Field6) — varchar
  • inserted_at (Field7) — timestamp
  • updated_at (Field8) — timestamp
  • block_number (Field9) — int4
  • address_hash (hash) — bytea — Foreign key → addresses.hash — NOT NULL

token_instances (Untitled4)

  • token_id (Key2) — numeric — Primary key — NOT NULL
  • token_contract_address_hash (hash) — bytea — Foreign key → tokens.contract_address_hash — NOT NULL
  • metadata (Field) — jsonb
  • inserted_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

token_transfers (Untitled7)

  • log_index (Key) — int4 — Primary key — NOT NULL
  • block_hash (Key2) — bytea — Foreign key → blocks.hash — NOT NULL
  • transaction_hash (Key22) — bytea — Foreign key → transactions.hash — NOT NULL
  • from_address_hash (hash) — bytea — Foreign key → addresses.hash — NOT NULL
  • to_address_hash (hash2) — bytea — Foreign key → addresses.hash — NOT NULL
  • token_contract_address_hash (hash3) — bytea — Foreign key → addresses.hash — NOT NULL
  • amount (Field) — numeric
  • token_id (Field2) — numeric
  • inserted_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • block_number (Field5) — int4
  • amounts (Field6) — _numeric
  • token_ids (Field7) — _numeric

tokens (Untitled3)

  • contract_address_hash (hash) — bytea — Foreign key → addresses.hash — NOT NULL
  • name (Field) — varchar
  • symbol (Field2) — varchar
  • total_supply (Field3) — numeric
  • decimals (Field4) — numeric
  • type (Field7) — varchar
  • inserted_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

transactions (Untitled5)

  • hash (Key2) — bytea — Primary key — NOT NULL
  • block_number (Field) — int4
  • max_priority_fee_per_gas (Field2) — numeric
  • max_fee_per_gas (Field3) — numeric
  • type (Field4) — in4
  • revert_reason (Field5) — text
  • inserted_at (Field6) — timestamp
  • updated_at (Field7) — timestamp
  • value (Field8) — numeric
  • status (Field9) — int4
  • nonce (Field10) — int4
  • input (Field11) — bytea
  • gas_price (Field12) — numeric
  • gas_used (Field13) — numeric
  • gas (Field16) — numeric
  • cumulative_gas_used (Field15) — numeric
  • error (Field14) — varchar
  • from_address_hash (hash2) — bytea — Foreign key → addresses.hash — NOT NULL
  • to_address_hash (hash) — bytea — Foreign key → addresses.hash — NOT NULL
  • created_contract_address_hash (hash3) — bytea — Foreign key → addresses.hash — NOT NULL
  • block_hash (Key) — bytea — Foreign key → blocks.hash — NOT NULL