logs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
data bytea 2147483647 null
index int4 10 null
type varchar 255 null
first_topic varchar 255 null
second_topic varchar 255 null
third_topic varchar 255 null
fourth_topic varchar 255 null
inserted_at timestamp 29,6 null
updated_at timestamp 29,6 null
address_hash bytea 2147483647 null
addresses.hash logs_address_hash_fkeyC
transaction_hash bytea 2147483647 null
transactions.hash logs_transaction_hash_fkeyC
block_hash bytea 2147483647 null
blocks.hash logs_block_hash_fkeyR
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_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
logs_type_index Performance Asc type

Relationships