Data model

    Aerial — connected records and permission boundaries

    I keep the relationship graph, institutional source records, and permission grants distinct so a visible aggregate never implies access to every identity or document.

    Aerial

    Data model diagram

    Relationships

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

    1

    Person

    Connects to Canvas membership

    2

    Canvas membership

    Connects to Canvas

    3

    Family group

    Connects to Person

    4

    Household donor link

    Connects to Person

    5

    Household donor link

    Connects to Donor profile

    6

    Donor profile

    Connects to Institutional record

    7

    Institutional record

    Connects to Source version

    8

    Audience and case grants

    Connects to Authorized projection

    9

    Source version

    Connects to Authorized projection

    10

    Person

    Connects to Authorized projection

    11

    Authorized projection

    Connects to Human evidence review

    12

    Human evidence review

    Connects to Decision and rationale

    Model details

    Dates

    Added
    Sep 14, 2026
    Work date
    Date unknown
    Page edited
    Not recorded

    Entities

    personcanvascanvas_memberhousehold_grouphousehold_donor_linkdonor_profileinstitution recordsource versionsharing grantreview decision

    Source

    lib/db/schema.ts; lib/db/clinic-review-schema.ts; DOCS/FEATURE_MATRIX.md

    Open source