Tables


SchemaSpy Analysis of blockscout

Generated on Wed Jun 22 19:19 GMT 2022

XML Representation
Insertion Order Deletion Order
TABLES 30
VIEWS 0
COLUMNS 258
Constraints 37
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 12.8

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
token_instances 0 1 6 0 Table
address_coin_balances 0 1 6 3 Table
tokens 3 1 11 0 Table
contract_methods 0 0 6 0 Table
logs 0 3 13 0 Table
market_history 0 0 4 367 Table
transactions 4 4 29 1 Table
internal_transactions 0 5 22 1 Table
token_transfers 0 5 13 0 Table
schema_migrations 0 0 2 153 Table
administrators 0 1 5 0 Table
transaction_forks 0 2 5 0 Table
address_coin_balances_daily 0 1 5 3 Table
pending_block_operations 0 1 4 1 Table
emission_rewards 0 0 2 0 Table
address_token_balances 0 2 10 0 Table
block_rewards 0 2 6 0 Table
decompiled_smart_contracts 0 1 6 0 Table
address_names 0 0 6 0 Table
block_second_degree_relations 0 1 4 0 Table
smart_contracts_additional_sources 0 1 6 0 Table
contract_verification_status 0 0 5 0 Table
blocks 8 1 17 3 Table
address_current_token_balances 0 2 11 0 Table
addresses 19 0 12 2 Table
user_contacts 0 1 7 0 Table
transaction_stats 0 0 5 10 Table
users 2 0 5 0 Table
smart_contracts 1 1 21 0 Table
last_fetched_counters 0 0 4 1 Table