Data model

    Relationship Graph And Access Model

    The linked Supabase schema shows Family Shapes as a graph product with explicit access control. Family trees can belong to groups or organizations, persons join trees through membership rows, connections link people, and collaborator plus invitation tables govern who can work inside a sensitive tree.

    Family Shapes

    Data model diagram

    Relationships

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

    1

    organizations

    Connects to family_trees

    2

    groups

    Connects to family_trees

    3

    family_trees

    Connects to family_tree_members

    4

    family_tree_members

    Connects to persons

    5

    persons

    Connects to connections

    6

    family_trees

    Connects to family_tree_collaborators

    7

    family_trees

    Connects to family_tree_invitations

    Model details

    Dates

    Created
    Not recorded
    Last updated
    May 17, 2026

    Entities

    organizationsgroupsfamily_treesfamily_tree_memberspersonsconnectionsfamily_tree_collaboratorsfamily_tree_invitations

    Source

    src/types/database.ts

    Open source