Tables


SchemaSpy Analysis of blockscout.public

Generated on Fri Oct 24 15:45 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 63
VIEWS 0
COLUMNS 521
Constraints 31
Anomalies 7
Routines 0

Database Properties

Database Type: PostgreSQL - 17.4 (Homebrew)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
token_instances 0 2 17 -1 Table
address_coin_balances 0 0 6 -1 Table
account_tag_transactions 0 1 8 -1 Table
scam_address_badge_mappings 0 1 3 -1 Table
address_tags 1 0 5 -1 Table
contract_methods 0 0 6 -1 Table
logs 0 2 12 -1 Table
token_instance_metadata_refetch_attempts 0 0 5 -1 Table
token_transfer_token_id_migrator_progress 0 0 4 -1 Table
token_transfers 0 2 14 -1 Table
multichain_search_db_export_counters_queue 0 0 6 -1 Table
administrators 0 1 5 -1 Table
transaction_forks 0 2 5 -1 Table
address_coin_balances_daily 0 0 5 -1 Table
emission_rewards 1 0 2 -1 Table
pending_block_operations 0 1 4 -1 Table
signed_authorizations 0 1 12 -1 Table
account_api_keys 0 1 5 -1 Table
address_names 0 0 7 -1 Table
smart_contracts_additional_sources 0 1 6 -1 Table
account_watchlist_addresses 0 1 22 -1 Table
internal_transactions_delete_queue 0 0 3 -1 Table
validators 0 0 6 -1 Table
address_to_tags 0 1 5 -1 Table
contract_verification_status 0 0 5 -1 Table
multichain_search_db_export_token_info_queue 0 0 6 -1 Table
account_api_plans 1 0 5 -1 Table
account_tag_addresses 0 1 8 -1 Table
addresses 1 0 12 -1 Table
account_custom_abis 0 1 9 -1 Table
multichain_search_db_main_export_queue 0 1 6 -1 Table
user_contacts 0 1 7 -1 Table
users 2 0 5 -1 Table
address_contract_code_fetch_attempts 0 0 4 -1 Table
migrations_status 0 0 5 -1 Table
smart_contracts 3 0 27 -1 Table
missing_balance_of_tokens 0 0 5 -1 Table
constants 0 0 4 -1 Table
multichain_search_db_export_balances_queue 0 0 8 -1 Table
transaction_actions 0 1 7 -1 Table
event_notifications 0 0 4 -1 Table
tokens 1 0 19 -1 Table
missing_block_ranges 0 0 4 -1 Table
market_history 0 0 7 -1 Table
transactions 7 2 31 -1 Table
internal_transactions 0 4 22 -1 Table
account_watchlist_notifications 0 0 21 -1 Table
schema_migrations 0 0 2 322 Table
account_watchlists 1 1 5 -1 Table
pending_transaction_operations 0 1 3 -1 Table
account_identities 5 1 10 -1 Table
massive_blocks 1 0 3 -1 Table
address_token_balances 0 0 12 -1 Table
block_rewards 0 1 6 -1 Table
block_second_degree_relations 0 2 4 -1 Table
proxy_smart_contract_verification_statuses 0 1 5 -1 Table
proxy_implementations 0 0 8 -1 Table
blocks 9 1 17 -1 Table
address_current_token_balances 0 0 11 -1 Table
withdrawals 5 1 7 -1 Table
transaction_stats 0 0 5 -1 Table
smart_contract_audit_reports 0 1 15 -1 Table
last_fetched_counters 0 0 4 -1 Table