Skip to main content
Schema: canton.gov Table: fact_vote_requests Type: Incremental

​
Description

Tracks DSO governance vote requests/proposals through DsoRules_RequestVote events. Captures proposals for various DSO actions including granting featured app rights, updating rules, and other governance decisions.

​
Key Use Cases

  • Monitoring governance proposals and voting activity
  • Analyzing proposal types and actions being requested
  • Tracking requester patterns and proposal timing
  • Understanding governance participation

​
Important Relationships

  • Parent table to gov__fact_votes (proposals receive votes)
  • Links to gov__fact_vote_results via vote_request_cid
  • Action details drive governance changes

​
Commonly-used Fields

  • requester: Party proposing the vote
  • target_effective_at: When proposal should take effect
  • vote_timeout_microseconds: How long voting is open
  • action: High-level action tag
  • dso_action: Specific DSO action if applicable
  • amulet_rules_action: Specific amulet rules action if applicable
  • reason_body: Explanation of the proposal
  • reason_url: URL with more details
  • vote_request_cid: Contract ID of the vote request

​
Columns

Column NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state.
MIGRATION_IDTEXTCanton migration identifier. Used to track different phases or migrations in the Canton network’s evolution.
RECORD_TIMETEXTTimestamp when the update was recorded in the system.
EFFECTIVE_ATTEXTTimestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events.
EVENT_IDTEXTUnique identifier for the event within the Canton blockchain.
EVENT_INDEXTEXTOrdering index of events within an update. Events within the same update are sequentially numbered starting from 0.
CHOICETEXTThe choice/action/method being executed on a contract. Examples include ‘DsoRules_RequestVote’, ‘AmuletRules_Transfer’, ‘LockedAmulet_Unlock’, etc.
ACTING_PARTIESTEXTArray of party identifiers who are executing this action/choice.
REQUESTERTEXTParty identifier for the party requesting a governance action or vote.
TARGET_EFFECTIVE_ATTEXTTarget timestamp for when a governance action should become effective.
VOTE_TIMEOUT_MICROSECONDSTEXTDuration in microseconds for how long voting remains open.
ACTIONTEXTHigh-level action tag for a governance proposal.
DSO_ACTIONTEXTSpecific DSO-related action being proposed.
DSO_ACTION_VALUETEXTJSON value containing details of the DSO action.
AMULET_RULES_ACTIONTEXTSpecific amulet rules action being proposed.
AMULET_RULES_VALUETEXTJSON value containing details of the amulet rules action.
REASON_BODYTEXTText body explaining the reason for an action.
REASON_URLTEXTURL providing additional information or justification for an action.
VOTE_REQUEST_CIDTEXTContract ID for a vote request.
CONTRACT_IDTEXTUnique identifier for the contract being created or exercised in this event.
FACT_VOTE_REQUEST_IDTEXTSurrogate key generated from event_id
INSERTED_TIMESTAMPTEXTTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTEXTTimestamp when the record was last modified in this table (Snowflake SYSDATE).