Theme

A theme is a top-level subject area (e.g. "Gratitude", "Kindness", "Active April"). Each theme has:

• one expert video — a featured talk that introduces the theme.
• one course — the structured learning track for the theme. See course.
• one forum — the discussion space for the theme.
• optionally one recipe — a sequence of nudges that runs against the theme. See recipe.

Tables

THEME

The theme itself — just an id, a unique name, and a description.

id            thm_01_gratitude
name          Gratitude
description   Noticing and appreciating the good things around you
created_at    2026-03-01T09:00:00Z

EXPERT_VIDEO

The featured talk for the theme. One-to-one with THEME (enforced by the unique FK).

id               vid_01_emmons
theme_id         thm_01_gratitude
video_url        https://videos.afh.example/gratitude-intro.mp4
title            The Science of Gratitude
featured_expert  Prof. Robert Emmons

FORUM

The theme's discussion space. Has a single USER as moderator and a unique slug for URLs.

id            fr_01_gratitude
theme_id      thm_01_gratitude
moderator_id  usr_42_maya
title         Gratitude — community discussion
slug          gratitude