addresses

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fetched_coin_balance numeric 100 null
fetched_coin_balance_block_number int8 19 null
hash bytea 2147483647 null
address_coin_balances.address_hash address_coin_balances_address_hash_fkeyR
address_coin_balances_daily.address_hash address_coin_balances_daily_address_hash_fkeyR
address_current_token_balances.address_hash address_current_token_balances_address_hash_fkeyR
address_token_balances.address_hash address_token_balances_address_hash_fkeyR
block_rewards.address_hash block_rewards_address_hash_fkeyC
blocks.miner_hash blocks_miner_hash_fkeyR
decompiled_smart_contracts.address_hash decompiled_smart_contracts_address_hash_fkeyC
internal_transactions.created_contract_address_hash internal_transactions_created_contract_address_hash_fkeyR
internal_transactions.from_address_hash internal_transactions_from_address_hash_fkeyR
internal_transactions.to_address_hash internal_transactions_to_address_hash_fkeyR
logs.address_hash logs_address_hash_fkeyC
smart_contracts.address_hash smart_contracts_address_hash_fkeyC
token_transfers.from_address_hash token_transfers_from_address_hash_fkeyR
token_transfers.to_address_hash token_transfers_to_address_hash_fkeyR
token_transfers.token_contract_address_hash token_transfers_token_contract_address_hash_fkeyR
tokens.contract_address_hash tokens_contract_address_hash_fkeyC
transactions.created_contract_address_hash transactions_created_contract_address_hash_fkeyR
transactions.from_address_hash transactions_from_address_hash_fkeyC
transactions.to_address_hash transactions_to_address_hash_fkeyC
contract_code bytea 2147483647 null
inserted_at timestamp 29,6 null
updated_at timestamp 29,6 null
nonce int4 10 null
decompiled bool 1 null
verified bool 1 null
gas_used int8 19 null
transactions_count int4 10 null
token_transfers_count int4 10 null

Indexes

Constraint Name Type Sort Column(s)
addresses_pkey Primary key Asc hash
addresses_fetched_coin_balance_hash_index Performance Desc/Asc fetched_coin_balance + hash
addresses_fetched_coin_balance_index Performance Asc fetched_coin_balance
addresses_inserted_at_index Performance Asc inserted_at

Relationships