Tables


SchemaSpy Analysis of blockscout.public

Generated on Tue Feb 13 19:48 MSK 2024

XML Representation
Insertion Order Deletion Order
TABLES 52
VIEWS 0
COLUMNS 444
Constraints 29
Anomalies 5
Routines 354

Database Properties

Database Type: PostgreSQL - 15.5 (Homebrew)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
token_instances 0 2 9 -1 Table
account_tag_transactions 0 1 7 -1 Table
address_coin_balances 0 0 6 -1 Table
address_tags 1 0 5 -1 Table
contract_methods 0 0 6 -1 Table
logs 0 2 12 -1 Table
account_public_tags_requests 0 1 16 -1 Table
token_transfer_token_id_migrator_progress 0 0 4 -1 Table
token_transfers 0 2 12 -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 0 0 2 -1 Table
pending_block_operations 0 1 4 -1 Table
decompiled_smart_contracts 0 0 6 -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 19 -1 Table
validators 0 0 6 -1 Table
address_to_tags 0 1 5 -1 Table
contract_verification_status 0 0 5 -1 Table
account_api_plans 1 0 5 -1 Table
account_tag_addresses 0 1 7 -1 Table
addresses 0 0 12 -1 Table
account_custom_abis 0 1 8 -1 Table
user_contacts 0 1 7 -1 Table
users 2 0 5 -1 Table
migrations_status 0 0 4 -1 Table
smart_contracts 3 0 25 -1 Table
constants 0 0 4 -1 Table
transaction_actions 0 1 7 -1 Table
event_notifications 0 0 2 -1 Table
tokens 1 0 16 -1 Table
missing_block_ranges 0 0 3 -1 Table
market_history 0 0 6 -1 Table
transactions 5 2 31 -1 Table
internal_transactions 0 4 22 -1 Table
account_watchlist_notifications 0 0 21 -1 Table
schema_migrations 0 0 2 -1 Table
account_watchlists 1 1 5 -1 Table
account_identities 6 1 11 -1 Table
address_token_balances 0 0 10 -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
blocks 9 0 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