Constraints

31 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

token_instances_token_contract_address_hash_fkey

token_instances.token_contract_address_hash

tokens.contract_address_hash

Restrict delete

account_tag_transactions_identity_id_fkey

account_tag_transactions.identity_id

account_identities.id

Cascade on delete

scam_address_badge_mappings_address_hash_fkey

scam_address_badge_mappings.address_hash

Cascade on delete

logs_block_hash_fkey

logs.block_hash

Restrict delete

logs_transaction_hash_fkey

logs.transaction_hash

transactions.hash

Cascade on delete

token_transfers_block_hash_fkey

token_transfers.block_hash

Restrict delete

token_transfers_transaction_hash_fkey

token_transfers.transaction_hash

transactions.hash

Cascade on delete

administrators_user_id_fkey

administrators.user_id

Cascade on delete

transaction_forks_hash_fkey

transaction_forks.hash

transactions.hash

Cascade on delete

transaction_forks_uncle_hash_fkey

transaction_forks.uncle_hash

Cascade on delete

pending_block_operations_block_hash_fkey

pending_block_operations.block_hash

Cascade on delete

signed_authorizations_transaction_hash_fkey

signed_authorizations.transaction_hash

transactions.hash

Cascade on delete

account_api_keys_identity_id_fkey

account_api_keys.identity_id

account_identities.id

Cascade on delete

smart_contracts_additional_sources_address_hash_fkey

smart_contracts_additional_sources.address_hash

smart_contracts.address_hash

Cascade on delete

account_watchlist_addresses_watchlist_id_fkey

account_watchlist_addresses.watchlist_id

account_watchlists.id

Cascade on delete

address_to_tags_tag_id_fkey

address_to_tags.tag_id

address_tags.id

Restrict delete

account_tag_addresses_identity_id_fkey

account_tag_addresses.identity_id

account_identities.id

Cascade on delete

account_custom_abis_identity_id_fkey

account_custom_abis.identity_id

account_identities.id

Cascade on delete

user_contacts_user_id_fkey

user_contacts.user_id

Cascade on delete

transaction_actions_hash_fkey

transaction_actions.hash

transactions.hash

Cascade on delete

transactions_block_hash_fkey

transactions.block_hash

Cascade on delete

internal_transactions_transaction_hash_fkey

internal_transactions.transaction_hash

transactions.hash

Cascade on delete

internal_transactions_block_hash_fkey

internal_transactions.block_hash

Restrict delete

account_watchlists_identity_id_fkey

account_watchlists.identity_id

account_identities.id

Cascade on delete

pending_transaction_operations_transaction_hash_fkey

pending_transaction_operations.transaction_hash

transactions.hash

Cascade on delete

account_identities_plan_id_fkey

account_identities.plan_id

account_api_plans.id

Restrict delete

block_rewards_block_hash_fkey

block_rewards.block_hash

Cascade on delete

block_second_degree_relations_nephew_hash_fkey

block_second_degree_relations.nephew_hash

Restrict delete

proxy_smart_contract_verification_statuses_contract_address_has

proxy_smart_contract_verification_statuses.contract_address_hash

smart_contracts.address_hash

Cascade on delete

withdrawals_block_hash_fkey

withdrawals.block_hash

Cascade on delete

smart_contract_audit_reports_address_hash_fkey

smart_contract_audit_reports.address_hash

smart_contracts.address_hash

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
transactions	collated_block_number	((block_hash IS NULL) OR (block_number IS NOT NULL))
transactions	collated_cumalative_gas_used	((block_hash IS NULL) OR (cumulative_gas_used IS NOT NULL))
transactions	collated_gas_price	((block_hash IS NULL) OR (gas_price IS NOT NULL))
transactions	collated_gas_used	((block_hash IS NULL) OR (gas_used IS NOT NULL))
transactions	collated_index	((block_hash IS NULL) OR (index IS NOT NULL))
transactions	error	((status = 0) OR ((status <> 0) AND (error IS NULL)))
transactions	pending_block_number	((block_hash IS NOT NULL) OR (block_number IS NULL))
transactions	pending_cumalative_gas_used	((block_hash IS NOT NULL) OR (cumulative_gas_used IS NULL))
transactions	pending_gas_used	((block_hash IS NOT NULL) OR (gas_used IS NULL))
transactions	pending_index	((block_hash IS NOT NULL) OR (index IS NULL))
transactions	status	(((block_hash IS NULL) AND (status IS NULL)) OR (block_hash IS NOT NULL) OR ((status = 0) AND ((error)::text = 'dropped/replaced'::text)))
internal_transactions	call_has_call_type	(((type)::text <> 'call'::text) OR (call_type IS NOT NULL))
internal_transactions	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)))))
internal_transactions	call_has_input	(((type)::text <> 'call'::text) OR (input IS NOT NULL))
internal_transactions	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)))))
internal_transactions	create_has_init	(((type)::text <> 'create'::text) OR (init IS NOT NULL))
internal_transactions	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)))