| 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. |
| REQUEST_CID | TEXT | Generic contract ID for a request. |
| AMULET_RULES_CID | TEXT | Contract ID for an AmuletRules contract. |
| CLOSING_SV | TEXT | Party identifier for the super validator closing a vote. |
| OUTCOME | TEXT | Result of a vote: typically ‘VRO_Accepted’ or ‘VRO_Rejected’. |
| OUTCOME_EFFECTIVE_AT | TEXT | Timestamp when a vote outcome becomes effective. |
| COMPLETED_AT | TEXT | Timestamp when voting was completed and closed. |
| ACCEPTED_SVS | TEXT | Array of super validator party IDs who voted to accept a proposal. |
| REJECTED_SVS | TEXT | Array of super validator party IDs who voted to reject a proposal. |
| ABSTAINING_SVS | TEXT | Array of super validator party IDs who abstained from voting. |
| OFFBOARDED_VOTERS | TEXT | Array of voter party IDs who were offboarded before voting completed. |
| TRACKING_CID | TEXT | Contract ID used for tracking a request through its lifecycle. |
| REQUESTER | TEXT | Party identifier for the party requesting a governance action or vote. |
| TARGET_EFFECTIVE_AT | TEXT | Target timestamp for when a governance action should become effective. |
| VOTE_BEFORE | TEXT | Timestamp by which votes must be cast. |
| ACTION | TEXT | High-level action tag for a governance proposal. |
| DSO_ACTION | TEXT | Specific DSO-related action being proposed. |
| AMULET_RULES_ACTION | TEXT | Specific amulet rules action being proposed. |
| DSO_ACTION_VALUE | TEXT | JSON value containing details of the DSO action. |
| AMULET_RULES_VALUE | TEXT | JSON value containing details of the amulet rules action. |
| REASON_BODY | TEXT | Text body explaining the reason for an action. |
| REASON_URL | TEXT | URL providing additional information or justification for an action. |
| TOTAL_VOTES_CAST | TEXT | Total number of votes cast on a proposal. |
| ABSTAINING_COUNT | TEXT | Count of validators who abstained from voting. |
| OFFBOARDED_COUNT | TEXT | Count of validators who were offboarded before voting completed. |
| ACCEPT_VOTES | TEXT | Count of votes to accept a proposal. |
| REJECT_VOTES | TEXT | Count of votes to reject a proposal. |
| CONTRACT_ID | TEXT | Unique identifier for the contract being created or exercised in this event. |
| FACT_VOTE_RESULT_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). |
| EVENT_JSON | TEXT | Full JSON object containing all event data. Useful for detailed analysis and accessing fields not explicitly extracted. |
