address_current_token_balances

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('address_current_token_balances_id_seq'::regclass)
address_hash bytea 2147483647 null
addresses.hash address_current_token_balances_address_hash_fkeyR
block_number int8 19 null
token_contract_address_hash bytea 2147483647 null
tokens.contract_address_hash address_current_token_balances_token_contract_address_hash_fkeyR
value numeric 131089 null
value_fetched_at timestamp 29,6 null
inserted_at timestamp 29,6 null
updated_at timestamp 29,6 null
old_value numeric 131089 null
token_id numeric 78 null
token_type varchar 255 null

Indexes

Constraint Name Type Sort Column(s)
address_current_token_balances_pkey Primary key Asc id
address_cur_token_balances_index Performance Asc block_number
address_current_token_balances_address_hash_block_number_token_ Performance Asc/Asc/Asc address_hash + block_number + token_contract_address_hash
address_current_token_balances_token_contract_address_hash_inde Performance Asc token_contract_address_hash
address_current_token_balances_token_contract_address_hash_valu Performance Asc/Asc token_contract_address_hash + value
address_current_token_balances_token_id_index Performance Asc token_id
address_current_token_balances_value Performance Asc value
fetched_current_token_balances Must be unique Asc/Asc address_hash + token_contract_address_hash
fetched_current_token_balances_with_token_id Must be unique Asc/Asc/Asc address_hash + token_contract_address_hash + token_id

Relationships