logs

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
data bytea 2147483647 null
index int4 10 null
first_topic bytea 2147483647 null
second_topic bytea 2147483647 null
third_topic bytea 2147483647 null
fourth_topic bytea 2147483647 null
inserted_at timestamp 29,6 null
updated_at timestamp 29,6 null
address_hash bytea 2147483647 null
transaction_hash bytea 2147483647 null
transactions.hash logs_transaction_hash_fkey C
block_hash bytea 2147483647 null
blocks.hash logs_block_hash_fkey R
block_number int4 10 null

Indexes

Constraint Name Type Sort Column(s)
logs_pkey Primary key Asc/Asc/Asc transaction_hash + block_hash + index
logs_address_hash_index Performance Asc address_hash
logs_address_hash_transaction_hash_index Performance Asc/Asc address_hash + transaction_hash
logs_block_number_ASC__index_ASC_index Performance Asc/Asc block_number + index
logs_block_number_DESC__index_DESC_index Performance Desc/Desc block_number + index
logs_first_topic_index Performance Asc first_topic
logs_fourth_topic_index Performance Asc fourth_topic
logs_index_index Performance Asc index
logs_second_topic_index Performance Asc second_topic
logs_third_topic_index Performance Asc third_topic
logs_transaction_hash_index_index Performance Asc/Asc transaction_hash + index

Relationships