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

# Private Updates

### Table Details

| Property          | Value                        |
| ----------------- | ---------------------------- |
| Table Name        | `canton.raw.private_updates` |
| Table Status      | Production-Ready             |
| Unique Key        | `record_time`, `update_id`   |
| Clustering Key(s) | `to_date("record_time")`     |

### Table Columns

| Column Name                  | Data Type         | Description                                                                                                                                            |
| ---------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| update\_id                   | VARCHAR(16777216) | Unique identifier of this Canton ledger update.                                                                                                        |
| migration\_id                | NUMBER(38,0)      | Identifier of the Canton ledger migration version that produced this event.                                                                            |
| domain\_id                   | VARCHAR(16777216) | Identifier of the Canton synchronizer domain this verdict belongs to.                                                                                  |
| record\_time                 | TIMESTAMP\_NTZ(9) | Time at which this update was recorded by the Canton synchronizer domain.                                                                              |
| finalization\_time           | TIMESTAMP\_NTZ(9) | Timestamp at which the Canton confirmation protocol finalized this transaction's verdict.                                                              |
| submitting\_parties          | VARIANT           | Array of Canton party IDs that submitted this transaction.                                                                                             |
| submitting\_participant\_uid | VARCHAR(16777216) | Identifier of the Canton participant node that submitted this transaction.                                                                             |
| verdict\_result              | VARCHAR(16777216) | Outcome of the Canton confirmation protocol for this transaction (e.g. accepted or rejected).                                                          |
| mediator\_group              | NUMBER(38,0)      | Identifier of the mediator group that coordinated confirmation for this Canton transaction.                                                            |
| transaction\_views           | VARIANT           | Nested view tree of a Canton transaction's verdict: root view indices plus, per view, informees, confirming parties, thresholds, and sub-view indices. |
| block\_number                | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                          |
| block\_timestamp             | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                |
| update\_index                | NUMBER(38,0)      | Sequential index of this update within its containing Canton block.                                                                                    |
| \_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.                                                                                          |