Data model

    Organization Membership And Oversight Model

    The remote schema makes the institutional layer much clearer: organizations connect to memberships, invitations, user profiles, groups, family trees, persons, and donor-recipient operations. That is a stronger SaaS and coordination story than the earlier editorial model captured.

    Family Shapes

    Data model diagram

    Relationships

    A readable index of the 7 connections shown in the visual model above.

    1

    organizations

    Connects to organization_memberships

    2

    organizations

    Connects to organization_invitations

    3

    organizations

    Connects to user_profiles

    4

    organizations

    Connects to groups

    5

    organizations

    Connects to family_trees

    6

    organizations

    Connects to persons

    7

    organizations

    Connects to donor_recipient_connections

    Model details

    Dates

    Created
    Not recorded
    Last updated
    May 17, 2026

    Entities

    organizationsorganization_membershipsorganization_invitationsuser_profilesgroupsfamily_treespersonsdonor_recipient_connections

    Source

    src/types/database.ts

    Open source