token_transfers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
transaction_hash bytea 2147483647 null
transactions.hash token_transfers_transaction_hash_fkeyC
log_index int4 10 null
from_address_hash bytea 2147483647 null
addresses.hash token_transfers_from_address_hash_fkeyR
to_address_hash bytea 2147483647 null
addresses.hash token_transfers_to_address_hash_fkeyR
amount numeric 131089 null
token_id numeric 78 null
token_contract_address_hash bytea 2147483647 null
addresses.hash token_transfers_token_contract_address_hash_fkeyR
inserted_at timestamp 29,6 null
updated_at timestamp 29,6 null
block_number int4 10 null
block_hash bytea 2147483647 null
blocks.hash token_transfers_block_hash_fkeyR
amounts _numeric 131089 null
token_ids _numeric 78 null

Indexes

Constraint Name Type Sort Column(s)
token_transfers_pkey Primary key Asc/Asc/Asc transaction_hash + block_hash + log_index
token_transfers_block_number_DESC_log_index_DESC_index Performance Desc/Desc block_number + log_index
token_transfers_block_number_index Performance Asc block_number
token_transfers_from_address_hash_transaction_hash_index Performance Asc/Asc from_address_hash + transaction_hash
token_transfers_to_address_hash_transaction_hash_index Performance Asc/Asc to_address_hash + transaction_hash
token_transfers_token_contract_address_hash_block_number_index Performance Asc/Asc token_contract_address_hash + block_number
token_transfers_token_contract_address_hash_token_id_DESC_block Performance Asc/Desc/Desc token_contract_address_hash + token_id + block_number
token_transfers_token_contract_address_hash_transaction_hash_in Performance Asc/Asc token_contract_address_hash + transaction_hash
token_transfers_token_id_index Performance Asc token_id
token_transfers_transaction_hash_log_index_index Performance Asc/Asc transaction_hash + log_index

Relationships