docs: complete Wiki audit — all features documented
Cross-checked every Wiki page against a full feature inventory
and filled the real gaps found:
Features.md — added colony health index, rotating contextual
facts, cover-photo-upload-creates-timeline-event detail, dynamic
weather card + lock-on-hover, neighborhood diagnosis quiz, TNR
projection calculator, public caretaker profile (/u/[id]) as its
own section, follow-a-colony as its own section (infrastructure
ready, no trigger wired up yet), resource-exchange self-interest
block + Available/Wanted terminology, per-notification
mark-as-read + unread badge, and explicit no-background-jobs
framing extended beyond just notifications.
API-Reference.md — added the full 10-type notification reference
table, notify_nearby_caretakers and respond_to_resource_post RPCs,
the thank_action-vs-plain-thanks-insert distinction, and fixed
stale import paths left over from the components/lib
reorganization (lib/storage -> lib/security/storage, etc.).
Database.md, Architecture.md, Home.md, Environment-Setup.md —
corrected the migration count (85 -> 86) after 0086 shipped.
Everything else audited (Security.md's column-level RLS grants,
two-layer rate limiting, MIME allowlist, returnTo protection,
area_alert's fixed template) was already documented from earlier
passes and needed no changes.
Update migration counts (83 -> 85) across Home, Architecture, Database
docs: correct stale numbers and migrate full Notion documentation
Existing pages (Home, Architecture, Database, Security,
API-Reference, Environment-Setup, Roadmap) were corrected against
the live codebase: 26 tables (not 17), 83 migrations (not 75), 21
routes, 19 articles, 9 assistant triggers, plus the false-pin ban
system, per-notification dismiss, and the final security audit
findings that didn't exist when these pages were first written.
Also migrates everything that previously only lived in Notion, per
direct judge feedback that undocumented-on-GitHub content may not
be considered during judging: Product Vision, User Personas, User
Flows, Design Decisions, Visual Identity, UI Design System,
Features (fully detailed, with the reasoning behind every
feature), Content Strategy, Testing, Process Log, Hackathon
Submission, and Behind the Scenes.
Created Database (markdown)