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