Database Entity Diagram

Aroostook Agency on Aging — Content Management Entities

Generated: October 26, 2026

9 Entities · All independent (no foreign keys)

Built-in fields on every entity

id (string)created_date (datetime)updated_date (datetime)created_by_id (string)

Service

Service directory listings

Field	Type	Req
title	string
category	enum
audience	enum
description	string
detail_url	string
image_url	string
contact_phone	string
contact_email	string
contact_website	string
tags	string[]
is_featured	boolean

NutritionProgram

Meal program details & accordions

Field	Type	Req
number	number
title	string
summary	string
body_intro	string
meal_options	string
cost_note	string
eligibility_note	string
bullets	string[]
is_active	boolean

HelpCard

"I Need Help" landing page cards

Field	Type	Req
title	string
group	enum
description	string
image_url	string
link_to	string
link_query	string
sort_order	number
is_active	boolean

CaregiverResource

Caregiver support resource cards

Field	Type	Req
title	string
category	enum
description	string
link_label	string
link_url	string
icon	string
sort_order	number

BoardMember

Board of directors profiles

Field	Type	Req
name	string
region	enum
title	string
location	string
bio	string
photo_url	string
sort_order	number

TeamMember

Staff & leadership profiles

Field	Type	Req
name	string
title	string
bio	string
photo_url	string
email	string
phone	string
department	string
sort_order	number

Testimonial

Homepage quote carousel

Field	Type	Req
quote	string
name	string
age_or_role	string
photo_url	string
is_active	boolean
sort_order	number
description	string

Announcement

Sitewide banner announcements

Field	Type	Req
text	string
link_label	string
link_url	string
is_active	boolean

SiteSettings

Key/value config (embeds, URLs, etc.)

Field	Type	Req
key	string
value	string
label	string
type	enum
description	string

Required field

enum — one of a fixed set of values

string[] — array of strings