| UPDATE_ID | TEXT | Unique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state. |
| MIGRATION_ID | TEXT | Canton migration identifier. Used to track different phases or migrations in the Canton network’s evolution. |
| RECORD_TIME | TEXT | Timestamp when the update was recorded in the system. |
| EFFECTIVE_AT | TEXT | Timestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events. |
| EVENT_ID | TEXT | Unique identifier for the event within the Canton blockchain. |
| EVENT_INDEX | TEXT | Ordering index of events within an update. Events within the same update are sequentially numbered starting from 0. |
| CHOICE | TEXT | The choice/action/method being executed on a contract. Examples include ‘DsoRules_RequestVote’, ‘AmuletRules_Transfer’, ‘LockedAmulet_Unlock’, etc. |
| ACTING_PARTIES | TEXT | Array of party identifiers who are executing this action/choice. |
| IS_ROOT_EVENT | TEXT | Boolean indicating whether this is a top-level event in the update (as opposed to a child event triggered by a parent event). |
| REQUEST_CID | TEXT | Contract ID for the request being voted on |
| TRACKING_CID | TEXT | Tracking contract ID for the vote request |
| SV | TEXT | Super validator party ID casting the vote |
| ACCEPT | TEXT | Boolean indicating whether vote is to accept (TRUE) or reject (FALSE) |
| OPT_CAST_AT | TEXT | Optional timestamp when vote was cast |
| REASON | TEXT | Reason provided for the vote |
| VOTE_REQUEST_CID | TEXT | Contract ID for a vote request. |
| CONTRACT_ID | TEXT | Unique identifier for the contract being created or exercised in this event. |
| FACT_VOTE_ID | TEXT | Surrogate key generated from event_id |
| INSERTED_TIMESTAMP | TEXT | Timestamp when the record was inserted into this table (Snowflake SYSDATE). |
| MODIFIED_TIMESTAMP | TEXT | Timestamp when the record was last modified in this table (Snowflake SYSDATE). |
