codebase-explorerlisted

# Codebase Explorer Skill Explore and document the Empathy Ledger codebase architecture, data flows, and system relationships. ## Instructions When this skill is invoked, help the user understand: 1. **Database Schema** - Tables, relationships, migrations 2. **Data Flow** - Supabase → Services → API Routes → Components 3. **Service Layer** - Business logic patterns 4. **API Routes** - Endpoints and their purposes 5. **Type Definitions** - Where to find types for each domain 6. **Multi-Tenant Architecture** - How tenant isolation works ## Quick Reference Files ### Database & Types | Domain | Types File | Key Tables | |--------|-----------|-----------| | Users/Profiles | `src/types/database/user-profile.ts` | profiles, profile_settings | | Organizations | `src/types/database/organization-tenant.ts` | organisations, organization_members, tenants | | Projects | `src/types/database/project-management.ts` | projects, project_participants | | Stories/Content | `src/types/database/content-media.ts` | stories, transcripts, media_assets | | Distribution | `src/types/database/story-ownership.ts` | story_distributions, consent_proofs | | Cultural Safety | `src/types/database/cultural-sensitivity.ts` | cultural_safety_moderation | | Locations | `src/types/database/location-events.ts` | locations, events | | Analysis | `src/types/database/analysis-support.ts` | transcript_analysis, themes, quotes | ### Supabase Clients | Client | File | Usage | |--------|------|-------| | Browser |