> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# 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        |