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