Skip to content

Data Definition Document: Community Governance

Domain: Community (governance, occupancy, registry, financials) Logical Sub-Domain: Governance (Decision Making) Physical Packages: @sd/mod-community/governance Related Documents: Process Blueprint Context: This document defines the Data Structures for the Digital Democracy engine. Source: packages/modules/community/src/governance/schema.ts

0. Entity Relationship Diagram (ERD)

erDiagram
    ASSEMBLY ||--o{ PROPOSAL : "contains"
    ASSEMBLY ||--o{ PROXY : "scope"
    PROPOSAL ||--o{ VOTE : "receives"

    %% External Links
    USER ||--o{ PROXY : "grants/receives"
    ASSET ||--o{ VOTE : "provides_weight"

    ASSEMBLY {
        string id PK
        enum type "ordinary, extraordinary"
        float quorumRequirement
        string[] attendees
    }

    PROPOSAL {
        string id PK
        string title_en
        string title_es
        enum type "simple_majority, super_majority"
        json ballotData
    }

    VOTE {
        string id PK
        string assetId FK
        float weight
        string signature
    }

1. Primary Entities

Entity: Proposal

A specific item to be voted upon.

Field Type Required Description
id string Yes Unique ID.
title string Yes English Title.
title_es string Yes Spanish Title (Required).
type string Yes simple_majority (51%), super_majority (75%), etc.
reviewStatus string Yes pending, approved, rejected (Gatekeeper).
vigilanceReview object No Endorsement from the Oversight Committee.
ballotData json No Custom choices (e.g. Candidates list).
votingWindow range No Start/End timestamps for async voting.

Entity: Vote

A cast ballot tied to a property unit.

Field Type Required Description
proposalId string Yes Target Proposal.
assetId string Yes The Unit (Deed) providing the right to vote.
weight float Yes The Indiviso % value at time of vote.
choice string Yes YES, NO, or Candidate ID.
signature string No Cryptographic proof.
isProxyVote boolean Yes True if cast by a delegate.

Entity: Assembly

A formal meeting of owners.

Field Type Required Description
legalType string Yes ordinary (Annual), extraordinary (Special).
quorumRequirement float Yes 0.0 - 1.0 (e.g. 0.51).
minutes string No Official record of the meeting.
validationSnapshot object No Proof of Quorum at start time.

4. Changelog

Date Author Description Reference
2026-01-24 Antigravity Initial creation Implementation Plan

Version History

Version Date Author Change
0.1.0 2026-01-26 Antigravity Initial Audit & Metadata Injection