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 | Beta 🌱 |
| 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. |