Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| transaction_hash | bytea | 2147483647 | null |
|
|
||||||
| log_index | int4 | 10 | null |
|
|
||||||
| from_address_hash | bytea | 2147483647 | null |
|
|
||||||
| to_address_hash | bytea | 2147483647 | null |
|
|
||||||
| amount | numeric | 0 | √ | null |
|
|
|||||
| token_contract_address_hash | bytea | 2147483647 | null |
|
|
||||||
| inserted_at | timestamp | 29,6 | null |
|
|
||||||
| updated_at | timestamp | 29,6 | null |
|
|
||||||
| block_number | int4 | 10 | √ | null |
|
|
|||||
| block_hash | bytea | 2147483647 | null |
|
|
||||||
| amounts | _numeric | 131089 | √ | null |
|
|
|||||
| token_ids | _numeric | 78 | √ | null |
|
|
|||||
| token_type | varchar | 255 | √ | null |
|
|
|||||
| block_consensus | bool | 1 | √ | true |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| token_transfers_pkey | Primary key | Asc/Asc/Asc | transaction_hash + block_hash + log_index |
| token_transfers_block_consensus_index | Performance | Asc | block_consensus |
| token_transfers_block_number_ASC_log_index_ASC_index | Performance | Asc/Asc | block_number + 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_block_number_index | Performance | Asc/Asc | from_address_hash + block_number |
| token_transfers_from_address_hash_transaction_hash_index | Performance | Asc/Asc | from_address_hash + transaction_hash |
| token_transfers_to_address_hash_block_number_index | Performance | Asc/Asc | to_address_hash + block_number |
| token_transfers_to_address_hash_transaction_hash_index | Performance | Asc/Asc | to_address_hash + transaction_hash |
| token_transfers_token_contract_address_hash__block_number_DESC_ | Performance | Asc/Desc/Desc | token_contract_address_hash + block_number + log_index |
| token_transfers_token_contract_address_hash_token_ids_index | Performance | Asc/Asc | token_contract_address_hash + token_ids |
| token_transfers_token_contract_address_hash_transaction_hash_in | Performance | Asc/Asc | token_contract_address_hash + transaction_hash |
| token_transfers_token_type_index | Performance | Asc | token_type |
| token_transfers_transaction_hash_log_index_index | Performance | Asc/Asc | transaction_hash + log_index |