| event_id | VARCHAR(16777216) | Unique identifier for this event, formatted as update_id:index (e.g., 1220d1ae...b412df:2). The index suffix indicates position within the update’s event tree. |
| event_index | NUMBER(38,0) | Sequential index of this event within the update, derived from the event_id suffix. |
| event_type | VARCHAR(16777216) | Type of event: created_event (a new Daml contract was created) or exercised_event (a choice was exercised on an existing contract). |
| update_id | VARCHAR(16777216) | The update (transaction) this event belongs to. Foreign key to canton.raw.updates. |
| record_time | TIMESTAMP_NTZ(9) | The timestamp at which the synchronizer sequenced the parent update. Inherited from the 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. |
| contract_id | VARCHAR(16777216) | The Daml contract this event acts on. For exercised_event, the contract being acted on. For created_event, the newly created contract. |
| template_id | VARCHAR(16777216) | The Daml template of the contract, formatted as package_hash:Module.Path:TemplateName. Identifies the contract type (e.g., Splice.Amulet:Amulet, Splice.Round:OpenMiningRound). |
| package_name | VARCHAR(16777216) | Human-readable Daml package name (e.g., splice-amulet, splice-dso-governance, splice-wallet). |
| interface_id | VARCHAR(16777216) | The Daml interface used when exercising the choice, if applicable. Non-null when the caller used an interface rather than the template directly (e.g., Splice.Api.Token.TransferInstructionV1:TransferFactory). |
| choice | VARCHAR(16777216) | The name of the Daml choice exercised (exercised_event only). For example, AmuletRules_Transfer, AmuletRules_BuyMemberTraffic, Archive. |
| consuming | BOOLEAN | Whether exercising the choice archived (destroyed) the source contract. True for transfers that consume a UTXO; false for read-only or rules-contract choices. |
| acting_parties | VARIANT | Array of parties that authorized this choice exercise. |
| signatories | VARIANT | Array of parties that signed the contract (for created_event) or must consent to its creation. |
| observers | VARIANT | Array of parties that can observe this contract but are not signatories. |
| create_arguments | VARIANT | The constructor arguments of the created contract (created_event only). Contains the full contract payload including owner, amounts, and metadata. |
| choice_argument | VARIANT | The arguments passed to the exercised choice (exercised_event only). Contains what the caller requested, including sender, receiver, amount, and metadata. |
| exercise_result | VARIANT | The return value of the exercised choice (exercised_event only). For AmuletRules_Transfer, contains the TransferSummary with accounting details (inputAmuletAmount, senderChangeAmount, amuletPrice, etc.). |
| event_address | VARCHAR(16777216) | Dotted path showing this event’s position in the update’s event tree (e.g., null for root, "0" for first child of root, "0,0" for first grandchild). Used to reconstruct the call tree. |
| parent_event_id | VARCHAR(16777216) | The event_id of the parent event in the tree. Null for root events. |
| 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 event. |
| contract_created_at | TIMESTAMP_NTZ(9) | For exercised_event, the record_time when this contract was originally created. Useful for computing contract lifetime. |
| child_event_ids | VARIANT | Array of event_ids that are direct children of this event in the tree. Follow these to traverse the full call tree. |
| child_event_count | NUMBER(38,0) | Number of direct child events triggered by this event. |
| output_count | NUMBER(38,0) | For AmuletRules_Transfer events, the number of transfer outputs (receiver Amulets created). Used for structural validation. |
| _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. |
