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

# Inputs

Canton uses a UTXO model where each CC balance is an Amulet contract (like a physical banknote). The inputs table records Amulet contracts consumed (destroyed) during a transfer. When a party sends CC, their existing Amulet UTXO is archived as an input; new Amulet UTXOs are then created as outputs. Inputs also include `Amulet_Expire` rows — amulets garbage-collected by super validators when their value has fully decayed via the ExpiringAmount holding fee mechanism.

### Table Details

| Property            | Value                      |
| ------------------- | -------------------------- |
| Table Name          | `canton.raw.inputs`        |
| Table Status        | Production-Ready           |
| Unique Key          | `record_time`, `unique_id` |
| Clustering Key(s)   | `to_date("record_time")`   |
| Search Optimization | `owner`                    |

### Table Columns

| Column Name      | Data Type         | Description                                                                                                                                                                       |
| ---------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| unique\_id       | VARCHAR(16777216) | Unique row identifier, derived from event\_id and the input index.                                                                                                                |
| update\_id       | VARCHAR(16777216) | The update (transaction) this input belongs to. Foreign key to `canton.raw.updates`.                                                                                              |
| event\_id        | VARCHAR(16777216) | The event that consumed this Amulet UTXO. Foreign key to `canton.raw.events`.                                                                                                     |
| record\_time     | TIMESTAMP\_NTZ(9) | The timestamp at which the synchronizer sequenced the parent update.                                                                                                              |
| migration\_id    | NUMBER(38,0)      | Synchronizer migration epoch. Canton upgrades increment this value (currently 0–4). The active migration\_id must match the time range being queried.                             |
| choice           | VARCHAR(16777216) | The Daml choice that consumed this Amulet UTXO (e.g., `AmuletRules_Transfer`, `AmuletRules_BuyMemberTraffic`, `Amulet_Expire`).                                                   |
| owner            | VARCHAR(16777216) | The party that held this Amulet UTXO, formatted as `display_name::hash`. A single entity may have multiple parties with the same hash — filter by hash portion for full coverage. |
| amount\_str      | VARCHAR(16777216) | The CC amount of this Amulet UTXO as a string, preserving full decimal precision (e.g., `"50.7000000000"`). May be in scientific notation for very small values.                  |
| amount           | FLOAT             | The CC amount of this Amulet UTXO as a float. Use amount\_str for accounting to avoid floating-point precision loss.                                                              |
| block\_number    | NUMBER(38,0)      | Synthetic 1-second block index inherited from the parent update.                                                                                                                  |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Start timestamp of the synthetic 1-second block window for this input.                                                                                                            |
| \_created\_at    | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                                                                          |
| \_updated\_at    | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                                                                     |