Data Schema

Interactive visualization of the complete database schema with tables, fields, and relationships

Data Model Schema

20 tables • 28 relationships • Click any table to view details

Core Entities

Relationships

Communication

Operations

Reference Data

Core Entities

(7)

Relationships

(3)

Communication

(3)

Operations

(3)

Reference Data

(4)

Core Entities

people

All constituents: donors, volunteers, board members, alumni, event attendees

Relationships

Fields (14)

id

Id<"people">

first_name

string

last_name

string

emailsarray

Multiple emails supported

string

primary_email

string

phoneoptional

string

addressoptional

Address

donor_type

individual | corporate | foundation

enum

is_donor

boolean

is_volunteer

boolean

is_board_member

boolean

total_lifetime_giving

Calculated, updated on donation

number

first_gift_dateoptional

number

last_gift_dateoptional

number

Core Entities:7

Relationships:3

Communication:3

Operations:3

Reference Data:4

Total:20 tables