Wondermind App Database 365

This repository contains a simple SQLite schema and seed generator for a 365-day wellness app database. It creates content for:

• reflections
• audio exercises
• habit trackers

Included files

• schema.sql – database schema
• seed.py – seed generator for 365 days of content
• .gitignore – ignores generated database files

Usage

Generate a fresh SQLite database named wondermind.db:

python seed.py

Customize the generated dataset:

python seed.py --db my_wondermind.db --start-date 2026-09-10 --days 365

Database schema

The schema includes four tables:

• days — one row per day with a date label
• reflections — prompt-based reflection entries
• audio_exercises — guided audio practice entries
• habit_trackers — daily habit check-in content

Example query

SELECT d.date_label, r.title, a.title, h.name
FROM days d
LEFT JOIN reflections r ON r.day_number = d.day_number
LEFT JOIN audio_exercises a ON a.day_number = d.day_number
LEFT JOIN habit_trackers h ON h.day_number = d.day_number
LIMIT 10;