Raw
Contracts
Table Columns
Unique Key:
| Column Name | Data Type | Description |
|---|---|---|
| contract_id | VARCHAR | Unique identifier for the contract |
| evm_address | VARCHAR | EVM address of the contract |
| admin_key | VARIANT | Admin key for the contract |
| memo | VARCHAR | Memo attached to the contract |
| created_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the contract was created |
| expiration_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the contract expires |
| auto_renew_period | BIGINT | Auto-renewal period in seconds |
| auto_renew_account | VARCHAR | Account ID for auto-renewal |
| max_automatic_token_associations | BIGINT | Maximum number of automatic token associations |
| obtainer_id | VARCHAR | Account ID that can obtain the contract |
| proxy_account_id | VARCHAR | Proxy account ID for the contract |
| timestamp_from | TIMESTAMP_NTZ(9) | Start timestamp for the contract’s validity period |
| timestamp_to | TIMESTAMP_NTZ(9) | End timestamp for the contract’s validity period |
| nonce | BIGINT | Nonce of the contract |
| file_id | VARCHAR | File ID containing the contract bytecode |
| deleted | BOOLEAN | Whether the contract has been deleted |
| permanent_removal | BOOLEAN | Whether the contract has been permanently removed |
| bytecode | VARCHAR | Contract bytecode (hex encoded) |
| runtime_bytecode | VARCHAR | Runtime bytecode (hex encoded) |
| created_timestamp_raw | DECIMAL(29,9) | Raw created timestamp as decimal |
| expiration_timestamp_raw | DECIMAL(29,9) | Raw expiration timestamp as decimal |
| timestamp_from_raw | DECIMAL(29,9) | Raw timestamp from as decimal |
| timestamp_to_raw | DECIMAL(29,9) | Raw timestamp to as decimal |
| _ingested_at | TIMESTAMP_NTZ(9) | Timestamp when this record was ingested |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |