address_token_balances

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('address_token_balances_id_seq'::regclass)
address_hash bytea 2147483647 null
addresses.hash address_token_balances_address_hash_fkeyR
block_number int8 19 null
token_contract_address_hash bytea 2147483647 null
tokens.contract_address_hash address_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
token_id numeric 78 null
token_type varchar 255 null

Indexes

Constraint Name Type Sort Column(s)
address_token_balances_pkey Primary key Asc id
address_token_balances_address_hash_token_contract_address_hash Performance Asc/Asc/Asc address_hash + token_contract_address_hash + block_number
address_token_balances_block_number_address_hash_index Performance Asc/Asc block_number + address_hash
address_token_balances_token_contract_address_hash_index Performance Asc token_contract_address_hash
address_token_balances_token_id_index Performance Asc token_id
fetched_token_balances Must be unique Asc/Asc/Asc address_hash + token_contract_address_hash + block_number
fetched_token_balances_with_token_id Must be unique Asc/Asc/Asc/Asc address_hash + token_contract_address_hash + token_id + block_number
unfetched_token_balances Must be unique Asc/Asc/Asc address_hash + token_contract_address_hash + block_number
unfetched_token_balances_with_token_id Must be unique Asc/Asc/Asc/Asc address_hash + token_contract_address_hash + token_id + block_number

Relationships