Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| call_type | varchar | 255 | √ | null |
|
|
|||||
| created_contract_code | bytea | 2147483647 | √ | null |
|
|
|||||
| error | varchar | 255 | √ | null |
|
|
|||||
| gas | numeric | 100 | √ | null |
|
|
|||||
| gas_used | numeric | 100 | √ | null |
|
|
|||||
| index | int4 | 10 | null |
|
|
||||||
| init | bytea | 2147483647 | √ | null |
|
|
|||||
| input | bytea | 2147483647 | √ | null |
|
|
|||||
| output | bytea | 2147483647 | √ | null |
|
|
|||||
| trace_address | _int4 | 10 | null |
|
|
||||||
| type | varchar | 255 | null |
|
|
||||||
| value | numeric | 100 | null |
|
|
||||||
| inserted_at | timestamp | 29,6 | null |
|
|
||||||
| updated_at | timestamp | 29,6 | null |
|
|
||||||
| created_contract_address_hash | bytea | 2147483647 | √ | null |
|
|
|||||
| from_address_hash | bytea | 2147483647 | √ | null |
|
|
|||||
| to_address_hash | bytea | 2147483647 | √ | null |
|
|
|||||
| transaction_hash | bytea | 2147483647 | null |
|
|
||||||
| block_number | int4 | 10 | √ | null |
|
|
|||||
| transaction_index | int4 | 10 | √ | null |
|
|
|||||
| block_hash | bytea | 2147483647 | null |
|
|
||||||
| block_index | int4 | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| internal_transactions_pkey | Primary key | Asc/Asc | block_hash + block_index |
| internal_transactions_created_contract_address_hash_index | Performance | Asc | created_contract_address_hash |
| internal_transactions_created_contract_address_hash_partial_ind | Performance | Asc/Desc/Desc/Desc | created_contract_address_hash + block_number + transaction_index + index |
| internal_transactions_from_address_hash_index | Performance | Asc | from_address_hash |
| internal_transactions_from_address_hash_partial_index | Performance | Asc/Desc/Desc/Desc | from_address_hash + block_number + transaction_index + index |
| internal_transactions_to_address_hash_partial_index | Performance | Asc/Desc/Desc/Desc | to_address_hash + block_number + transaction_index + index |
| internal_transactions_transaction_hash_index_index | Performance | Asc/Asc | transaction_hash + index |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| call_has_input | (((type)::text <> 'call'::text) OR (input IS NOT NULL)) |
| call_has_error_or_result | (((type)::text <> 'call'::text) OR ((gas IS NOT NULL) AND (((error IS NULL) AND (gas_used IS NOT NULL) AND (output IS NOT NULL)) OR ((error IS NOT NULL) AND (output IS NULL))))) |
| create_has_init | (((type)::text <> 'create'::text) OR (init IS NOT NULL)) |
| selfdestruct_has_from_and_to_address | (((type)::text <> 'selfdestruct'::text) OR ((from_address_hash IS NOT NULL) AND (gas IS NULL) AND (to_address_hash IS NOT NULL))) |
| create_has_error_or_result | (((type)::text <> 'create'::text) OR ((gas IS NOT NULL) AND (((error IS NULL) AND (created_contract_address_hash IS NOT NULL) AND (created_contract_code IS NOT NULL) AND (gas_used IS NOT NULL)) OR ((error IS NOT NULL) AND (created_contract_address_hash IS NULL) AND (created_contract_code IS NULL) AND (gas_used IS NULL))))) |
| call_has_call_type | (((type)::text <> 'call'::text) OR (call_type IS NOT NULL)) |