Contracts

Contracts table records all the smart contracts deployed on the blockchain. Each row represents a unique contract and contains information about its address, creator, creation code, deployed code, and the transaction and block details associated with its deployment.

ETL data class

Column Name	Data Type	Note
address	str
name	str
contract_creator	str
creation_code	str
deployed_code	str
block_number	int
block_hash	str
block_timestamp	timestamp
transaction_index	int
transaction_hash	str
transaction_from_address	str

Examples

{
  "address": "0x7c6ba614a28d505ef254cb888db872763d6f5b85",
  "name": null,
  "contract_creator": "0xb3b41365f9179ac0711727ade3e0879c0aaa273b",
  "creation_code": null,
  "deployed_code": null,
  "block_number": 849291,
  "block_hash": "0xbd334c7a4dcd83d6f85b7cacef214433131cc8098f5014b050b15336fd00d535",
  "block_timestamp": "2023-11-13T09:39:42.000Z",
  "transaction_index": 0,
  "transaction_hash": "0x0a16c572c35fc45e65e8daf28c3d58358566d5b69feb0557272812e22a75e7cc",
  "transaction_from_address": "0xb3b41365f9179ac0711727ade3e0879c0aaa273b"
}

0x7c6ba614a28d505ef254cb888db872763d6f5b85,,0xb3b41365f9179ac0711727ade3e0879c0aaa273b,,,849291,0xbd334c7a4dcd83d6f85b7cacef214433131cc8098f5014b050b15336fd00d535,2023-11-13T09:39:42.000Z,0,0x0a16c572c35fc45e65e8daf28c3d58358566d5b69feb0557272812e22a75e7cc,0xb3b41365f9179ac0711727ade3e0879c0aaa273b

Model in the Database

Column Name	Data Type	Note
address	bytea	primary key
name	varchar
contract_creator	bytea
creation_code	bytea
deployed_code	bytea
block_number	bigint
block_hash	bytea
block_timestamp	timestamp
transaction_index	integer
transaction_hash	bytea
transaction_from_address	bytea
create_time	timestamp	default now()
update_time	timestamp	default now()

\\x7c6ba614a28d505ef254cb888db872763d6f5b85,,\\xb3b41365f9179ac0711727ade3e0879c0aaa273b,,,849291,\\xbd334c7a4dcd83d6f85b7cacef214433131cc8098f5014b050b15336fd00d535,2023-11-13 09:39:42.000000,0,\\x0a16c572c35fc45e65e8daf28c3d58358566d5b69feb0557272812e22a75e7cc,\\xb3b41365f9179ac0711727ade3e0879c0aaa273b,2023-11-13 09:39:42.000000,2023-11-13 09:39:42.000000