smart_contracts

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('smart_contracts_id_seq'::regclass)
name varchar 255 null
compiler_version varchar 255 null
optimization bool 1 null
contract_source_code text 2147483647 null
abi jsonb 2147483647 √ null
address_hash bytea 2147483647 null
proxy_smart_contract_verification_statuses.contract_address_hash proxy_smart_contract_verification_statuses_contract_address_has C
smart_contract_audit_reports.address_hash smart_contract_audit_reports_address_hash_fkey C
smart_contracts_additional_sources.address_hash smart_contracts_additional_sources_address_hash_fkey C
inserted_at timestamp 29,6 null
updated_at timestamp 29,6 null
constructor_arguments text 2147483647 √ null
optimization_runs int8 19 √ null
evm_version varchar 255 √ null
external_libraries _jsonb 2147483647 √ ARRAY[]::jsonb[]
verified_via_sourcify bool 1 √ null
is_vyper_contract bool 1 √ null
partially_verified bool 1 √ null
file_path text 2147483647 √ null
is_changed_bytecode bool 1 √ false
bytecode_checked_at timestamp 29,6 √ ((now() AT TIME ZONE 'utc'::text) - '1 day'::interval)
contract_code_md5 varchar 255 null
compiler_settings jsonb 2147483647 √ null
verified_via_eth_bytecode_db bool 1 √ null
license_type int2 5 1
verified_via_verifier_alliance bool 1 √ null
certified bool 1 √ null
is_blueprint bool 1 √ null
language int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
smart_contracts_pkey Primary key Asc id
smart_contracts_address_hash_index Must be unique Asc address_hash
smart_contracts_certified_index Performance Asc certified
smart_contracts_contract_code_md5_index Performance Asc contract_code_md5
smart_contracts_trgm_idx Performance

Relationships

Close relationships within degrees of separation