feat: add "無任職" position option to registration form

feat: implement two-step registration form with teacher profile fields

fix: add fallback password for server-side auth validation

support additional teacher registration information

feat: add help icon buttons with info modals on dashboard

feat: defer coach selection to ad prompt with two-step UI

add retry logic and health check for database clients

revise evaluation to be generic

revise evaluation prompt

support updating evaluation prompt in UI

refine evaluation and fix CSV download problem

support evaluating coach direct prompt

support conversation evaluation

support admin login page

support admin login page

fix: resolve 404 error when branching from new messages

make conversation query more friendly

prevent conversation N+1 query

prevent conversation N+1 query

prevent conversation N+1 query

tune performance

fix: Prevent Supabase connection pool exhaustion in health endpoint

fix: Improve Supabase connection handling and fix health endpoint schema errors

security: Remove production credentials from repository

fix: Fix PostgreSQL compatibility issues in GROUP BY queries

Add supabase support (#3)

update student prompt: 小許、阿杰

Update coach prompt to 20251030v3

fix incorrect field problem

fix logic to detect snake case

fix admin conversation UI problem

fix: Use database-backed PromptService in /api/personalities endpoint

fix scripts for new prompts

revise coach prompt

revise student prompt

feat: Add database-backed prompt management system with repository pattern

feat: Add admin dashboard with stats bug fix and performance improvements

fix: Implement atomic SQL operations to prevent race conditions

fix: Fix SQLite boolean bug and separate API tests from UI tests

refactor: Remove studentName/coachName from database, derive from templates

feat: Add system messages API and comprehensive API documentation

feat: Add response ID expiration handling for OpenAI Responses API

refactor: Adopt OpenAI Responses API for conversation continuity and improve test reliability

feat: Migrate from file-based storage to SQLite with Supabase-compatible interface

feat: Add coach advertising prompt after 15 student messages

feat: Add ADHD-specific characteristics to all student personalities (grades 1-9)

feat: Add comprehensive Basic Auth and enhance prompts with developmental theory

feat: Add graceful degradation for removed student templates

feat: Add quoted reply feature with enhanced speaker context

test: Add comprehensive E2E tests and backend verification script