# Graph Report - /var/www/360lm  (2026-07-17)

## Corpus Check
- cluster-only mode — file stats not available

## Summary
- 5245 nodes · 5302 edges · 677 communities (404 shown, 273 thin omitted)
- Extraction: 98% EXTRACTED · 2% INFERRED · 0% AMBIGUOUS · INFERRED: 111 edges (avg confidence: 0.84)
- Token cost: 0 input · 0 output

## Graph Freshness
- Built from commit: `5c18283b`
- Run `git rev-parse HEAD` and compare to check if the graph is stale.
- Run `graphify update .` after code changes (no API cost).

## Community Hubs (Navigation)
- _
- _
- brevo_domain_auth.js
- Module Design Document — Recce PWA (Field Branding Inspection)
- Module Design Document — Client Portal PWA (`/recce-client/`)
- Module Design Document — CounterManagement mini-PWA
- Module Design Document — HR Management PWA
- Module Design Document — Vehicle Log PWA
- Module Design Document — Admin PWA
- BTL Offers — Gift Claim Portal PWA
- VCC Pre-Build Checklist
- Video Tutorial DevGuide
- UPI Pay Index HTML
- ADR-085 — File Upload Patterns: CSV Import, PDF Export, and Bulk Data Handling
- ADR-066 Parallel CLI Session Coordination with Conflict Zone Locking
- Module Design Document — OC Contact Import Admin
- Module Design Document — Rent Vehicle Expense PWA
- Customer Management PWA
- Feature Inventory
- ADR-112: lm360-session Is the Single Canonical Session — Every PWA Mirrors To It on Login, and Every PWA Exposes an Always-Visible Logout
- ADR-073: Traefik Docker Label Conventions and Middleware Chaining
- ADR-084: List Pagination and Infinite Scroll — When to Use Each, PostgREST Range Header Pattern
- HTML structure for HR Management PWA
- Module Design Document — Learning Hub PWA
- ADR-088: IndexedDB Schema Versioning and Safe Upgrade Protocol
- ADR-078: Paperclip AI Platform Isolation — Separate DB Role, Zero lm360 Access, Independent Backups
- ADR-097 Blogsmith AI Content Pipeline — Keyword to Published Article (Standalone App)
- NORMALIZATION RULES
- Module Design Document — Vehicle Requisition Slip (VRS)
- 360LM Admin PWA
- appsCall
- SCENE LIST (21 scenes — one per screenshot, in order)
- Recce Portal — End-to-End Walkthrough
- Module Design Document — CustomerManagement mini-PWA
- VideoSmith — Build Plan and Architecture
- ADR-071: Indian Number Formatting for All Monetary Amount Inputs
- ADR-080: Hub as Authoritative Session Registry — Cross-Schema Active-State Sync Architecture
- 4. DB schema: `custodian.*`
- Hub PWA
- Tour Planner PWA
- ADR-067: Cross-PWA Change Safety Gate — Explicit Confirmation Before Shared Infrastructure Changes
- PWA Dev Style Guide (Master Build Reference)
- sales.invoices (schema)
- ADR-089: Bilingual EN/HI Platform Architecture — DB-Backed Language Preference, t() Helper, and Adoption Checklist
- Bilingual EN/HI — DevGuide for 360LM PWAs
- Learning Hub PWA
- ADR-083: Form Validation Strategy — Client-Side Feedback, Server-Side Enforcement
- ADR-093: Zero-Backend Standalone PWA — localStorage-Only State with Client-Side PIN Guard
- 360LM Architecture Decision Wiki
- package.json
- 19. Report Generation & Google Slides (GAS)
- WIKI.md
- ADR-086: Isolated PWA Architecture — When to Build Standalone Apps with Zero Cross-Access
- 360LM PWA Suite
- manifest.json
- ADR-064 Video Tutorial Production Pipeline — scripts.json → edge-tts → Playwright → ffmpeg
- software-architect.md
- Activity PWA - Activity Tracking
- record.spec.js
- ADR-111: Unified Job Record in sales.jobs
- ADR-077: OpenClaw Integration — Read-Only DB Role, Schema Grants, and Auth Layers
- ADR-095: BTL Client Deck Contract — PowerPoint Add-in, Tagged Shape Naming, and 3-Path Extraction
- ADR-108: A Generic, Permanent Authenticated-Site Capture & AI-Analysis Service (Codename: SiteCap)
- generate_template.py
- 360LM Walkthroughs — manual install on your laptop
- MDD ↔ ADR Compliance Audit — 2026-07-03
- Module Design Document — Activity PWA
- ADR-065 Scene Guide Tutorial Format — JSON Data Contract + Player
- ADR-069: Production Hotfix Protocol — Bugfix DB Template, Dev-Branch Fix, Deploy via Master
- ADR-074: PostgREST Multi-Schema Routing via Accept-Profile Header
- ADR-081: Safe-Area Inset Rendering for Notched and Rounded-Corner Devices
- ADR-087: Push Notification Implementation Contract — SW Handler, Subscription Payload, and Notification Format
- ADR-090: Font Size Accessibility Preference — 5-Level Scaling, localStorage Persistence, Init-Time Application
- ADR-091: In-App Onboarding Tour Engine Contract — shared/tour.js Usage, Step Shape, and Dismissal Protocol
- ADR-106: Cross-Schema Access Today Is Grant-Gated by Convention, Not Enforced by Views or RLS — Ratify Reads, Flag Owner-Bypassing Writes for Remediation
- Module Design Document — Finance PWA Family
- ADR-032: expense.employees as FK anchor
- ADR-062 Live AI Pipeline Contract
- ADR-063 AI-Assisted Development Toolchain
- ADR-092: User Preference Cascading Fallback — DB → localStorage → Hardcoded Default
- 15 Test Transfers (Chronological)
- Sales PWA Billing Chain Manual Testing Guide (Stages A-G)
- Signage Manufacturing Fundamentals - Reference Research
- Module Design Document — Expense PWA (Employee Expense Tracking & Approval)
- excel_parser.py
- Work Section (Films)
- build_tutorial.py
- ADR-110: Custodian Voucher Booking Writes creditcard.ad_hoc_charges via SECURITY DEFINER RPC, Not Client-Side Fetch
- ADR-079: Shared Helper Governance — /shared/ Directory Structure, Adoption Policy, and Breaking Change Protocol
- ADR-105: Hub Issues a Signed JWT Alongside the localStorage Session — For Proxy Services and Future Native Clients Only
- 360LM BTL Add-in — Client Install Guide
- hub/index.html
- build_tutorial.py
- India 2024 Polaroid Series
- build_tutorial.py
- build_tutorial.py
- build_tutorial.py
- admin-draft-view-init.md
- manifest.json
- ADR-113: Email and Indian Mobile Inputs Validate Format by Default — Platform-Native Pattern + checkValidity, No Validation Library
- ADR-114 Google AI Access Uses OAuth/ADC Service Identity via Vertex AI
- ADR-016: Every New PWA Must Register in hub.pwa_registry
- ADR-068: VCC Pre-Build Safety Checklist — Mandatory Bug Prevention Standard
- ADR-070: All User-Facing Timestamps Displayed in IST (UTC+5:30)
- ADR-082: Dark Mode and Theming Architecture — Forced Light Mode for ERP PWAs, Dark UI for Standalone Apps
- index.html (Learning Hub PWA)
- Schema: `print_estimation`
- manifest.json
- Module Design Document — Stores PWA
- MDD — EXTENSION: Manual Tour Planner + Hub wiring (`tour-pg-v19`)
- package.json
- ADR-001 All PWAs Pass ?next= When Redirecting to Hub Login
- Activity — Tutorial
- Custodian Expense Voucher module
- ADR-041: Replacing an Engaged Official Recce Record Uses Supersede Flow, Not Update-in-Place
- ADR-098: Native Web Page Is the Primary Client Branding Approval Channel — PPTX/Excel Are Fallbacks
- Tour Playground v12 Mobile Walkthrough (Field Mapping + Native Scroll)
- UPI Pay and Vendor Management Cross-PWA Walkthrough
- ADR-107: `/mdd-reverse` ADR Verification Is an Active Per-Pattern Checklist, Not a Passive Citation Instruction — And Its Exemplars Must Model That
- Brevo domain authentication — 360degreelogicalmktg.com
- Recce Client Portal Test Setup Guide
- CLAUDE.md
- Production PWA
- ADR-019: OCR Strategy — Client-Side for Docs, Server-Side for Photos
- Step-by-Step
- 360DLM ERP-Lite — Software Landscape Research & Roadmap Inputs
- manifest.json
- 5. Screen Architecture (7 views)
- Module Design Document — Yagya Narang Cinematographer Portfolio
- Admin Access
- Sales PWA
- ADR-072-proof-image-capture-annotation.md
- ADR-109 VideoSmith — Isolated PWA Wrapping an Internal-Only Third-Party Engine, With the AI Chain Owned by the Wrapper
- ADR-NNN Short Imperative Title
- ADR Generator Agent
- manifest.json
- FundCustodian CiC Test Data Reference
- manifest.json
- 2. Image Capture — Proof, Receipt & Verification
- Module Design Document: VideoSmith — AI Short-Form Video Generation PWA
- 360DLM vs. "Lite ERP" Baseline — Gap Analysis (eFlexo-anchored)
- manifest.json
- manifest.json
- manifest.json
- manifest.json
- Module Design Document — Creative Intake & Print Pipeline (CDR → check → TIF)
- manifest.json
- pwa_dev_style.md
- record.spec.js
- manifest.json
- MDD: Customer Management Mini-PWA
- manifest.json
- maps-client.js
- custodian_voucher_tutorial.spec.js
- drive_consolidator.spec.js
- MDD_tour_pg.md
- Module Design Document — Tour Planner Playground (`tour-pg`)
- G. Phase 4.17 — Org-wide History Sharing + Token-AND Search ✅ SHIPPED 2026-07-04
- manifest.json
- vrs/index.html
- manifest.json
- Module Design Document — Client PWA
- ADR-116: Learning Hub Context-Specific Deep-Linking from PWA Headers
- ADR-002: Every PWA Must Link shared/safe-bottom.css
- ADR-003: Long Lists Must Scroll the Root Document, Not a Nested Container
- ADR-004: Maps Strategy — Google Primary, TomTom for Traffic/Matrix/Truck + Auto-Failover
- ADR-005: Service Worker Cache Busting via CACHE_VER String, Not skipWaiting
- ADR-006: verify_pin RPC Returns a TABLE Array, Not a Success Boolean
- ADR-008: PL/pgSQL RETURNS TABLE Functions Must Declare #variable_conflict use_column
- ADR-012: Hub PWA Is the Single SSO Gateway for All Employee-Facing PWAs
- ADR-013: Each PWA Is a Single Self-Contained HTML File — No Framework, No Build Pipeline
- ADR-015: Dev and Prod Are Two Full Stacks on the Same VPS, Not Branches or Feature Flags
- ADR-017: All Service Routing Uses Traefik + Docker Labels — No Nginx Config Files
- ADR-018: External Client Authentication Uses Company Code + Access Code, Not Employee PIN
- ADR-019: OCR Strategy — Client-Side Tesseract for Identity Docs, Server-Side Proxy for Bill Photos
- ADR-020: Field PWAs Are Offline-First — IndexedDB Primary, Server Sync Secondary
- ADR-021: Service Worker Uses Cache-First Strategy with Network Fallback
- ADR-022: Playwright Is the E2E Test Framework — One Spec File Per PWA
- ADR-023: Push Notifications Use Self-Hosted VAPID Server, Not FCM or Third-Party
- ADR-024: Google Slides/Sheets Integration Uses Google Apps Script via Self-Hosted Proxy
- ADR-025: Self-Hosted Ollama Runs Alongside Cloud AI for Vision and Text Inference
- ADR-026: Cross-PWA Session Handoff Uses Shared localStorage on Same Origin
- ADR-027: Multi-Dimension List Filtering Uses Leave-One-Out Faceted Availability
- ADR-029: Employee Access Control Is Dual-Written to DB and hub-access.json
- ADR-030: No <select> for More Than 5 Options — Use Searchable Type-Ahead or Chip-Grid
- ADR-031: Complex Forms Use Full-Screen Overlays — Modals Only for Simple Confirmations
- ADR-032: expense.employees Is the Canonical Employee Identity Table — Cross-Schema FK Anchor
- ADR-033: Expense Approval RPC Atomically Deducts Impress in One DB Transaction
- ADR-034: HR Salary Payment RPC Cross-Writes to finance.transactions
- ADR-035: Screenshot Protection Uses CSS/JS Deterrence — OS-Level Enforcement Is Not Available in PWA
- ADR-036: custodian.payees Is the Shared Payee Master Across All Payment-Facing PWAs
- ADR-037: transaction_lines Uses Soft Polymorphism — source_id Has No FK Constraint
- ADR-038: Vendor Catalog Is Auto-Populated by Trigger on Transaction Line Capture
- ADR-039: Custodian Reactivation Offers Limited (Settlement-Only) and Full Mode
- ADR-040: Cross-Schema Active-State Sync Uses SECURITY DEFINER Trigger, Not Application Dual-Write
- ADR-042: Vendor Rate Card Comparison Baseline Is Latest by created_at, Not Lowest Price
- ADR-043: sales.catalog Is the Shared Product Master — Vendor Management Links to It
- ADR-044: Finance Is Implemented as a Family of Focused Mini-PWAs, Not a Monolith
- ADR-045: Transaction Edit/Delete Uses Approval Queue for Non-Admins, Direct Apply for Admins
- ADR-047: Recce Client Visibility Is Filtered Per-Brand, Not Per-Counter
- ADR-048: External Client Portal Uses Email Magic-Link Auth — Not Hub PIN
- ADR-049: Recce View Files Are Served via HMAC-Signed Proxy — Not Direct Traefik Serve
- ADR-050: Client Auth Tables Have No Direct web_anon Grants — RPC-Only Access
- ADR-051: Learning Completion Is Threshold-Based — 100% Scenes or 80% Watch Time (Scrub-Proof)
- ADR-052: Learning View Tracking Uses Two-RPC Beacon (start_view / end_view) — Not Single Write
- ADR-053: Per-Brand Counter Data Lives on recce.submissions — Not on counters.counter
- ADR-054: Counter Sync Prefers my_visible_counters RPC, Falls Back to stores.json with Visible Warning
- ADR-055: Transactional Email Uses mail_outbox Table + External Poller — Not Inline SMTP
- ADR-056: AI-Assisted Features Use Prompt Copy-Paste Hand-Off — Not Live API Integration
- ADR-057: Reconciliation Statement Cannot Be Closed Until All Lines Are Matched
- ADR-058: Credit Card PWA Reads vehicle.cc_transactions via View — Zero Writes to Vehicle Schema
- ADR-059: Tour Planner AI Uses a Dedicated Sidecar Proxy — Not the Shared AI Finance Proxy
- ADR-060: Production Promotion Uses rsync Allowlist — Not Full Git Checkout
- ADR-061 Dual-Mode Search: Lazy Proxy Search + Eager Client-Side Dashboard
- ADR-075: Unified RPC Error Response Format and Client-Side Error Contract
- ADR-094: Google OAuth Token Lifecycle — In-Memory Only, Email Hint Persisted for Silent Re-Auth
- ADR-104: Cross-PWA Payment Handoff — localStorage Bridge into a Prefilled Custodian Transfer
- btl schema
- 9 Test Advances (Chronological)
- manifest.json
- manifest.json
- manifest.json
- manifest.json
- manifest.json
- 9. Open Questions — Resolved via eFlexo Trial Capture (2026-07-03)
- OSS Schema & Workflow Pattern Reference — Detailed Appendix
- manifest.json
- index.html (OC Contact Import PWA)
- Module Design Document — Production Order Management PWA
- manifest.json
- theme-v2 Preset Editor
- manifest.json
- 4.2 RPCs (all in `stores` schema)
- custodian_tutorial_screenshots.spec.js
- manifest.json
- Module Design Document — Tutorials (Legacy)
- manifest.json
- manifest.json
- manifest.json
- ADR-009: Each PWA Owns Dedicated PostgreSQL Schema
- ADR-007: Trigger Functions Writing Privileged Tables Must Use SECURITY DEFINER
- ADR-014: PostgREST Is the API Layer — No Custom REST Framework
- ADR-028-feature-ownership-follows-domain.md
- ADR-076-mobile-first-viewport-standard.md
- Source: rvdbreemen/adr-kit (adapted for 360lm project)
- software-architect Agent
- FundCustodian UX Walkthrough CiC Prompt
- Module Design Document: Print Estimation Engine
- 17. Highlight Video — Assembled From the User's Own Event Photos/Clips (2026-07-06)
- Branding & Logo Design
- manifest.json
- capture.js
- Print Bridge — Designer PC Setup (one time, ~15 minutes)
- 4.1 Core tables
- 5. UI — Six screens
- 20. Activity PWA — Response Capture Patterns
- 21. Bilingual (EN / HI) Pattern
- recce.spec.js
- 4. Database schema
- 7. Screens and workflows
- manifest.json
- ADR-099 DevGuide Is an Index + Skill + Topic Files, Not a Monolith
- ADR-100 Visual Design via shared/theme-v2.css Token Presets, Outside Ponytail's Scope
- ADR-101 SVG Is the Working Format for Print Creatives; CorelDRAW Is Fallback Only
- ADR-102 Modern CDR Conversion Must Originate From CorelDRAW; Cloud Converters Only for Legacy CDRs
- ADR-103 Print Bridge Runs Over a Syncthing Job Folder With a Self-Updating Watcher
- Source: rvdbreemen/adr-kit instructions/adr.coding.md (adapted for 360lm)
- Tour AI Proxy
- Module Design Document — Contacts PWA
- 14. Blogsmith Feature-Parity Expansion (2026-07-03, same day)
- Signage & Fabrication Competitive Synthesis — eFlexo, CoreBridge, ShopVOX + Manufacturing Fundamentals
- EltaMD UV Clear Sunscreen - Marketing Infographic
- 14. Verification
- 5. Data model — expense schema
- Yagya Narang Portfolio v2
- manifest.json
- 4.3 Views
- 23. Client Portal Session Bridge Pattern
- 4. Database (IndexedDB)
- tour_pg_sharing.spec.js
- MDD — EXTENSION: Counter Search + Geographical Schema + Dual-Mode Dashboard (`tour-pg-v20`)
- manifest.json
- ADR-033
- Recce Portal Tutorial — counters + recce-client two-PWA walkthrough
- 5.1 VideoSmith API Endpoints
- extract_city_hints
- index.html (Print Nest PWA)
- PostgREST API Base URL
- Revised prompt — tutorial-length output
- US sign industry standards (fragmented)
- 22. App Update Banner Pattern
- 8. Store List Management
- fundcustodian.spec.js
- recce_client.spec.js
- install.sh
- External Client Portal Uses Email Magic-Link Auth
- docs/adr/README.md
- Alternatives Considered
- Implementation Notes
- Yagya Narang (Cinematographer)
- Learning Hub
- Design System
- renderApprovalScreen() — Render Review UI
- 5. Remote Procedure Calls (RPCs)
- 6. Screens/UX
- 7. Data Sensitivity & Access Model
- Large (~8GB) source library scoping discussion
- Finance V1 Archived Reference (deprecated 2026-05-19)
- get-gemini-key.js
- Module Design Document — mother
- PCA Skin Product Promotional Poster with Model
- 7. Photo Pipeline
- 19.6 HTML Report — Rich Server Version (`generateRecceReportHtml`)
- btl.spec.js
- custodian_s9_recording.spec.js
- sales_billing.spec.js
- F6. UI components
- Module Design Document — tours
- generate_segment
- Zone deletion guard — accounts check
- MDD_expense.md
- Recce Client Visibility Filtered Per-Brand
- Related Decisions
- Approval option button handlers (approve/reject/comment)
- Brevo Account + API Key Setup CiC
- 360LM Walkthroughs Manual Install Guide
- excel_to_counters Skill
- Ponytail Help Reference
- Fund Custodian Dashboard after UPI Payment
- Send/Receive Funds - Cash Giver Pending Warning
- ADR-021: Service Worker Cache-First with Network Fallback
- 3. Proposed Build Phases
- 8. Financial Integrity & Immutability
- 3. Proposed Build Phases
- Schema: `videosmith`
- 6. Screens & UX
- Live walkthrough verification (PIN 0000, Harish Kumar Lal)
- 12. Integrations
- generate_segment
- 5. RPCs (Remote Procedure Calls)
- Yagya Narang Portfolio v1
- generate_segment
- generate_segment
- generate_segment
- vehicle/index.html
- 24. Admin PWA — Extending with New Management Sections
- 10. Sync Architecture (3-Stage)
- rentveh.spec.js
- upi_pay.spec.js
- 4. Phases
- 5. API integration
- 8. Authentication & Authorization
- Consequences
- ADR-105: Hub Issues a Signed JWT Alongside localStorage Session
- pwa_dev_style.md DevGuide
- PostgREST API Layer
- ADR-017: Traefik + Docker Labels for Routing
- 11. Red-Team: 3 Concrete Failure Modes & Mitigations
- 7. Data Sensitivity & Access Model
- VideoSmith Phase 1: Core Video Generation Pipeline
- 2. Domain 1 — Branding & printing (print MIS)
- 4. Architecture
- 8. Offline + sync strategy
- IBU Case Study - Luxury Red Sports Car Product Photography
- Lounge Hair Studio - From Fine Hair to Volume Campaign
- tour.js
- Substrate specifications (manufacturer-verifiable)
- counters.spec.js
- custodian.spec.js
- customers.spec.js
- hr.spec.js
- printing.spec.js
- safe_bottom.spec.js
- tour_pg.spec.js
- vendors.spec.js
- 360LM Activity PWA
- Employee Access Control Is Dual-Written to DB and hub-access.json
- Vehicle Log PWA
- Customer Management mini-PWA
- OpenRouter Account + API Key CiC Walkthrough
- ADR-023: Push Notifications Self-Hosted VAPID
- 360LM Contacts PWA
- Peer-source deductions
- Custodian Tutorial - NEFT Transfer Filled
- Reject Transfer Modal with Reason Field
- Sales PWA (main)
- sales.spec.js
- ADR-004: Maps Strategy — Google Primary, TomTom Fallback
- 2. Inspiration vs. Scope
- 8. Open Questions — RESOLVED by User (2026-07-03)
- sw.js
- 4.1 Custodian profiles + wallets
- sw.js
- Finance PWA Icon (512px)
- Admin PWA - Administration
- Learning Hub catalog: rent-vehicle tutorial group
- PCA Skin
- Unified Payments Interface (UPI)
- Recce Client Portal Tutorial (Hinglish/English)
- watcher.ps1
- activity.spec.js
- client.spec.js
- debug_tour.spec.js
- dispatch.spec.js
- hub.spec.js
- mappls-creds.spec.js
- production.spec.js
- stores.spec.js
- yagya-portfolio.spec.js
- _isSupervisor() function
- sw.js
- sw.js
- Feature Ownership Follows Domain — Hub Is Navigation-Only
- No <select> for More Than 5 Options
- ADR-046 installation.campaigns Is the Canonical Job Record
- ADR-107: MDD Reverse ADR Verification Is an Active Per-Pattern Checklist
- health-tracker-ocr OpenRouter Key
- prebuild_check.sh
- sw.js
- DKIM Email Authentication
- sw.js
- Custodian Tutorial - Admin Mode Selector
- Employee Advance Form
- Ledger View - Transfers Tab
- Manage Custodians - Custodians List
- ADR-022: Playwright E2E Testing Framework
- Ink cost calculation via public flexo formula
- Locked-counter gap-free estimate numbering
- Margin visibility role-gated (caller_role parameter)
- Employee ID Selection
- allCustodians Variable
- BHIM UPI Payment App Logo
- sw.js
- HR PWA Icon 192px (Teal Circle)
- HR PWA Icon 512px
- sw.js
- index.html (Branding Recce PWA)
- service-worker.js
- sw.js
- localStorage (Config)
- MEMORY.md
- sw.js
- Mozaic Realty Group
- Tractor Agricultural Promotional Design
- PIN Login
- playwright.config.js
- sw.js
- sw.js
- promote.sh
- record.config.js
- emergency_dev_to_prod.sh
- record.config.js
- sw.js
- sales.jobs.job_id
- sw.js
- Shared: maps-client.js (Google+TomTom dual-provider)
- sw.js
- admin.spec.js
- contacts.spec.js
- expense.spec.js
- finance.spec.js
- health_smoke.spec.js
- installation.spec.js
- learn.spec.js
- oc_admin.spec.js
- smoke.spec.js
- _template.spec.js
- tour_planner.spec.js
- vehicle.spec.js
- vrs.spec.js
- Google Apps Script
- sw.js
- sw.js
- sw.js
- .act-actions Component
- .act-header Component
- .act-stats Component
- .admin-section Component
- .badge Component
- .btn-primary Component
- .card Component
- .code-input Component
- .filter-chip Component
- .form-group Component
- .form-input Component
- .inline-modal Component
- .keypad Component
- #lightbox Component
- .login-tabs Component
- .modal-overlay Component
- .modal-sheet Component
- .na-detected-strip Component
- .na-hero Component
- .photo-grid Component
- .photo-section Component
- .pin-display Component
- .pres-body Component
- .pres-hero Component
- .pres-photos Component
- .pres-section Component
- .resp-card Component
- #scr-login Screen
- .search-bar Component
- .submit-row Component
- #toast Component
- #update-banner Component
- .emp-select Component
- .pin-display Component
- .pin-pad Component
- ADR-001: next= redirect on hub login
- Screenshot Protection Uses CSS/JS Deterrence
- Tour Planner AI Uses Dedicated Sidecar Proxy
- Production Promotion Uses rsync Allowlist
- ADR-104: Cross-PWA payment handoff via localStorage bridge
- Hub PWA
- ADR-109 Amendment 4: Highlight Video Job Type
- App icon 192x192
- App icon 512x512
- Bank of Baroda
- HDFC Bank
- State Bank of India
- book_voucher() function
- AXOR Brand - Premium Bathroom Fittings
- BONZER - Building Materials
- Orientbell Tiles - Ceramic Tiles Brand
- TOTO Brand - Bathroom Fixtures
- Brevo Domain Authentication Walkthrough
- MDD — BTL Offers
- buildCard function
- buildFormatSection function
- Activity Cascading Filters Live Test
- Client PWA Folder Placeholder
- Architecture Theme
- Cultural and Traditional Elements
- Nature and Landscape Theme
- People and Daily Activity Theme
- Urban Scenes Theme
- Data flow: PPTX → Counters
- ADR-003: Mobile Scroll Root Document
- ADR-006: verify_pin Returns TABLE Array
- ADR-018: Client Auth Uses Company Code, Not Employee PIN
- Manual Export Resolved (Auto-Publish Parked)
- Reference OSS Schema Patterns 2026-07-03
- ERP-Lite Landscape Research 2026-07-03
- Gap Severity Classification
- docs/style/identity-and-design-system.md
- Eeman Enterprises and Industries - Ludhiana-based business
- Epson Ludhiana 2025 field survey campaign
- Epson - Japanese imaging and printing technology company
- Expense PWA Logo (192px)
- Expense PWA Logo (512px)
- Custodian Tutorial player.html (placeholder stub)
- Fund Custodian App Icon (192x192)
- BHIM UPI Logo
- Paytm UPI Logo
- CACHE_VER Constant
- UPI Pay Title
- isCustodian Variable
- myId Variable
- myName Variable
- payMode Variable
- payReason Variable
- _RW Constant
- selectedApp Variable
- selectedPayee Variable
- selectedVpaIdx Variable
- session Variable
- UPI_APPS Constant
- urlReturnTo Variable
- Finance PWA (v1) Logo (192px)
- Finance PWA (v1) Logo (512px)
- Google Pay UPI Logo
- PhonePe UPI Logo
- finance/vendors/index.html
- Modal: Add/Edit Rate Card
- Screen: Vendor Detail
- Screen: Vendor List
- Toast Notification
- Update Banner
- Fuel Pump Electronic Display
- Fuel Transaction Record
- Google Fonts DM Sans Typography
- HR PWA Logo (72px)
- HR PWA Logo (96px)
- HR Module Icon 128x128
- HR Module Icon 144x144
- HR Module Icon 152x152
- HR Settings Module - Geofencing Configuration
- index.html (Sales PWA)
- Installation PWA Icon 512px
- Installation PWA Icon v1.0.0 192px
- Installation PWA Icon v1.0.0 512px
- Module Design Document - BTL Installation PWA
- MANPOWER Array
- Mother PWA Icon 192x192px
- Mother PWA Icon 512x512px
- Mother health check placeholder
- Mother - Placeholder
- Speedwash - Car Wash Case Study
- Angelic Treasures - Christian Daycare
- Bellair LaserClinic
- Brinks Property Services Ltd.
- EZMG - Mortgage Services
- Gaimin - Gaming/Entertainment
- Hillsborough Dental Centre
- Hunny Pot Cannabis
- IBU (International Business University)
- Premium Maintenance Services
- Renoz
- Portfolio Site Architecture (Sections: Hero, About, Stats, Brands, Work, Cases, Contact)
- Nikhil Chawla Portfolio Website
- OC Contact Import Admin
- Payment Processing System - Paytm UPI Integration
- Mukesh
- Parmod Narang
- Uma Shankar Singh
- Print Bridge Designer PC Setup
- Printing PWA Icon 192x192px
- Printing PWA Icon 512x512px
- Production PWA Icon 192x192px
- Production PWA Icon 512x512px
- Production Order Management PWA
- Recce Portal PWA
- Epson Brand Logo
- HP Brand Logo
- KFC Brand Logo
- Lenovo Brand Logo
- Liebherr Brand Logo
- Philips Brand Logo
- Recce Client Portal Index HTML
- Recce App Icon 192x192px
- Recce App Icon 512x512px
- Recce Sample Photo Brand 1 JPG
- Recce Sample Photo Front 1 JPG
- Recce Sample Photo Inside 1 JPG
- Recce Tutorial HTML
- Rent Vehicle Expense Index HTML
- DB table: settings (grace_hours, food_allowance_per_day, late_charge)
- sales.catalog (schema)
- sales.customer_addresses (schema)
- sales.customer_contacts (schema)
- Sales PWA Icon 192x192px
- Sales PWA Icon 512x512px
- Excel AI Sidecar Service (port 8778)
- Stores PWA (index.html)
- Tours Directory - Legacy
- Unico Engineering Works - manufacturing facility in Mohali, Punjab
- Vehicle Dispatch / Fleet Management PWA
- Vehicle PWA app icon - orange rounded square with black-outlined rectangle and VEH text label
- Vehicle Odometer Reading
- Vehicle PWA Icon (unrelated asset)
- Vehicle Registration Number
- Vehicle Telemetry System - Odometer Data Collection
- VRS PWA app icon - purple rounded square with white-outlined rectangle and VRS text label
- VRS PWA Icon (unrelated asset)
- Yagya Portfolio

## God Nodes (most connected - your core abstractions)
1. `_()` - 86 edges
2. `_()` - 86 edges
3. `BTL Offers — Gift Claim Portal PWA` - 36 edges
4. `HTML structure for HR Management PWA` - 28 edges
5. `Recce Portal — End-to-End Walkthrough` - 25 edges
6. `360LM Admin PWA` - 25 edges
7. `SCENE LIST (21 scenes — one per screenshot, in order)` - 23 edges
8. `Module Design Document — Activity PWA` - 21 edges
9. `360LM Architecture Decision Wiki` - 21 edges
10. `19. Report Generation & Google Slides (GAS)` - 20 edges

## Surprising Connections (you probably didn't know these)
- `Master PWA DevGuide (pwa_dev_style.md)` --semantically_similar_to--> `pwa_dev_style.md DevGuide`  [INFERRED] [semantically similar]
  MEMORY.md → .claude/agents/software-architect.md
- `Activity PWA Icon 192px` --represents--> `Activity PWA - Activity Tracking`  [EXTRACTED]
  activity/icons/icon-192.png → docs/adr/ADR-027-leave-one-out-faceted-filtering.md
- `Activity PWA Icon 512px` --represents--> `Activity PWA - Activity Tracking`  [EXTRACTED]
  activity/icons/icon-512.png → docs/adr/ADR-027-leave-one-out-faceted-filtering.md
- `Tutorial video metadata: script sections, clips, voiceover` --semantically_similar_to--> `Scene guide: 12-step visual walkthrough (case study Sachin)`  [INFERRED] [semantically similar]
  rentveh/tutorial/production/scripts.json → learn/data/rentveh-user-01.json
- `Recce PWA - Field Branding Inspection` --semantically_similar_to--> `Client Portal PWA (Recce)`  [INFERRED] [semantically similar]
  recce/MDD_recce.md → recce-client/MDD_recce_client.md

## Import Cycles
- None detected.

## Hyperedges (group relationships)
- **Unified Job Consolidation** — adr_111, sales_jobs, installation_campaigns, sales_job_tours, installation_tours, installation_jobs, custodian_vouchers, docs_plan_job_consolidation_2026_07_11_md, operational_draft_status [EXTRACTED 1.00]
- **Four architectural changes needed for 8GB source library support** — docs_mdd_videosmith_upload_transport_change, docs_mdd_videosmith_mandatory_curation_dedup, docs_mdd_videosmith_persistent_media_library, docs_mdd_videosmith_separate_progress_reporting [EXTRACTED 1.00]

## Communities (677 total, 273 thin omitted)

### Community 0 - "_"
Cohesion: 0.05
Nodes (72): _(), A(), an(), at(), Be(), bn(), Bt(), c() (+64 more)

### Community 1 - "_"
Cohesion: 0.05
Nodes (72): _(), A(), an(), at(), Be(), bn(), Bt(), c() (+64 more)

### Community 2 - "brevo_domain_auth.js"
Cohesion: 0.06
Nodes (40): { chromium }, ensureDir(), escapeHtml(), fs, { HUD_SCRIPT }, os, path, PROFILE_DIR (+32 more)

### Community 3 - "Module Design Document — Recce PWA (Field Branding Inspection)"
Cohesion: 0.04
Nodes (47): 10. Known limitations and open items, 11.10 Config files, 11.1 Screen structure, 11.2 Offline-first IndexedDB, 11.3 Sync flow, 11.4 Admin view, 11.5 Multi-Recce conflict, 11.6 Client invite (+39 more)

### Community 4 - "Module Design Document — Client Portal PWA (`/recce-client/`)"
Cohesion: 0.05
Nodes (45): ADR-048: Magic-link auth for external clients, counters.client_invite - Magic-link Token, counters.client_session - Active Session, counters.client - Brand Entity, counters.client_user - Individual Client User, recce.branding_approvals - Item-level Approval, 10.1 Auth provider — Option A (magic-link) vs B (SSO + magic-link), 10.2 Email provider (+37 more)

### Community 5 - "Module Design Document — CounterManagement mini-PWA"
Cohesion: 0.05
Nodes (42): 10. Auth + cross-PWA safety, 11. Migration plan (Phase 1), 12. Open questions parked (will surface when relevant), 13. Acceptance for Phase 1 (CounterManagement mini-PWA — basic CRUD), 14. Glossary, 15.1 Unified Job ID — defer to its own work track?, 15.2 Phase 4 client portal — its own MDD + its own PWA?, 15. Two deferrals that need explicit user confirmation (+34 more)

### Community 6 - "Module Design Document — HR Management PWA"
Cohesion: 0.05
Nodes (43): 10.1 Salary slip generation (generate_salary_slip RPC), 10.2 Salary payment (pay_salary_slip RPC), 10. Calculation models, 11. Auth & access control, 12. Tests, 13. Tutorials & learning, 14. Open questions & future work, 15. ADRs governing this module (+35 more)

### Community 7 - "Module Design Document — Vehicle Log PWA"
Cohesion: 0.05
Nodes (42): 10. Migrations (code-verified), 11. Service Worker (v27), 12. Configuration, 13. Known limitations & future phases, 14. Glossary, 15. Acceptance checklist, 15a. ADRs governing this module, 1. Why this exists (+34 more)

### Community 8 - "Module Design Document — Admin PWA"
Cohesion: 0.05
Nodes (40): 10. API contract (headers), 11. RPCs used, 12. Theme and styling, 13. Governance model, 14. Verification, 15. Known gaps and TODOs, 16. Glossary, 17. Cross-PWA safety (+32 more)

### Community 9 - "BTL Offers — Gift Claim Portal PWA"
Cohesion: 0.05
Nodes (37): addRuleRow() function, cancelPhotoSrc() function, closeOvl() function, doLogin() function, #ed-modal (Image Editor) Modal, edTool() function, edUndo() function, exitClaim() function (+29 more)

### Community 10 - "VCC Pre-Build Checklist"
Cohesion: 0.06
Nodes (33): VCC Pre-Build Checklist, Column Names in JS Queries Checklist, Correct Gmail account active, Cross-PWA Safety Checklist, CSS Visibility Defaults Checklist, DB Objects Checklist, Derived / Dependent Columns Checklist, docker-ro-exec postgres psql (+25 more)

### Community 11 - "Video Tutorial DevGuide"
Cohesion: 0.06
Nodes (33): Video Tutorial Pipeline — scripts.json → edge-tts → Playwright → ffmpeg, Playwright Walkthrough Framework — CiC drop-in replacement, 10. Naming Conventions, 11. Codec Decision, 12. Reference — Custodian Tutorial, 1. When to Build a Tutorial, 2. Directory Structure, 3. Segment Types (+25 more)

### Community 12 - "UPI Pay Index HTML"
Cohesion: 0.06
Nodes (34): counters/index.html, UPI Pay Index HTML, checkAppUpdate Function, checkUrlParams Function, CUSTODIAN_IDS Constant, Custodian Link, DB Constant, doPayeeSearch Function (+26 more)

### Community 13 - "ADR-085 — File Upload Patterns: CSV Import, PDF Export, and Bulk Data Handling"
Cohesion: 0.06
Nodes (34): 1. Client-Side PDF Generation (jsPDF, html2pdf), 1. CSV/XLSX Import (Client-Side Parsing), 2. PDF Export (Server-Side Generation), 2. POST CSV as Multipart to PostgREST, 3. General File Uploads (Non-Image, Non-CSV), 3. Store Entire File Content in DB (Not Just Reference), 4. Size Limits and Progress, 4. Use a Third-Party File Upload Service (S3, Google Cloud Storage) (+26 more)

### Community 14 - "ADR-066 Parallel CLI Session Coordination with Conflict Zone Locking"
Cohesion: 0.06
Nodes (32): 1. No Coordination (Status Quo Pre-2026-05-08), 2. Distributed Locking (etcd, Redis, DB Advisory Locks), 3. Git Branches for Infrastructure Code, 4. Strict Session Scheduling (One Session at a Time), Active Sessions Table, ADR-066 Parallel CLI Session Coordination with Conflict Zone Locking, Alternatives Considered, Bootstrap Warning (+24 more)

### Community 15 - "Module Design Document — OC Contact Import Admin"
Cohesion: 0.06
Nodes (32): 10. Verification, 11. Glossary, 12. Known gaps / future work, 13. Cross-PWA safety, 1. Why this exists, 2. Scope and boundaries, 3.1 Auth, 3.2 Screens (+24 more)

### Community 16 - "Module Design Document — Rent Vehicle Expense PWA"
Cohesion: 0.06
Nodes (32): 10. AI & automation, 11. Auth & access control, 12. Tutorials & learning (Phase 2 built), 13. Tests, 14. Cross-PWA safety, 15. Deployment & migration, 16. Open questions & future work, 17. ADRs governing this module (+24 more)

### Community 17 - "Customer Management PWA"
Cohesion: 0.06
Nodes (31): _prodUser global variable, enterDash() function, goToHub() function, index.html (Production PWA), injectHubButtons() function, loadDash() function, production.items (DB table), Production Order Status (+23 more)

### Community 18 - "Feature Inventory"
Cohesion: 0.06
Nodes (30): Access Control, Admin Screen (`screen-admin`) — admin only, Bottom Nav (role-sensitive), Build Stage History, Cash Desk (`screen-cash`) — shambhu, gurpreet, harish, Dashboard (`screen-dash`), DB RPCs Used, DB Tables Used (all in `finance` schema via PostgREST) (+22 more)

### Community 19 - "ADR-112: lm360-session Is the Single Canonical Session — Every PWA Mirrors To It on Login, and Every PWA Exposes an Always-Visible Logout"
Cohesion: 0.07
Nodes (29): ADR-001, ADR-105, 360exp-session (localStorage key), activity/index.html, Activity PWA, btl/ PWA, btl-session (localStorage key), ADR-112: lm360-session Is the Single Canonical Session — Every PWA Mirrors To It on Login, and Every PWA Exposes an Always-Visible Logout (+21 more)

### Community 20 - "ADR-073: Traefik Docker Label Conventions and Middleware Chaining"
Cohesion: 0.07
Nodes (28): 1. Static Traefik Config Files (Rejected), 2. Traefik Operator / Kubernetes Ingress (Rejected), 3. Nginx as the Primary Reverse Proxy (Rejected), 4. Single Cert Resolver (Rejected), Adding a New Service (Checklist), ADR-073: Traefik Docker Label Conventions and Middleware Chaining, Alternatives Considered, Benefits (+20 more)

### Community 21 - "ADR-084: List Pagination and Infinite Scroll — When to Use Each, PostgREST Range Header Pattern"
Cohesion: 0.07
Nodes (28): ADR-084: List Pagination and Infinite Scroll — When to Use Each, PostgREST Range Header Pattern, Alternatives Considered, Consequences, Context, Cursor-Based Pagination, Decision, Decision Table: Dataset Size → Approach, Default Page Size (+20 more)

### Community 22 - "HTML structure for HR Management PWA"
Cohesion: 0.07
Nodes (29): CSS variable definitions, Overall HR Management PWA application, Action tile components, Attendance calendar component, Attendance check-in component, General badge component, Bottom navigation bar component, General button styles (+21 more)

### Community 23 - "Module Design Document — Learning Hub PWA"
Cohesion: 0.07
Nodes (28): 10. Hub integration, 11. Catalog structure (catalog.json), 12. ADR references (governing decisions), 13. Integrations with other PWAs, 14. Deployment checklist (Phase 4.12 post-mortem), 15. Pending / future (Phase 4.12 notes), 1. Why this exists, 2. Inspiration vs scope (+20 more)

### Community 24 - "ADR-088: IndexedDB Schema Versioning and Safe Upgrade Protocol"
Cohesion: 0.07
Nodes (27): 1. Use a separate "schema_version" table in IndexedDB, 2. Delete and recreate the entire database on schema change, 3. Use a migration library (e.g., Dexie.js), 4. Auto-delete unused stores on every open, ADR-088: IndexedDB Schema Versioning and Safe Upgrade Protocol, Alternatives Considered, CACHE_VER Coordination (ADR-005), Checklist for Updating a PWA's IndexedDB Schema (+19 more)

### Community 25 - "ADR-078: Paperclip AI Platform Isolation — Separate DB Role, Zero lm360 Access, Independent Backups"
Cohesion: 0.07
Nodes (26): 1. Share the `lm360` database and schema with Paperclip (grants to Paperclip role), 2. Run Paperclip on a separate VPS, 3. Implement database-level isolation only (REVOKE CONNECT), 4. Dedicated API key for Paperclip now, ADR-078: Paperclip AI Platform Isolation — Separate DB Role, Zero lm360 Access, Independent Backups, Alternatives Considered, API Key Management, Backup Schedule (+18 more)

### Community 26 - "ADR-097 Blogsmith AI Content Pipeline — Keyword to Published Article (Standalone App)"
Cohesion: 0.07
Nodes (26): 1. Integrate into 360lm (shared lm360 schema + hub SSO), 1. Location & Deployment, 2. Routing & Networking, 2. Use Drive Consolidator's auth model (client-side SHA-256, zero backend), 3. Database — Isolated Role & Database, 3. Use hub PIN auth (verify_pin RPC), 4. Authentication — PIN-Based, Server-Side Bcrypt, Device Auto-Reconnect, 4. Publish via a review queue (add human gate like other pipelines) (+18 more)

### Community 27 - "NORMALIZATION RULES"
Cohesion: 0.07
Nodes (26): AMBIGUITY HANDLING (when to flag for human confirmation), API MODE — JSON IN / JSON OUT, DEMO RUN (to test the skill on sample files), Input format — PRE-MAPPED ROWS (legacy, still accepted), Input format — RAW ROWS (preferred, column auto-detection), INTERACTIVE PIPELINE (when invoked as a slash command), NORMALIZATION RULES, Output format (+18 more)

### Community 28 - "Module Design Document — Vehicle Requisition Slip (VRS)"
Cohesion: 0.07
Nodes (26): 10. Verification, 1. Why this exists, 2. Scope, 3.1 `vrs.requests`, 3.2 `vrs.fuel_slips`, 3.3 `vehicle.hired_vehicles` (existing vehicle schema, extended by VRS), 3.4 `vrs.config`, 3. DB Schema (`vrs` namespace) (+18 more)

### Community 29 - "360LM Admin PWA"
Cohesion: 0.08
Nodes (26): doLogout() function, 360LM Admin PWA, manifest.json, #modal-bank Modal, #modal-company Modal, #modal-pwa Modal, openCompanyModal() function, openEmployeeModal() function (+18 more)

### Community 30 - "appsCall"
Cohesion: 0.09
Nodes (26): appsCall, appsCall function (HTML embedded), assignCounters (Apps Script action), CFG Object (HTML embedded), Claude.ai, CFG Configuration Object, CSS Styling (Installation PWA Release), getCountersByJob (Apps Script action) (+18 more)

### Community 31 - "SCENE LIST (21 scenes — one per screenshot, in order)"
Cohesion: 0.08
Nodes (25): END CARD (after scene 21), Gemini prompt — Recce Portal video tutorial, If Gemini can't render video directly, Scene 10 — `10_counters_multirecce_expanded.png`, Scene 11 — `11_counters_comments_modal.png`, Scene 12 — `12_recce_client_login.png`, Scene 13 — `13_recce_client_login_filled.png`, Scene 14 — `14_recce_client_list.png` (+17 more)

### Community 32 - "Recce Portal — End-to-End Walkthrough"
Cohesion: 0.08
Nodes (25): CLOSING, Production notes for Gemini, Recce Portal — End-to-End Walkthrough, SCENE 10 — Multi-Recce expanded (10), SCENE 11 — 💬 Comments modal (11), SCENE 12 — Client opens the portal (12), SCENE 13 — Email entered (13), SCENE 14 — Recce list (14) (+17 more)

### Community 33 - "Module Design Document — CustomerManagement mini-PWA"
Cohesion: 0.09
Nodes (24): Access, Auto-migration (run on Phase 1 apply), Compaction policy, Cross-PWA additions (additive only), DB (`migrate_customers_v2.sql`), DB (`migrate_customers_v3.sql`), DB (`migrate_customers_v4.sql`), DB schema (3 tables + 1 view, all in `sales`) (+16 more)

### Community 34 - "VideoSmith — Build Plan and Architecture"
Cohesion: 0.08
Nodes (24): 1.1 MoneyPrinterTurbo Deployment Model, 1.2 VideoSmith Wrapper PWA, 1.3 Auth Model: Isolated PIN — **RESOLVED (2026-07-03)**, 1.4 API Contract with MoneyPrinterTurbo, 1. Architecture Recommendation: Internal Engine, Isolated Wrapper, 2. Phased Rollout, 3.1 Infrastructure Changes, 3.2 Database Setup (+16 more)

### Community 35 - "ADR-071: Indian Number Formatting for All Monetary Amount Inputs"
Cohesion: 0.08
Nodes (24): 1. Use a shared utility file from `/shared/`, 2. Format in the database (store as string), 3. Format only on display (list/ledger) not on input, 4. Use `type="number"` with custom styling, 5. Support multiple regional formats (Western, Indian, European), ADR-071: Indian Number Formatting for All Monetary Amount Inputs, Alternatives Considered, Auto-Fill / Pre-Fill from DB (+16 more)

### Community 36 - "ADR-080: Hub as Authoritative Session Registry — Cross-Schema Active-State Sync Architecture"
Cohesion: 0.08
Nodes (23): 1. Hub Is the Authoritative Session Source, 2. Hub PWA Registry Controls Access, 3. Offline Access Control — Dual-Write Pattern, 4. Cross-Schema Active-State Sync — SECURITY DEFINER Trigger, 5. New PWA Onboarding Checklist, ADR-080: Hub as Authoritative Session Registry — Cross-Schema Active-State Sync Architecture, Alternatives Considered, Consequences (+15 more)

### Community 37 - "4. DB schema: `custodian.*`"
Cohesion: 0.09
Nodes (24): 4.10 Rate cards — phase 3c (v3c migration), 4.11 Views, 4.12 PostgREST grants, 4.2 Transfers — fund movements between custodians, 4.3 Advances — giver to employee, 4.4 Advance settlements — link advance to expense sheet, 4.5 Receipts — cash received by custodian, 4.6 Payees — shared across all payment PWAs (ADR-036) (+16 more)

### Community 38 - "Hub PWA"
Cohesion: 0.09
Nodes (23): ADR-011 Employee Authentication Uses PIN, .btn-hub class, /db/employee_pwa_access, /db/pwa_registry, 360exp-session (localStorage key), expense/index.html, finance/custodian/index.html, .hub-btn class (custodian) (+15 more)

### Community 39 - "Tour Planner PWA"
Cohesion: 0.10
Nodes (23): ADR-026 PWA session format, ADR-106 cross-schema access, Anthropic Claude AI, Google Cloud APIs, Google Maps, installation.counters Table, Installation PWA Icon 192px (Blue Lightning), installation.jobs Table (+15 more)

### Community 40 - "ADR-067: Cross-PWA Change Safety Gate — Explicit Confirmation Before Shared Infrastructure Changes"
Cohesion: 0.09
Nodes (22): ADR-067: Cross-PWA Change Safety Gate — Explicit Confirmation Before Shared Infrastructure Changes, Alternative 1: No Gate — Trust Developer Judgment, Alternative 2: Automatic Detection + Silent Rollback, Alternative 3: Require Unit Tests Before Confirmation, Alternative 4: Only Confirm on "Likely" Changes, Not All Shared Infrastructure, Alternatives Considered, Benefits, Confirmation Message Format (+14 more)

### Community 41 - "PWA Dev Style Guide (Master Build Reference)"
Cohesion: 0.09
Nodes (23): applyI18n / applyI18nIn post-render hook, Bilingual EN/HI Dev Guide, DB-backed language prefs recce.get_pref / set_pref, t(key) i18n helper function, TTS ttsRead / ttsIcon narration, Indian Amount Formatting Standard, CTH Cash Hand-to-Hand camera flow, fmtAmountInput / _indFmt / _parseAmt utilities (+15 more)

### Community 42 - "sales.invoices (schema)"
Cohesion: 0.11
Nodes (23): sales.artifacts (schema), sales.briefs (schema), sales.challan_lines (schema), sales.challans (schema), sales.challans_v (view), sales.customers (schema), sales.invoice_kpi (view), sales.invoice_lines (schema) (+15 more)

### Community 43 - "ADR-089: Bilingual EN/HI Platform Architecture — DB-Backed Language Preference, t() Helper, and Adoption Checklist"
Cohesion: 0.09
Nodes (21): Adoption Checklist for New Bilingual PWA, ADR-089: Bilingual EN/HI Platform Architecture — DB-Backed Language Preference, t() Helper, and Adoption Checklist, All User-Facing Strings Use Bilingual Objects, Alternatives Considered, Browser Text-to-Speech (Optional), Consequences, Context, DB Schema for Bilingual Data (+13 more)

### Community 44 - "Bilingual EN/HI — DevGuide for 360LM PWAs"
Cohesion: 0.09
Nodes (21): 1. Substring-match sweeps can corrupt the dict itself, 2. Single-quoted strings ≠ template literals, 3. Functions defined above `const I18N` are fine; calls TO them at module load are not, Adoption checklist (per PWA), `applyI18nIn(rootEl)` — post-render hook, Architecture — one system, not two, Auto-speaker on error toasts (v15d), Bilingual EN/HI — DevGuide for 360LM PWAs (+13 more)

### Community 45 - "Learning Hub PWA"
Cohesion: 0.10
Nodes (21): ADR-051: Completion threshold-based, ADR-062: Live AI pipeline contract, ADR-064: Video tutorial production pipeline, ADR-072: Proof image lazy-fetch, ADR-081 safe-bottom CSS, Hub Session Integration, Learning Hub PWA, learn.view_event - Tutorial View Tracking (+13 more)

### Community 46 - "ADR-083: Form Validation Strategy — Client-Side Feedback, Server-Side Enforcement"
Cohesion: 0.10
Nodes (20): ADR-083: Form Validation Strategy — Client-Side Feedback, Server-Side Enforcement, Alternatives Considered, Amount Field with Formatting and Validation, Consequences, Context, Decision, Field Highlighting Pattern, Files and Locations (+12 more)

### Community 47 - "ADR-093: Zero-Backend Standalone PWA — localStorage-Only State with Client-Side PIN Guard"
Cohesion: 0.10
Nodes (20): 1. Full isolated PWA (with its own database), 2. No authentication at all (open access), 3. bcrypt for PIN hashing, 4. IndexedDB instead of localStorage, 5. Store access tokens in localStorage (never expire), ADR-093: Zero-Backend Standalone PWA — localStorage-Only State with Client-Side PIN Guard, Alternatives Considered, Checklist for Creating a New Zero-Backend PWA (+12 more)

### Community 48 - "360LM Architecture Decision Wiki"
Cohesion: 0.10
Nodes (21): 10. Recce & Client Portal, 11. AI & Integrations, 12. Learning Hub, 13. Testing, 14. Maps, 15. Dev Operations & Safety, 16. Platform Standards, 17. Infrastructure & External Integrations (+13 more)

### Community 49 - "package.json"
Cohesion: 0.10
Nodes (20): author, bugs, url, description, devDependencies, @playwright/test, homepage, keywords (+12 more)

### Community 50 - "19. Report Generation & Google Slides (GAS)"
Cohesion: 0.10
Nodes (21): 19.10 Entry Lifecycle (all status fields), 19.11 Submission ID Format, 19.12 `_recceHubUser()` — Agent Identity, 19.13 Two GAS Endpoints — Key Distinction, 19.14 Google Sheet — 107-Column Layout, 19.15 slides_proxy.py — Request Type Matrix, 19.16 GAS Script — Action Routing (`gas_slides.gs`), 19.17 Google Slides — Recce Layout Template (+13 more)

### Community 51 - "WIKI.md"
Cohesion: 0.14
Nodes (11): ADR-010: Cross-Schema or Privileged Data Access Goes Through the Proxy, Not PostgREST Directly, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+3 more)

### Community 52 - "ADR-086: Isolated PWA Architecture — When to Build Standalone Apps with Zero Cross-Access"
Cohesion: 0.10
Nodes (19): 1. Build everything as an ERP PWA (all apps share hub auth, shared DB), 2. Run isolated apps on a completely separate infrastructure (separate VPS, separate DB server), 3. Create a shared "multi-tenant" schema in lm360 for isolated apps, 4. Use a separate PostgreSQL instance for isolated apps (e.g., managed RDS), ADR-086: Isolated PWA Architecture — When to Build Standalone Apps with Zero Cross-Access, Alternatives Considered, Checklist for Creating a New Isolated PWA, Consequences (+11 more)

### Community 53 - "360LM PWA Suite"
Cohesion: 0.14
Nodes (20): 360LM PWA Suite, Access Control / Permission Matrix, Bank Reconciliation Generalized, Customer-wise Rate Overrides, Delivery Challan, eFlexo ERP, General Item Master, Invoice + GST (+12 more)

### Community 54 - "manifest.json"
Cohesion: 0.10
Nodes (19): background_color, description, display, icons, name, orientation, files, text (+11 more)

### Community 55 - "ADR-064 Video Tutorial Production Pipeline — scripts.json → edge-tts → Playwright → ffmpeg"
Cohesion: 0.11
Nodes (18): ADR-064 Video Tutorial Production Pipeline — scripts.json → edge-tts → Playwright → ffmpeg, Alternatives Considered, Consequences, Context, Decision, Directory Structure, Implementation Notes, Reference Implementation (+10 more)

### Community 56 - "software-architect.md"
Cohesion: 0.11
Nodes (18): Architectural Methodology, Before Designing Anything, Before recommending from memory, Design Principles You Enforce, Design Process, Escalation Behaviour, How to save memories, Memory and other forms of persistence (+10 more)

### Community 57 - "Activity PWA - Activity Tracking"
Cohesion: 0.16
Nodes (19): ADR-020: Field PWAs Offline-First — IndexedDB Primary, ADR-024: Google Slides via Google Apps Script Proxy, ADR-026: Cross-PWA Session Bridge via localStorage, ADR-027: Leave-One-Out Faceted Filtering, Activity PWA Icon 192px, Activity PWA Icon 512px, Client PWA Icon 192px, Client PWA Icon 512px (+11 more)

### Community 58 - "record.spec.js"
Cohesion: 0.11
Nodes (10): fs, HC, HR, recorded, STORES, tempCounters, tempSubs, { test, chromium, request: playwrightRequest } (+2 more)

### Community 59 - "ADR-111: Unified Job Record in sales.jobs"
Cohesion: 0.16
Nodes (18): ADR-009: per-PWA schema isolation, ADR-024: Google Slides via GAS proxy, ADR-046: installation.campaigns Canonical Job Record, ADR-067: Cross-PWA Change Safety Gate, ADR-111: Unified Job Record in sales.jobs, custodian.vouchers, Plan: Unified Job Consolidation, 7 Phases of Job Consolidation Plan (+10 more)

### Community 60 - "ADR-077: OpenClaw Integration — Read-Only DB Role, Schema Grants, and Auth Layers"
Cohesion: 0.11
Nodes (17): ADR-077: OpenClaw Integration — Read-Only DB Role, Schema Grants, and Auth Layers, Alternative 1: No Database Access — HTTP-Only via PostgREST, Alternative 2: Superuser or Limited Admin Role, Alternative 3: Virtual Views for OpenClaw Reporting, Alternative 4: Dedicated Postgres Service (separate DB instance), Alternatives Considered, Benefits, Consequences (+9 more)

### Community 61 - "ADR-095: BTL Client Deck Contract — PowerPoint Add-in, Tagged Shape Naming, and 3-Path Extraction"
Cohesion: 0.11
Nodes (17): 1. Client-Side Tool: VBA Macro-Enabled Template (.potm) — Option D, 2. Custom Ribbon Tab: "360LM Branding", 3. Tagged Shape Naming Contract (lm360_* schema), 4. Three-Path Extraction in BTL Extractor Skill (v3), 5. Recognised Item Types, 6. File Locations, ADR-095: BTL Client Deck Contract — PowerPoint Add-in, Tagged Shape Naming, and 3-Path Extraction, Consequences (+9 more)

### Community 62 - "ADR-108: A Generic, Permanent Authenticated-Site Capture & AI-Analysis Service (Codename: SiteCap)"
Cohesion: 0.11
Nodes (18): ADR-108: Generic Authenticated-Site Capture & AI-Analysis Service (SiteCap), 1. Isolation (follows ADR-086, same as Blogsmith/Health Tracker), 2. Core data model, 3. Credential storage — the decision that matters most in this ADR, 4. AI analysis pipeline (ADR-062 compliance, mandatory), 5. What triggers a login — the safety boundary, restated precisely, 6. Legal / ToS — operator responsibility, stated explicitly, 7. Deployment (+10 more)

### Community 63 - "generate_template.py"
Cohesion: 0.28
Nodes (17): _creative_box(), _embed_json(), embed_ribbon(), _footer(), _header_bar(), _items_table(), main(), make_counter_slide() (+9 more)

### Community 64 - "360LM Walkthroughs — manual install on your laptop"
Cohesion: 0.11
Nodes (17): 1. Node 20 or higher, 2. `ssh`, `curl`, `tar`, 360LM Walkthroughs — manual install on your laptop, 3. (Optional) `dig`, 4. Passwordless SSH to the VPS, How this compares to CiC prompts, Install — option A: one-line installer, Install — option B: step-by-step (use if A fails) (+9 more)

### Community 65 - "MDD ↔ ADR Compliance Audit — 2026-07-03"
Cohesion: 0.11
Nodes (16): Full ADR Compliance Sweep — All PWAs — 2026-07-03, Headline, Sources, Sweep methodology note, The `finance` inventory correction (the actually interesting part of this sweep), Finding 1 — Cross-schema access: ADR text vs. actual code (the big one), Finding 2 — MDD citation gap (process compliance), Finding 3 — ADR-001 (`?next=` redirect) — 5 real violations (+8 more)

### Community 66 - "Module Design Document — Activity PWA"
Cohesion: 0.12
Nodes (17): 10. Roles and permissions, 11. Integration touchpoints, 12. Migration (code-verified, /var/www/360lm/activity/), 13. Configuration, 14. Cascading filter engine (Phase 2, v23), 15. Service Worker (v23), 16. Known limitations & future work, 17. Glossary (+9 more)

### Community 67 - "ADR-065 Scene Guide Tutorial Format — JSON Data Contract + Player"
Cohesion: 0.12
Nodes (16): ADR-065 Scene Guide Tutorial Format — JSON Data Contract + Player, Alternatives Considered, Authoring workflow for new Scene Guide, Catalog registration, Consequences, Context, Decision, Field rules (+8 more)

### Community 68 - "ADR-069: Production Hotfix Protocol — Bugfix DB Template, Dev-Branch Fix, Deploy via Master"
Cohesion: 0.12
Nodes (16): ADR-069: Production Hotfix Protocol — Bugfix DB Template, Dev-Branch Fix, Deploy via Master, Alternatives Considered, Consequences, Context, Decision, Implementation Notes, Phase 1: Bugfix DB Setup (Dev Environment), Phase 2: Author and Test the Fix (Dev Code) (+8 more)

### Community 69 - "ADR-074: PostgREST Multi-Schema Routing via Accept-Profile Header"
Cohesion: 0.12
Nodes (17): ADR-074: PostgREST Multi-Schema Routing via Accept-Profile Header, Alternatives Considered, Consequences, Context, Cross-Schema Reads via Views, Decision, Error Handling, Fetch Header Pattern (+9 more)

### Community 70 - "ADR-081: Safe-Area Inset Rendering for Notched and Rounded-Corner Devices"
Cohesion: 0.12
Nodes (16): 1. Bottom Safe Area (home indicator / gesture bar), 2. Top Safe Area (status bar + notch), 3. Left/Right Safe Area (rounded corners in landscape), 4. Implementation Checklist, ADR-081: Safe-Area Inset Rendering for Notched and Rounded-Corner Devices, Alternatives Considered, Consequences, Context (+8 more)

### Community 71 - "ADR-087: Push Notification Implementation Contract — SW Handler, Subscription Payload, and Notification Format"
Cohesion: 0.12
Nodes (16): 1. Subscription Flow (Client-Side), 2. Service Worker Push Handler (Mandatory Structure), 3. Service Worker Notification Click Handler (Mandatory), 4. Notification Payload Contract (Server → Push Server → SW), 5. Storage: hub.push_subscriptions Table, 6. Rules and Mandatory Constraints, 7. Error Handling, ADR-087: Push Notification Implementation Contract — SW Handler, Subscription Payload, and Notification Format (+8 more)

### Community 72 - "ADR-090: Font Size Accessibility Preference — 5-Level Scaling, localStorage Persistence, Init-Time Application"
Cohesion: 0.12
Nodes (16): ADR-090: Font Size Accessibility Preference — 5-Level Scaling, localStorage Persistence, Init-Time Application, Alternatives Considered, Boot Sequence, Consequences, Context, CSS Pattern, Decision, Implementation Notes (+8 more)

### Community 73 - "ADR-091: In-App Onboarding Tour Engine Contract — shared/tour.js Usage, Step Shape, and Dismissal Protocol"
Cohesion: 0.12
Nodes (16): 1. When to Use `tour.js` (vs. Alternatives), 2. API Contract: `initTour(steps, opts)`, 3. Step Shape, 4. Storage Key and Versioning, 5. Dismissal Protocol, 6. UI Contract, 7. Implementation Notes, ADR-091: In-App Onboarding Tour Engine Contract — shared/tour.js Usage, Step Shape, and Dismissal Protocol (+8 more)

### Community 74 - "ADR-106: Cross-Schema Access Today Is Grant-Gated by Convention, Not Enforced by Views or RLS — Ratify Reads, Flag Owner-Bypassing Writes for Remediation"
Cohesion: 0.12
Nodes (16): 1. State the truth plainly, so no other ADR asserts otherwise, 2. Ratify: direct cross-schema **reads** are accepted practice, whether via a foreign purpose-built view or a foreign table with a narrow `select=` projection, 3. Do NOT ratify: a write to a foreign schema's canonical/owner-of-record table for a field that schema's own code also writes through an RPC or trigger-guarded path, 4. The remaining flagged cross-schema writes — now fully characterized (2026-07-03, follow-up pass), ADR-106: Cross-Schema Access Today Is Grant-Gated by Convention, Not Enforced by Views or RLS — Ratify Reads, Flag Owner-Bypassing Writes for Remediation, Alternatives Considered, Consequences, Context (+8 more)

### Community 75 - "Module Design Document — Finance PWA Family"
Cohesion: 0.12
Nodes (17): 10. Migrations applied (chronological), 11. Verification, 12. Glossary, 13. Out-of-scope / future, 1. Why this exists, 2. Inspiration vs scope, 3. Phases (retrospective), 6.1 Fund Custodian PWA (`/finance/custodian/`) (+9 more)

### Community 76 - "ADR-032: expense.employees as FK anchor"
Cohesion: 0.16
Nodes (16): ADR-032: expense.employees as FK anchor, custodian.payees Is Shared Payee Master, transaction_lines Uses Soft Polymorphism, Vendor Catalog Auto-Populated by Trigger, Custodian Reactivation Limited and Full Mode, Cross-Schema Active-State Sync Trigger, Vendor Rate Card Baseline Is Latest by created_at, sales.catalog Is Shared Product Master (+8 more)

### Community 77 - "ADR-062 Live AI Pipeline Contract"
Cohesion: 0.12
Nodes (15): 1. Auth / Fallback Chain (server-side, in proxy), 2. Human-Review Gate (client-side, mandatory), 3. Loading UX (client-side, mandatory), 4. Graceful Degradation, 5. Endpoint Contract, 6. When NOT to use a live AI pipeline (defer to ADR-056), ADR-062 Live AI Pipeline Contract, Alternatives Considered (+7 more)

### Community 78 - "ADR-063 AI-Assisted Development Toolchain"
Cohesion: 0.12
Nodes (15): 1. MCP Servers, 2. Key Custom Agent Types, 3. Key Skills, 4. Model and Effort Settings (`/root/.claude/settings.json`), 5. Behavioural Rules (`/var/www/360lm/CLAUDE.md`), ADR-063 AI-Assisted Development Toolchain, Alternatives Considered, Consequences (+7 more)

### Community 79 - "ADR-092: User Preference Cascading Fallback — DB → localStorage → Hardcoded Default"
Cohesion: 0.12
Nodes (15): ADR-092: User Preference Cascading Fallback — DB → localStorage → Hardcoded Default, Alternatives Considered, Consequences, Context, DB Contract for Employee-Tier Preferences, Decision, Device-Tier Preference Pattern (2-Level, No DB), Employee-Tier Preference Pattern (3-Level Fallback) (+7 more)

### Community 80 - "15 Test Transfers (Chronological)"
Cohesion: 0.12
Nodes (16): 15 Test Transfers (Chronological), T10 · Gurpreet → Harish · ₹2,000 · Cash · 16-May · `accepted`, T11 · Pramod → Gurpreet · ₹1 · Cash · 16-May · `auto_accepted`, T12 · Shambhu → Harish · ₹7,500 · Cash · 17-May · `rejected`, T13 · Gurpreet → Pramod · ₹3,000 · Cash · 18-May · `rejected`, T14 · Shambhu → Harish · ₹3,000 · Cash · 20-May · seeded as `pending`, T15 · Gurpreet → Harish · ₹800 · Cash · 20-May · seeded as `pending`, T1 · Pramod → Shambhu · ₹25,000 · IMPS · 5-May · `auto_accepted` (+8 more)

### Community 81 - "Sales PWA Billing Chain Manual Testing Guide (Stages A-G)"
Cohesion: 0.13
Nodes (16): BUG-4 body stream already read fix, Salary Advance Recovery CiC Re-Run (Run 3), HR PWA Service Worker 360hr-v7, Custodian-HR Cross-PWA Advance Recovery Verification, hr.pay_salary_slip RPC, Salary Advance Recovery Walkthrough (Run 2), 360 Degree Logical Marketing (360DLM) Company, Custodian Settlement Loop Stage G (+8 more)

### Community 82 - "Signage Manufacturing Fundamentals - Reference Research"
Cohesion: 0.12
Nodes (16): Signage Manufacturing Fundamentals - Reference Research, Backer-panel mount, Standardized BOM/cost-multiplier templates, Channel letters 5-component BOM, Costing knowledge base: nothing public/comprehensive exists, Fabrication process workflow, Fabrication waste rates and QC tolerances are NOT documented, Fire NOC size thresholds (Indian cities) (+8 more)

### Community 83 - "Module Design Document — Expense PWA (Employee Expense Tracking & Approval)"
Cohesion: 0.12
Nodes (16): 10. Categories and metadata, 11. Dual-currency (planned, not live), 13. Known limitations and open items, 13a. ADRs governing this module, 15. Retrospective: how this was built, 16. Glossary, 1. Why this exists, 2. Scope and design approach (+8 more)

### Community 84 - "excel_parser.py"
Cohesion: 0.20
Nodes (15): clean_phone(), detect_column_roles(), detect_header_row(), extract_filename_hints(), extract_pincode_from_text(), get_cell_value(), main(), parse_sheet() (+7 more)

### Community 85 - "Work Section (Films)"
Cohesion: 0.12
Nodes (16): Work Section (Films), Blossom (Film #7), Dadu Ka Ghar (Film #8), Diet Coke (Film #17), Earbuds (Film #15), Evening Study (Film #6), For Their Eyes (Film #10), Golden Hour (Film #5) (+8 more)

### Community 86 - "build_tutorial.py"
Cohesion: 0.28
Nodes (14): build_app_card(), build_clip(), build_lang(), build_title_card(), concat_mp4s(), main(), probe_duration(), Black title card with section number + title, muxed with audio. (+6 more)

### Community 87 - "ADR-110: Custodian Voucher Booking Writes creditcard.ad_hoc_charges via SECURITY DEFINER RPC, Not Client-Side Fetch"
Cohesion: 0.13
Nodes (15): ADR-007, ADR-010, ADR-106 (cross-schema-write framework), Atomicity, Bare client-side fetch() POST, creditcard.ad_hoc_charges table, Cross-schema write, custodian.apply_structural_edit (+7 more)

### Community 88 - "ADR-079: Shared Helper Governance — /shared/ Directory Structure, Adoption Policy, and Breaking Change Protocol"
Cohesion: 0.13
Nodes (14): 1. Criteria for a Helper to Belong in `/shared/`, 2. Breaking Changes to Shared Helpers, 3. Adding a New Shared Helper, 4. Copy-Verbatim (NOT Shared) Helpers, ADR-079: Shared Helper Governance — /shared/ Directory Structure, Adoption Policy, and Breaking Change Protocol, Alternatives Considered, Consequences, Context (+6 more)

### Community 89 - "ADR-105: Hub Issues a Signed JWT Alongside the localStorage Session — For Proxy Services and Future Native Clients Only"
Cohesion: 0.13
Nodes (14): 1. What stays exactly as-is (ADR-011, ADR-012, ADR-026, ADR-080 unchanged), 2. What's new, 3. Who has to use it, 4. What is explicitly OUT of scope for this ADR, ADR-105: Hub Issues a Signed JWT Alongside the localStorage Session — For Proxy Services and Future Native Clients Only, Alternatives Considered, Consequences, Context (+6 more)

### Community 90 - "360LM BTL Add-in — Client Install Guide"
Cohesion: 0.13
Nodes (14): 360LM BTL Add-in — Client Install Guide, Adding a counter, Attaching creatives, Daily Use, One-time Setup (Windows PowerPoint Desktop only), Sending to 360LM, Shape naming convention (for 360LM internal use), Step 1 — Enable the Developer tab (+6 more)

### Community 91 - "hub/index.html"
Cohesion: 0.13
Nodes (15): .btn-primary class, /db/rpc/verify_pin, #dev-banner element, hub/index.html, .hub-main-tile class, .hub-qa-tile class, Manrope font, .modal-box class (+7 more)

### Community 92 - "build_tutorial.py"
Cohesion: 0.28
Nodes (14): build_app_card(), build_clip(), build_lang(), build_title_card(), concat_mp4s(), main(), probe_duration(), Black title card with section number + title, muxed with audio. (+6 more)

### Community 93 - "India 2024 Polaroid Series"
Cohesion: 0.13
Nodes (15): Street Photograph #1 (India 2024), Street Photograph #2 (India 2024), Street Photograph #3 (India 2024), India 2024 Polaroid Series, Photograph #4 (India 2024), Photograph #5 (India 2024), Photograph #6 (India 2024), Photograph #7 (India 2024) (+7 more)

### Community 94 - "build_tutorial.py"
Cohesion: 0.28
Nodes (14): Black title card with section number + title, muxed with audio., # NOTE: vf must NOT begin with 'color='; the input is already the color source., Opening/closing card with app name., Concatenate MP4 segments → H.264 master at CRF 18 with faststart.     H.265 is N, Build tutorial video for one language. Returns output path or None on failure., build_app_card(), build_clip(), build_lang() (+6 more)

### Community 95 - "build_tutorial.py"
Cohesion: 0.28
Nodes (14): build_app_card(), build_clip(), build_lang(), build_title_card(), concat_mp4s(), main(), probe_duration(), Black title card with section number + title, muxed with audio. (+6 more)

### Community 96 - "build_tutorial.py"
Cohesion: 0.28
Nodes (14): build_app_card(), build_clip(), build_lang(), build_title_card(), concat_mp4s(), main(), probe_duration(), Black title card with section number + title, muxed with audio. (+6 more)

### Community 97 - "admin-draft-view-init.md"
Cohesion: 0.13
Nodes (14): 11. Admin System, 12. Draft System, 13. View / Report System, 14. Initialization (`init`), Admin Home (when unlocked), Admin Session, Auto-unlock, Edit Mode (`editRecce(id)`) (+6 more)

### Community 98 - "manifest.json"
Cohesion: 0.13
Nodes (14): background_color, categories, description, dir, display, icons, lang, name (+6 more)

### Community 99 - "ADR-113: Email and Indian Mobile Inputs Validate Format by Default — Platform-Native Pattern + checkValidity, No Validation Library"
Cohesion: 0.14
Nodes (14): ADR-013, ADR-076, ADR-083, ADR-100, activity/index.html reference implementation, checkValidity() method, fieldFormatError() function, <input type="email"> (+6 more)

### Community 100 - "ADR-114 Google AI Access Uses OAuth/ADC Service Identity via Vertex AI"
Cohesion: 0.16
Nodes (14): ADR-062 Live AI Pipeline Contract, dbt_pending.md, ADR-114 Google AI Access Uses OAuth/ADC Service Identity via Vertex AI, GCP project provisioning tasks, gemini CLI + personal Google OAuth, Google Gemini Models, google-auth library, google.generativeai SDK (+6 more)

### Community 101 - "ADR-016: Every New PWA Must Register in hub.pwa_registry"
Cohesion: 0.14
Nodes (13): ADR-016: Every New PWA Must Register in hub.pwa_registry, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+5 more)

### Community 102 - "ADR-068: VCC Pre-Build Safety Checklist — Mandatory Bug Prevention Standard"
Cohesion: 0.14
Nodes (13): ADR-068: VCC Pre-Build Safety Checklist — Mandatory Bug Prevention Standard, Alternatives Considered, Consequences, Context, Decision, Example workflow, For developers, For the project (+5 more)

### Community 103 - "ADR-070: All User-Facing Timestamps Displayed in IST (UTC+5:30)"
Cohesion: 0.14
Nodes (14): ADR-070: All User-Facing Timestamps Displayed in IST (UTC+5:30), Alternatives Considered, Audit Pattern, Claude's Reporting to Users, Consequences, Context, Decision, Handling Daylight Saving Time (+6 more)

### Community 104 - "ADR-082: Dark Mode and Theming Architecture — Forced Light Mode for ERP PWAs, Dark UI for Standalone Apps"
Cohesion: 0.14
Nodes (13): ADR-082: Dark Mode and Theming Architecture — Forced Light Mode for ERP PWAs, Dark UI for Standalone Apps, Alternatives Considered, Consequences, Context, Decision, For existing ERP PWAs, For new ERP PWAs (check before ship):, For standalone apps (no changes): (+5 more)

### Community 105 - "index.html (Learning Hub PWA)"
Cohesion: 0.18
Nodes (14): API constant, buildCatalog function, buildTeamTable function, checkAuth function, EMP_NAMES constant, get function, index.html (Learning Hub PWA), init function (+6 more)

### Community 106 - "Schema: `print_estimation`"
Cohesion: 0.14
Nodes (14): 4.1 `substrate_master`, 4.2 `ink_master`, 4.3 `plate_cost_config`, 4.4 `wastage_config`, 4.5 `estimate` (Master Estimate Record), 4.6 `estimate_line`, 4.7 `actual_consumption` (Variance Tracking, Phase 2), 4.8 `estimate_revision` (Immutability Support, §8) (+6 more)

### Community 107 - "manifest.json"
Cohesion: 0.14
Nodes (13): background_color, categories, description, display, display_override, icons, lang, name (+5 more)

### Community 108 - "Module Design Document — Stores PWA"
Cohesion: 0.14
Nodes (13): 10. ADR references, 11. Deployment checklist (Phase 2 post-mortem), 12. Known limitations + future, 12a. ADRs governing this module, 1. Why this exists, 2. Inspiration vs scope, 3. Phases (RETROSPECTIVE), 6. Auth + access (+5 more)

### Community 109 - "MDD — EXTENSION: Manual Tour Planner + Hub wiring (`tour-pg-v19`)"
Cohesion: 0.14
Nodes (14): E10. Out of scope (this extension), E11. Risks, E12. Files touched, E13. Done = ready check  ✅ SHIPPED 2026-06-06 (tour-pg-v19 · proxy 0.3.0), E1. Intent, E2. Decisions captured (from interactive Q&A — my reading of your notes; correct any here), E3. Architecture (the load-bearing decisions), E4. Navigation graph (every screen has a back affordance + name pill) (+6 more)

### Community 110 - "package.json"
Cohesion: 0.14
Nodes (13): bin, walkthrough, dependencies, playwright, description, engines, node, license (+5 more)

### Community 111 - "ADR-001 All PWAs Pass ?next= When Redirecting to Hub Login"
Cohesion: 0.15
Nodes (13): _bindTracking() function, _endView() function, _startView() function, ADR-001 All PWAs Pass ?next= When Redirecting to Hub Login, Branding Recce PWA, DM Sans font, finance/custodian/tutorial/tutorial.html, #tutorial-video element (+5 more)

### Community 112 - "Activity — Tutorial"
Cohesion: 0.15
Nodes (13): Auth gate (IIFE), _bindTracking() function, .chapters Component (Chapter Index), /db/rpc/end_view RPC, /db/rpc/start_view RPC, Activity — Tutorial, .lang-bar Component, lm360-session (localStorage) (+5 more)

### Community 113 - "Custodian Expense Voucher module"
Cohesion: 0.15
Nodes (13): ADR-106 Cross-Schema Access Today Is Grant-Gated by Convention, creditcard.ad_hoc_charges, custodian.advance_settlements, Custodian Expense Voucher module, Custodian PWA, custodian schema, ADR-007: Trigger Functions Use SECURITY DEFINER, ADR-008: PL/pgSQL #variable_conflict use_column (+5 more)

### Community 114 - "ADR-041: Replacing an Engaged Official Recce Record Uses Supersede Flow, Not Update-in-Place"
Cohesion: 0.15
Nodes (12): ADR-041: Replacing an Engaged Official Recce Record Uses Supersede Flow, Not Update-in-Place, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Scenario 1 — Corrected Recce replacing engaged official (+4 more)

### Community 115 - "ADR-098: Native Web Page Is the Primary Client Branding Approval Channel — PPTX/Excel Are Fallbacks"
Cohesion: 0.15
Nodes (12): 1. Native web (s-respond screen) is the primary channel, 2. PPTX and Excel are fallbacks, not replacements, 3. Last-write-wins per branding item, 4. Photo proxy extends ADR-049 — same HMAC token, new route, 5. overall client_status is derived server-side from per-item decisions, ADR-098: Native Web Page Is the Primary Client Branding Approval Channel — PPTX/Excel Are Fallbacks, Consequences, Context (+4 more)

### Community 116 - "Tour Playground v12 Mobile Walkthrough (Field Mapping + Native Scroll)"
Cohesion: 0.18
Nodes (13): Matrix + 2-opt Heuristic Routing (13-30 stops), TomTom computeBestOrder Route Optimisation, Tour Planner Playground Manual Testing Guide, Tour PG Proxy Service, Field Mapping Table Column Reversal (v12), Native Page Scroll Editor (v12 mobile fix), Tour Playground v12 Mobile Walkthrough (Field Mapping + Native Scroll), Manual Tour Planner (no Excel) Feature v19 (+5 more)

### Community 117 - "UPI Pay and Vendor Management Cross-PWA Walkthrough"
Cohesion: 0.21
Nodes (13): custodian.payee_methods Shared Table, custodian.payees Shared Table, Soft Delete Cross-PWA Propagation, UPI Pay PWA (upi-v2), UPI Pay and Vendor Management Cross-PWA Walkthrough, Vendor Management PWA (vendors-v4), Vendor Management Test Data Cleanup Script, Custodian Transfer Line Items (+5 more)

### Community 118 - "ADR-107: `/mdd-reverse` ADR Verification Is an Active Per-Pattern Checklist, Not a Passive Citation Instruction — And Its Exemplars Must Model That"
Cohesion: 0.17
Nodes (11): ADR-107: `/mdd-reverse` ADR Verification Is an Active Per-Pattern Checklist, Not a Passive Citation Instruction — And Its Exemplars Must Model That, Alternatives Considered, Consequences, Context, Decision, Empirical validation (same day, before Accept), References, Related Decisions (+3 more)

### Community 119 - "Brevo domain authentication — 360degreelogicalmktg.com"
Cohesion: 0.17
Nodes (11): Add records 1, 2, 3, 5 (four new records), After authentication = true, Backout, Brevo domain authentication — 360degreelogicalmktg.com, DNS propagation check (from VPS), Modify record 4 (SPF), Records to add at Hostinger DNS, Records to NOT touch (existing, used by Google Workspace) (+3 more)

### Community 120 - "Recce Client Portal Test Setup Guide"
Cohesion: 0.21
Nodes (12): Bulk Response Feature for Recce Client Portal, Magic Link Client Invite System, Recce Client Portal Approval/Rejection Walkthrough, Recce Client Portal PWA, counters.client_invite Table, HP India Test Client Entity, Recce Client Portal Test Setup Guide, Counter vs Customer Distinction (+4 more)

### Community 121 - "CLAUDE.md"
Cohesion: 0.17
Nodes (11): adr-kit, Agent orchestration (2-core VPS), graphify, markitdown MCP — Limitation Gate, MEMORY COMPACTION RULES, Model routing, PLAYWRIGHT TEST RUNNER, ponytail (+3 more)

### Community 122 - "Production PWA"
Cohesion: 0.20
Nodes (12): currentOrder variable, DB constant, Hub PWA, Learning Hub PWA, newItems array, OC Contact Import PWA, Print Nest PWA, Production PWA (+4 more)

### Community 123 - "ADR-019: OCR Strategy — Client-Side for Docs, Server-Side for Photos"
Cohesion: 0.26
Nodes (12): ADR-019: OCR Strategy — Client-Side for Docs, Server-Side for Photos, ADR-025: Self-Hosted Ollama for AI Inference, Dispatch PWA Icon 192px, Dispatch PWA Icon 512px, Dispatch PWA - Dispatch Management, Expense PWA - Expense Tracking, HR PWA - Human Resources, Dispatch AI Service (port 8767) (+4 more)

### Community 124 - "Step-by-Step"
Cohesion: 0.17
Nodes (11): 1. Clone prod DB to a bugfix environment, 2. Reproduce the bug, 3. Author the fix on the dev branch, 4. Test on bugfix environment, 5. Promote to production, 6. Tear down bugfix environment, Cross-PWA Bug Notes, Production Hotfix Protocol (+3 more)

### Community 125 - "360DLM ERP-Lite — Software Landscape Research & Roadmap Inputs"
Cohesion: 0.17
Nodes (12): 0. Executive summary, 10. Recommended action queue, 1. What the adversarial verification actually confirmed (and killed), 360DLM ERP-Lite — Software Landscape Research & Roadmap Inputs, 3. Domain 2 — Branding fabrication & signage installation, 4. Domain 3 — Event management & production, 5. Domain 4 — Digital marketing services (future arm), 6. Domain 5 — AI & automation services for SMEs (future arm) (+4 more)

### Community 126 - "manifest.json"
Cohesion: 0.17
Nodes (11): background_color, categories, description, display, icons, lang, name, orientation (+3 more)

### Community 127 - "5. Screen Architecture (7 views)"
Cohesion: 0.17
Nodes (11): 5. Screen Architecture (7 views), 6. Overlay / Modal System (z-index layers), Annotation Modal (branding photos only), Bottom Dialogs, View 1 — Home (`#view-home`), View 2 — Settings (`#view-settings`), View 3 — Form Step 1: Store Details (20%), View 4 — Form Step 2: Store Photos (40%) (+3 more)

### Community 128 - "Module Design Document — Yagya Narang Cinematographer Portfolio"
Cohesion: 0.17
Nodes (11): 1. Why this exists, 2. Design & UX (verified 2026-06-23), 3. Content inventory, 4. File structure, 5. Deployment & hosting, 6. Tooling, 7. Verification, 8. Out of scope for 360LM PWA (+3 more)

### Community 129 - "Admin Access"
Cohesion: 0.18
Nodes (11): Admin Access, Claude Desktop remote coding, ADR-115 Tailscale Mesh Is the Standing Admin-Access Fallback When ISP Routing Breaks the Public Path, Hostinger VPS, ISP Routing Failure, SFTP, SSH, Tailnet (+3 more)

### Community 130 - "Sales PWA"
Cohesion: 0.18
Nodes (11): Finance Is Family of Focused Mini-PWAs Not Monolith, BTL Installation PWA, Customers Mini-PWA, Dispatch PWA, Finance (Custodian) PWA, Vendor Management PWA, Hub PWA (Sales MDD), Recce PWA (+3 more)

### Community 131 - "ADR-072-proof-image-capture-annotation.md"
Cohesion: 0.18
Nodes (10): Affected PWAs, Constraints, Context, Decision, Decision Maker, Implementation Rule, References, Status (+2 more)

### Community 132 - "ADR-109 VideoSmith — Isolated PWA Wrapping an Internal-Only Third-Party Engine, With the AI Chain Owned by the Wrapper"
Cohesion: 0.18
Nodes (10): ADR-109 VideoSmith — Isolated PWA Wrapping an Internal-Only Third-Party Engine, With the AI Chain Owned by the Wrapper, Alternatives Considered, Consequences, Context, Decision, Implementation Notes, References, Related Decisions (+2 more)

### Community 133 - "ADR-NNN Short Imperative Title"
Cohesion: 0.18
Nodes (10): ADR-NNN Short Imperative Title, Alternatives Considered, Consequences, Context, Decision, Implementation Notes, References, Related Decisions (+2 more)

### Community 134 - "ADR Generator Agent"
Cohesion: 0.22
Nodes (10): What happens next, What I do, What I need from you, When to call me, ADR Generator Agent, Ponytail - Lazy Senior Dev Mode, CLAUDE.md - 360lm Project Instructions, ADR Skill - Architecture Decision Record Management (+2 more)

### Community 135 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, display, icons, lang, name, orientation, scope, short_name (+2 more)

### Community 136 - "FundCustodian CiC Test Data Reference"
Cohesion: 0.22
Nodes (10): Advance Return Flow CiC Test (Custodian v7), FundCustodian Guided Walkthrough (22 Steps), FundCustodian CiC Test Data Reference, System Design in One Paragraph, The 3 Trigger Rules (Core Logic), The 4 Custodians, Wallet Balance Derivation (After Full Seed + CiC Acceptance of T14 & T15), What the Test Data Covered (+2 more)

### Community 137 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, lang, name, orientation, short_name (+2 more)

### Community 138 - "2. Image Capture — Proof, Receipt & Verification"
Cohesion: 0.22
Nodes (10): 1. Amount Input — Indian Number Formatting, 2. Image Capture — Proof, Receipt & Verification, 3. Change History, Canonical implementation, Confirmation prompt for Claude, Input & Image Standards — 360LM PWAs, Key implementation details, Storage (+2 more)

### Community 139 - "Module Design Document: VideoSmith — AI Short-Form Video Generation PWA"
Cohesion: 0.18
Nodes (10): 10. Red-Team: Concrete Failure Modes, 11. Acceptance Criteria, 12. References & Related Decisions, 13. Build Log & Lessons Learned (2026-07-03), 15. Detailed-Scenario Input (2026-07-03, later same day), 16. Multi-Channel Upload-Post Support (2026-07-03, later same day), 1. Why This Exists, 9. ADR Compliance Checklist (Per ADR-107 Discipline) (+2 more)

### Community 140 - "360DLM vs. "Lite ERP" Baseline — Gap Analysis (eFlexo-anchored)"
Cohesion: 0.18
Nodes (11): 0. Method note — why this isn't just "eFlexo's feature list", 1.1 Print-industry-specific (not baseline — exclude from gap scoring), 1.2 Generic — looks print-specific but isn't (flagged explicitly per the review above), 1.3 Generic lite-ERP baseline (the actual comparison set), 1. eFlexo's full captured inventory, split by vertical-specificity, 2.4 Dashboard tile-by-tile breakdown, 2. Gap matrix — generic baseline vs. 360LM today, 360DLM vs. "Lite ERP" Baseline — Gap Analysis (eFlexo-anchored) (+3 more)

### Community 141 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 142 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 143 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 144 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 145 - "Module Design Document — Creative Intake & Print Pipeline (CDR → check → TIF)"
Cohesion: 0.18
Nodes (10): 1. Why this exists, 2. Format & spec findings (verified 2026-07-02 on the IdeaPad sample), 3. Phases planned, 4.1 Read stack (decision table), 4.2 cad-proxy MCP extensions (Phase 0 assets to add), 4.3 Open items (Phase 0 checklist), 4. Phase 0 — capability assets, 5. Data contracts (for Phases 1–2; designed now, built later) (+2 more)

### Community 146 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 147 - "pwa_dev_style.md"
Cohesion: 0.18
Nodes (8): PWA Dev Style Guide — 360LM (Index), Related mandatory standards, Starting a NEW PWA?, Topic references (`docs/style/`), 15. Service Worker, 16. Utility Functions, 17. Known Code Notes, 18. Design Patterns Summary

### Community 148 - "record.spec.js"
Cohesion: 0.22
Nodes (7): addViaGallery(), fillStoreStep(), path, PHOTOS, reachAdditionalStep(), { test, chromium }, VIDEOS

### Community 149 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 150 - "MDD: Customer Management Mini-PWA"
Cohesion: 0.18
Nodes (11): DB: sales.customer_addresses table, DB: sales.communications polymorphic log (Phase 4), DB: sales.customer_contacts table, DB View: sales.customer_360 lifetime stats (Phase 5), DB: sales.customers table, DB View: sales.customers_v (enriched), DB: sales.leads table (Phase 3), DB: Lookup tables (customer_groups/territories/industries) Phase 5 (+3 more)

### Community 151 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, name, orientation, scope, short_name (+2 more)

### Community 152 - "maps-client.js"
Cohesion: 0.33
Nodes (9): bearer(), directions(), distanceMatrix(), geocode(), mcpCall(), placesNearby(), reverseGeocode(), routeTraffic() (+1 more)

### Community 153 - "custodian_voucher_tutorial.spec.js"
Cohesion: 0.20
Nodes (6): fs, loginAsHarish(), makeSession(), path, { test, expect, devices }, VIDEOS_DIR

### Community 154 - "drive_consolidator.spec.js"
Cohesion: 0.44
Nodes (10): connectNextAccount(), enterTestPIN(), goToDedup(), goToTransferWithFiles(), injectGISMock(), loginAfterGoto(), mockGoogleAPIs(), seedAndLogin() (+2 more)

### Community 155 - "MDD_tour_pg.md"
Cohesion: 0.18
Nodes (10): Excel Input Contract (Required: name/address; Optional: city, lat/lng, phone, notes), Extension v20: Geographical Classification + Dual-Mode Dashboard, Extension v21: Org-wide History Sharing + Token-AND Search, Extension v19: Manual Tour Planner (Start/Destination Picker, Generalized fixloc), LocalStorage Schema (Saved tours with origin, stops, metadata), Matrix Chunking Strategy (TomTom 196-cell limit; 9-origin chunks for ≥14 stops), Phase 1: TomTom MCP Extension (computeBestOrder), Phase 2: Tour-pg Proxy (Node.js, Hub Auth, Maps Routing) (+2 more)

### Community 156 - "Module Design Document — Tour Planner Playground (`tour-pg`)"
Cohesion: 0.18
Nodes (11): 10. Risks + open items, 11. Done = ready for production check, 1. Intent, 2. User decisions captured, 3. Architecture, 5. Excel format (the input contract), 6. UX rules, 7. Mid-tour replan (the user's "day's halt" case) (+3 more)

### Community 157 - "G. Phase 4.17 — Org-wide History Sharing + Token-AND Search ✅ SHIPPED 2026-07-04"
Cohesion: 0.18
Nodes (11): F3. Schema changes, G1. Intent, G2. Decisions captured (interactive Q&A), G4. Proxy changes (`/opt/tour-pg-proxy/server.js`), G5. Frontend — sharing UI (`tour-pg/index.html`), G6. Search — "Token-AND Search" (house-wide term, coined this phase), G7. Verification, G9. Done = ready check ✅ SHIPPED 2026-07-04 (+3 more)

### Community 158 - "manifest.json"
Cohesion: 0.18
Nodes (10): background_color, description, display, icons, lang, name, orientation, short_name (+2 more)

### Community 159 - "vrs/index.html"
Cohesion: 0.18
Nodes (11): vrs/index.html, vrs/manifest.json, Register Hired Vehicle Modal (VRS), Approve - Hired Vehicle Modal (VRS), New Vehicle Request Modal (VRS), Request Detail Modal (VRS), All Requests Screen (VRS), Approvals Screen (VRS) (+3 more)

### Community 160 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, description, display, icons, name, orientation, short_name, start_url (+1 more)

### Community 161 - "Module Design Document — Client PWA"
Cohesion: 0.20
Nodes (8): 1. Purpose, 2. Schema, 3. Status and next steps, 4. Governance, 4a. ADRs governing this module, 5. Verification, Module Design Document — Client PWA, Cascading Filter Engine with Leave-One-Out Faceting

### Community 162 - "ADR-116: Learning Hub Context-Specific Deep-Linking from PWA Headers"
Cohesion: 0.20
Nodes (10): ADR-016 Every New PWA Must Register in hub.pwa_registry, ADR-051 Learning Completion Is Threshold-Based, ADR-064 Video Tutorial Production Pipeline, ADR-065 Scene Guide Tutorial Format, ADR-100 Visual Design via theme-v2.css Token Presets, ADR-116: Learning Hub Context-Specific Deep-Linking from PWA Headers, pwa_dev_style.md, PWA Headers (+2 more)

### Community 163 - "ADR-002: Every PWA Must Link shared/safe-bottom.css"
Cohesion: 0.20
Nodes (9): ADR-002: Every PWA Must Link shared/safe-bottom.css, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 164 - "ADR-003: Long Lists Must Scroll the Root Document, Not a Nested Container"
Cohesion: 0.20
Nodes (9): ADR-003: Long Lists Must Scroll the Root Document, Not a Nested Container, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 165 - "ADR-004: Maps Strategy — Google Primary, TomTom for Traffic/Matrix/Truck + Auto-Failover"
Cohesion: 0.20
Nodes (9): ADR-004: Maps Strategy — Google Primary, TomTom for Traffic/Matrix/Truck + Auto-Failover, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 166 - "ADR-005: Service Worker Cache Busting via CACHE_VER String, Not skipWaiting"
Cohesion: 0.20
Nodes (9): ADR-005: Service Worker Cache Busting via CACHE_VER String, Not skipWaiting(), Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 167 - "ADR-006: verify_pin RPC Returns a TABLE Array, Not a Success Boolean"
Cohesion: 0.20
Nodes (9): ADR-006: verify_pin RPC Returns a TABLE Array, Not a Success Boolean, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 168 - "ADR-008: PL/pgSQL RETURNS TABLE Functions Must Declare #variable_conflict use_column"
Cohesion: 0.20
Nodes (9): ADR-008: PL/pgSQL RETURNS TABLE Functions Must Declare #variable_conflict use_column, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 169 - "ADR-012: Hub PWA Is the Single SSO Gateway for All Employee-Facing PWAs"
Cohesion: 0.20
Nodes (9): ADR-012: Hub PWA Is the Single SSO Gateway for All Employee-Facing PWAs, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 170 - "ADR-013: Each PWA Is a Single Self-Contained HTML File — No Framework, No Build Pipeline"
Cohesion: 0.20
Nodes (9): ADR-013: Each PWA Is a Single Self-Contained HTML File — No Framework, No Build Pipeline, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 171 - "ADR-015: Dev and Prod Are Two Full Stacks on the Same VPS, Not Branches or Feature Flags"
Cohesion: 0.20
Nodes (9): ADR-015: Dev and Prod Are Two Full Stacks on the Same VPS, Not Branches or Feature Flags, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 172 - "ADR-017: All Service Routing Uses Traefik + Docker Labels — No Nginx Config Files"
Cohesion: 0.20
Nodes (9): ADR-017: All Service Routing Uses Traefik + Docker Labels — No Nginx Config Files, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 173 - "ADR-018: External Client Authentication Uses Company Code + Access Code, Not Employee PIN"
Cohesion: 0.20
Nodes (9): ADR-018: External Client Authentication Uses Company Code + Access Code, Not Employee PIN, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 174 - "ADR-019: OCR Strategy — Client-Side Tesseract for Identity Docs, Server-Side Proxy for Bill Photos"
Cohesion: 0.20
Nodes (9): ADR-019: OCR Strategy — Client-Side Tesseract for Identity Docs, Server-Side Proxy for Bill Photos, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 175 - "ADR-020: Field PWAs Are Offline-First — IndexedDB Primary, Server Sync Secondary"
Cohesion: 0.20
Nodes (9): ADR-020: Field PWAs Are Offline-First — IndexedDB Primary, Server Sync Secondary, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 176 - "ADR-021: Service Worker Uses Cache-First Strategy with Network Fallback"
Cohesion: 0.20
Nodes (9): ADR-021: Service Worker Uses Cache-First Strategy with Network Fallback, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 177 - "ADR-022: Playwright Is the E2E Test Framework — One Spec File Per PWA"
Cohesion: 0.20
Nodes (9): ADR-022: Playwright Is the E2E Test Framework — One Spec File Per PWA, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 178 - "ADR-023: Push Notifications Use Self-Hosted VAPID Server, Not FCM or Third-Party"
Cohesion: 0.20
Nodes (9): ADR-023: Push Notifications Use Self-Hosted VAPID Server, Not FCM or Third-Party, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 179 - "ADR-024: Google Slides/Sheets Integration Uses Google Apps Script via Self-Hosted Proxy"
Cohesion: 0.20
Nodes (9): ADR-024: Google Slides/Sheets Integration Uses Google Apps Script via Self-Hosted Proxy, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 180 - "ADR-025: Self-Hosted Ollama Runs Alongside Cloud AI for Vision and Text Inference"
Cohesion: 0.20
Nodes (9): ADR-025: Self-Hosted Ollama Runs Alongside Cloud AI for Vision and Text Inference, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 181 - "ADR-026: Cross-PWA Session Handoff Uses Shared localStorage on Same Origin"
Cohesion: 0.20
Nodes (9): ADR-026: Cross-PWA Session Handoff Uses Shared localStorage on Same Origin, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 182 - "ADR-027: Multi-Dimension List Filtering Uses Leave-One-Out Faceted Availability"
Cohesion: 0.20
Nodes (9): ADR-027: Multi-Dimension List Filtering Uses Leave-One-Out Faceted Availability, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 183 - "ADR-029: Employee Access Control Is Dual-Written to DB and hub-access.json"
Cohesion: 0.20
Nodes (9): ADR-029: Employee Access Control Is Dual-Written to DB and hub-access.json, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 184 - "ADR-030: No <select> for More Than 5 Options — Use Searchable Type-Ahead or Chip-Grid"
Cohesion: 0.20
Nodes (9): ADR-030: No <select> for More Than 5 Options — Use Searchable Type-Ahead or Chip-Grid, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 185 - "ADR-031: Complex Forms Use Full-Screen Overlays — Modals Only for Simple Confirmations"
Cohesion: 0.20
Nodes (9): ADR-031: Complex Forms Use Full-Screen Overlays — Modals Only for Simple Confirmations, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 186 - "ADR-032: expense.employees Is the Canonical Employee Identity Table — Cross-Schema FK Anchor"
Cohesion: 0.20
Nodes (9): ADR-032: expense.employees Is the Canonical Employee Identity Table — Cross-Schema FK Anchor, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 187 - "ADR-033: Expense Approval RPC Atomically Deducts Impress in One DB Transaction"
Cohesion: 0.20
Nodes (9): ADR-033: Expense Approval RPC Atomically Deducts Impress in One DB Transaction, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 188 - "ADR-034: HR Salary Payment RPC Cross-Writes to finance.transactions"
Cohesion: 0.20
Nodes (9): ADR-034: HR Salary Payment RPC Cross-Writes to finance.transactions, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 189 - "ADR-035: Screenshot Protection Uses CSS/JS Deterrence — OS-Level Enforcement Is Not Available in PWA"
Cohesion: 0.20
Nodes (9): ADR-035: Screenshot Protection Uses CSS/JS Deterrence — OS-Level Enforcement Is Not Available in PWA, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 190 - "ADR-036: custodian.payees Is the Shared Payee Master Across All Payment-Facing PWAs"
Cohesion: 0.20
Nodes (9): ADR-036: custodian.payees Is the Shared Payee Master Across All Payment-Facing PWAs, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 191 - "ADR-037: transaction_lines Uses Soft Polymorphism — source_id Has No FK Constraint"
Cohesion: 0.20
Nodes (9): ADR-037: transaction_lines Uses Soft Polymorphism — source_id Has No FK Constraint, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 192 - "ADR-038: Vendor Catalog Is Auto-Populated by Trigger on Transaction Line Capture"
Cohesion: 0.20
Nodes (9): ADR-038: Vendor Catalog Is Auto-Populated by Trigger on Transaction Line Capture, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 193 - "ADR-039: Custodian Reactivation Offers Limited (Settlement-Only) and Full Mode"
Cohesion: 0.20
Nodes (9): ADR-039: Custodian Reactivation Offers Limited (Settlement-Only) and Full Mode, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 194 - "ADR-040: Cross-Schema Active-State Sync Uses SECURITY DEFINER Trigger, Not Application Dual-Write"
Cohesion: 0.20
Nodes (9): ADR-040: Cross-Schema Active-State Sync Uses SECURITY DEFINER Trigger, Not Application Dual-Write, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 195 - "ADR-042: Vendor Rate Card Comparison Baseline Is Latest by created_at, Not Lowest Price"
Cohesion: 0.20
Nodes (9): ADR-042: Vendor Rate Card Comparison Baseline Is Latest by created_at, Not Lowest Price, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 196 - "ADR-043: sales.catalog Is the Shared Product Master — Vendor Management Links to It"
Cohesion: 0.20
Nodes (9): ADR-043: sales.catalog Is the Shared Product Master — Vendor Management Links to It, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 197 - "ADR-044: Finance Is Implemented as a Family of Focused Mini-PWAs, Not a Monolith"
Cohesion: 0.20
Nodes (9): ADR-044: Finance Is Implemented as a Family of Focused Mini-PWAs, Not a Monolith, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 198 - "ADR-045: Transaction Edit/Delete Uses Approval Queue for Non-Admins, Direct Apply for Admins"
Cohesion: 0.20
Nodes (9): ADR-045: Transaction Edit/Delete Uses Approval Queue for Non-Admins, Direct Apply for Admins, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 199 - "ADR-047: Recce Client Visibility Is Filtered Per-Brand, Not Per-Counter"
Cohesion: 0.20
Nodes (9): ADR-047: Recce Client Visibility Is Filtered Per-Brand, Not Per-Counter, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 200 - "ADR-048: External Client Portal Uses Email Magic-Link Auth — Not Hub PIN"
Cohesion: 0.20
Nodes (9): ADR-048: External Client Portal Uses Email Magic-Link Auth — Not Hub PIN, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 201 - "ADR-049: Recce View Files Are Served via HMAC-Signed Proxy — Not Direct Traefik Serve"
Cohesion: 0.20
Nodes (9): ADR-049: Recce View Files Are Served via HMAC-Signed Proxy — Not Direct Traefik Serve, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 202 - "ADR-050: Client Auth Tables Have No Direct web_anon Grants — RPC-Only Access"
Cohesion: 0.20
Nodes (9): ADR-050: Client Auth Tables Have No Direct web_anon Grants — RPC-Only Access, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 203 - "ADR-051: Learning Completion Is Threshold-Based — 100% Scenes or 80% Watch Time (Scrub-Proof)"
Cohesion: 0.20
Nodes (9): ADR-051: Learning Completion Is Threshold-Based — 100% Scenes or 80% Watch Time (Scrub-Proof), Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 204 - "ADR-052: Learning View Tracking Uses Two-RPC Beacon (start_view / end_view) — Not Single Write"
Cohesion: 0.20
Nodes (9): ADR-052: Learning View Tracking Uses Two-RPC Beacon (start_view / end_view) — Not Single Write, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 205 - "ADR-053: Per-Brand Counter Data Lives on recce.submissions — Not on counters.counter"
Cohesion: 0.20
Nodes (9): ADR-053: Per-Brand Counter Data Lives on recce.submissions — Not on counters.counter, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 206 - "ADR-054: Counter Sync Prefers my_visible_counters RPC, Falls Back to stores.json with Visible Warning"
Cohesion: 0.20
Nodes (9): ADR-054: Counter Sync Prefers my_visible_counters RPC, Falls Back to stores.json with Visible Warning, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 207 - "ADR-055: Transactional Email Uses mail_outbox Table + External Poller — Not Inline SMTP"
Cohesion: 0.20
Nodes (9): ADR-055: Transactional Email Uses mail_outbox Table + External Poller — Not Inline SMTP, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 208 - "ADR-056: AI-Assisted Features Use Prompt Copy-Paste Hand-Off — Not Live API Integration"
Cohesion: 0.20
Nodes (9): ADR-056: AI-Assisted Features Use Prompt Copy-Paste Hand-Off — Not Live API Integration, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 209 - "ADR-057: Reconciliation Statement Cannot Be Closed Until All Lines Are Matched"
Cohesion: 0.20
Nodes (9): ADR-057: Reconciliation Statement Cannot Be Closed Until All Lines Are Matched, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 210 - "ADR-058: Credit Card PWA Reads vehicle.cc_transactions via View — Zero Writes to Vehicle Schema"
Cohesion: 0.20
Nodes (9): ADR-058: Credit Card PWA Reads vehicle.cc_transactions via View — Zero Writes to Vehicle Schema, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 211 - "ADR-059: Tour Planner AI Uses a Dedicated Sidecar Proxy — Not the Shared AI Finance Proxy"
Cohesion: 0.20
Nodes (9): ADR-059: Tour Planner AI Uses a Dedicated Sidecar Proxy — Not the Shared AI Finance Proxy, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 212 - "ADR-060: Production Promotion Uses rsync Allowlist — Not Full Git Checkout"
Cohesion: 0.20
Nodes (9): ADR-060: Production Promotion Uses rsync Allowlist — Not Full Git Checkout, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 213 - "ADR-061 Dual-Mode Search: Lazy Proxy Search + Eager Client-Side Dashboard"
Cohesion: 0.20
Nodes (9): ADR-061 Dual-Mode Search: Lazy Proxy Search + Eager Client-Side Dashboard, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 214 - "ADR-075: Unified RPC Error Response Format and Client-Side Error Contract"
Cohesion: 0.20
Nodes (10): ADR-075: Unified RPC Error Response Format and Client-Side Error Contract, Alternatives Considered, Consequences, Context, Decision, Implementation Notes, References, Related Decisions (+2 more)

### Community 215 - "ADR-094: Google OAuth Token Lifecycle — In-Memory Only, Email Hint Persisted for Silent Re-Auth"
Cohesion: 0.20
Nodes (9): ADR-094: Google OAuth Token Lifecycle — In-Memory Only, Email Hint Persisted for Silent Re-Auth, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 216 - "ADR-104: Cross-PWA Payment Handoff — localStorage Bridge into a Prefilled Custodian Transfer"
Cohesion: 0.20
Nodes (9): ADR-104: Cross-PWA Payment Handoff — localStorage Bridge into a Prefilled Custodian Transfer, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 217 - "btl schema"
Cohesion: 0.20
Nodes (10): btl.campaigns, btl.claim_events, btl.claims, btl.dispatches, btl.gift_rules, btl.partners, BTL Offers PWA, btl_login() RPC (+2 more)

### Community 218 - "9 Test Advances (Chronological)"
Cohesion: 0.20
Nodes (10): 9 Test Advances (Chronological), A1 · Shambhu → Mukesh · ₹5,000 · Cash · 12-May · `outstanding`, A2 · Shambhu → Sachin · ₹2,500 · Cash · 10-May · `partially_settled`, A3 · Harish → Narender · ₹3,000 · Cash · 8-May · `settled`, A4 · Pramod → Umashankar · ₹20,000 · NEFT · 14-May · `outstanding`, A5 · Harish → Mukesh · ₹1,500 · UPI · 15-May · `outstanding`, A6 · Shambhu → Ranjit Singh (Contract) · ₹800 · IMPS · 16-May · `outstanding`, A7 · Pramod → Rakesh · ₹10,000 · Cash · 13-May · `partially_settled` (+2 more)

### Community 219 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, description, display, icons, name, orientation, short_name, start_url (+1 more)

### Community 220 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 221 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 222 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 223 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 224 - "9. Open Questions — Resolved via eFlexo Trial Capture (2026-07-03)"
Cohesion: 0.20
Nodes (10): 9.1 Plate Cost Calculation: Auto vs. Manual Entry? — **RESOLVED: neither — no plate cost concept exists**, 9.2 Ink Volume Pre-population: From Estimate or Manual? — **RESOLVED: not tracked at all**, 9.3 Wastage Config UX: Global vs. Per-Job Override? — **PARTIALLY RESOLVED: no explicit wastage field found; likely folded into Cost Rate**, 9.4 Actual-vs-Estimated Tracking: Is It a Feature? — **RESOLVED: no — but adjacent margin tracking exists**, 9.5 Multi-Color Repeat / UPS-per-Shift Calculation — **RESOLVED: not supported**, 9.6 GST Calculation Method — **RESOLVED: per-item, but no variation observed**, 9.7 Custom Estimation Fields — **RESOLVED: real demand confirmed**, 9.8 Additional finding (not one of the original 7): Customer/Group-wise rate overrides (+2 more)

### Community 225 - "OSS Schema & Workflow Pattern Reference — Detailed Appendix"
Cohesion: 0.20
Nodes (10): AREA 1: Print Shop Management / Print MIS, AREA 2: Field Service / Installation Management, AREA 3: Equipment Rental / Production Asset Management, AREA 4: Agency / Client Project Management with Retainers, AREA 5: Lightweight ERP Framework Architecture, Borrow list — ranked (fit score /10 for 360DLM specifically), Bottom line (unchanged from the main report), Concrete SQL sketches worth reusing (+2 more)

### Community 226 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, description, display, icons, name, orientation, short_name, start_url (+1 more)

### Community 227 - "index.html (OC Contact Import PWA)"
Cohesion: 0.20
Nodes (10): goClassify() function, goConflicts() function, goHome() function, goHub() function, goImport() function, index.html (OC Contact Import PWA), ocLogout() function, showVcfSection() function (+2 more)

### Community 228 - "Module Design Document — Production Order Management PWA"
Cohesion: 0.20
Nodes (9): 1. Why this exists, 2.1 Screens, 2.2 Data model (VERIFIED live against lm360 information_schema, 2026-07-03), 2. Screens & data model (frontend-observed), 3. Key flows (frontend logic), 4. Verification status, 4a. ADRs governing this module, 5. Remaining work (blocked on user decisions, 2026-07-03) (+1 more)

### Community 229 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 230 - "theme-v2 Preset Editor"
Cohesion: 0.20
Nodes (10): applyValues() function, bgGradCss() function, Copy button, #cssOut textarea, Generate CSS block button, theme-v2 Preset Editor, MOODS Array (theme suggestions), PRESETS Object (theme data) (+2 more)

### Community 231 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, description, display, icons, name, orientation, short_name, start_url (+1 more)

### Community 232 - "4.2 RPCs (all in `stores` schema)"
Cohesion: 0.20
Nodes (10): 4.2 RPCs (all in `stores` schema), 4.4 Grants, 4. DB schema, `stores.approve_stock_take` — Approve & apply variances, `stores.create_issue` — Issue stock to a job/campaign, `stores.create_stock_take` — Start a physical audit, `stores.low_stock_count` — KPI query, `stores.receive_inward` — Insert inbound with line-items (+2 more)

### Community 233 - "custodian_tutorial_screenshots.spec.js"
Cohesion: 0.20
Nodes (4): DIR, path, SESSION, { test, expect, devices }

### Community 234 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 235 - "Module Design Document — Tutorials (Legacy)"
Cohesion: 0.20
Nodes (9): 1. Why this exists, 2. Current status, 3. Directory structure, 4. API/schema references, 5. Verification, ADRs governing this module, Migration summary (2026-07-02), Module Design Document — Tutorials (Legacy) (+1 more)

### Community 236 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, description, display, icons, name, orientation, short_name, start_url (+1 more)

### Community 237 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, display, icons, name, orientation, scope, short_name, start_url (+1 more)

### Community 238 - "manifest.json"
Cohesion: 0.20
Nodes (9): background_color, description, display, icons, name, orientation, short_name, start_url (+1 more)

### Community 239 - "ADR-009: Each PWA Owns Dedicated PostgreSQL Schema"
Cohesion: 0.22
Nodes (9): ADR-009: Each PWA Owns Dedicated PostgreSQL Schema, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 240 - "ADR-007: Trigger Functions Writing Privileged Tables Must Use SECURITY DEFINER"
Cohesion: 0.22
Nodes (9): ADR-007: Trigger Functions Writing Privileged Tables Must Use SECURITY DEFINER, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 241 - "ADR-014: PostgREST Is the API Layer — No Custom REST Framework"
Cohesion: 0.22
Nodes (9): ADR-014: PostgREST Is the API Layer — No Custom REST Framework, Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status (+1 more)

### Community 242 - "ADR-028-feature-ownership-follows-domain.md"
Cohesion: 0.22
Nodes (8): Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status, Status History

### Community 243 - "ADR-076-mobile-first-viewport-standard.md"
Cohesion: 0.22
Nodes (8): Alternatives Considered, Consequences, Context, Decision, References, Related Decisions, Status, Status History

### Community 244 - "Source: rvdbreemen/adr-kit (adapted for 360lm project)"
Cohesion: 0.22
Nodes (9): 360lm-specific conventions, Anti-Rationalization Guards, Immutability rule, Output, Source: rvdbreemen/adr-kit (adapted for 360lm project), Template structure (seven sections in order), Verification Gates (must pass before Proposed → Accepted), When to write an ADR (+1 more)

### Community 245 - "software-architect Agent"
Cohesion: 0.25
Nodes (9): Activity v21 CiC UX Walkthrough, Activity v22 CiC Re-test (Bug Fix Verification), 360LM Multi-PWA Platform, software-architect Agent, Cross-PWA Safety Rule, Hub Session / Auth, OpenClaw WhatsApp/Telegram Bridge, Paperclip AI Orchestration (+1 more)

### Community 246 - "FundCustodian UX Walkthrough CiC Prompt"
Cohesion: 0.22
Nodes (8): FundCustodian UX Walkthrough CiC Prompt, Background (read before testing), Cross-cutting UX checks (note any issues for each persona), Persona 1 — mukesh (Non-custodian, should be locked out), Persona 2 — harish (Admin, 2 pending transfers), Persona 3 — shambhu (Non-admin, secondary custodian), Persona 4 — gurpreet (Non-admin, low activity, small positive balance), Persona 5 — pramod (Admin + Primary, deeply negative balance)

### Community 247 - "Module Design Document: Print Estimation Engine"
Cohesion: 0.22
Nodes (8): 10. Acceptance Criteria for v1 Shippable Version, 1. Why This Exists, 2. Inspiration vs. Scope, Intentional Out-of-Scope for v1, Module Design Document: Print Estimation Engine, References Studied (Ideas, Not Code/Secrets), ⚠️ Review note (added post-draft, before this MDD is used) — REQUIRED READING, Summary & Next Steps

### Community 248 - "17. Highlight Video — Assembled From the User's Own Event Photos/Clips (2026-07-06)"
Cohesion: 0.22
Nodes (9): 17.1 Scout Findings (full report in chat, summarized here), 17.2 Two Real Constraints Inherited From MPT's Design (documented, not bugs), 17.3 Data Model (`migrations/migrate_videosmith_v4.sql`), 17.4 Infrastructure (`docker-compose.yml`), 17.5 Backend (`videosmith_app.py`), 17.6 Frontend (`public/index.html`), 17.7 Verified Live (2026-07-06), 17.8 Future Consideration — Large (~8GB) Source Library (2026-07-06, discussed not built) (+1 more)

### Community 249 - "Branding & Logo Design"
Cohesion: 0.22
Nodes (9): Salient Medical Solutions - Logo, Sandeep Saggu - Logo Design, Scotiabank - Logo, SpeedWash - Logo Design, Branding & Logo Design, Medical Solutions Industry, Personal / Professional Brand, Banking / Financial Services Industry (+1 more)

### Community 250 - "manifest.json"
Cohesion: 0.22
Nodes (8): background_color, display, icons, name, scope, short_name, start_url, theme_color

### Community 251 - "capture.js"
Cohesion: 0.31
Nodes (8): captureClientPortal(), captureCounters(), { chromium, devices }, fs, injectSupervisor(), OUT, path, shot()

### Community 252 - "Print Bridge — Designer PC Setup (one time, ~15 minutes)"
Cohesion: 0.22
Nodes (8): How jobs look, Notes, Prerequisites on this PC, Print Bridge — Designer PC Setup (one time, ~15 minutes), Step 1 — Install Syncthing, Step 2 — Pair with the VPS, Step 3 — Install the watcher, Step 4 — Self-test

### Community 253 - "4.1 Core tables"
Cohesion: 0.22
Nodes (9): 4.1 Core tables, `stores.inward` — Goods Received (Creditor Invoices), `stores.inward_lines` — Line-items within an inbound, `stores.inward_payments` — Payment receipts (migrate_payables), `stores.issues` — Goods Out (Stock Issuance), `stores.items` — SKU master catalog, `stores.stock_movements` — Audit trail, `stores.stock_take_lines` — Physical count per item (+1 more)

### Community 254 - "5. UI — Six screens"
Cohesion: 0.22
Nodes (9): 5.1 Home (`#screen-home`), 5.2 Stock (`#screen-stock`), 5.3 Item Detail (`#screen-item-detail`), 5.4 Receive (`#screen-receive`), 5.5 Issue (`#screen-issue`), 5.6 Audit (`#screen-audit`), 5.7 Stock Take Detail (`#screen-stk-form`), 5.8 Admin (`#screen-admin`) (+1 more)

### Community 255 - "20. Activity PWA — Response Capture Patterns"
Cohesion: 0.22
Nodes (8): 20.1 Response Status Lifecycle, 20.2 Draft Mode — Implementation, 20.3 GPS Location Capture, 20.4 Response Tile Info Density, 20.5 Delete Policy, 20.6 PostgREST — Schema Changes on Live DB, 20.7 Role System (canCapture pattern), 20. Activity PWA — Response Capture Patterns

### Community 256 - "21. Bilingual (EN / HI) Pattern"
Cohesion: 0.22
Nodes (8): 21.1 CSS Toggle Mechanism, 21.2 Static HTML — Wrap Both Languages in Spans, 21.3 JS State, Toggle Function, and Translation Helper, 21.4 Dynamic JS — Use `t()` in Template Literals, 21.5 Map Variable Name Conflict, 21.6 Bilingual Coverage Checklist (per screen), 21.7 Language Button Styling, 21. Bilingual (EN / HI) Pattern

### Community 258 - "4. Database schema"
Cohesion: 0.25
Nodes (8): 4.1 `activity.activities` — activity definition (form template), 4.2 `activity.activity_team` — team members assigned to an activity, 4.3 `activity.companies` — client/company registry, 4.4 `activity.client_access` — external client (brand) access control per activity, 4.5 `activity.responses` — one submitted/draft activity response (field worker's submission), 4.6 `activity.response_photos` — photos linked to a response, 4.7 PostgREST grants, 4. Database schema

### Community 259 - "7. Screens and workflows"
Cohesion: 0.25
Nodes (8): 7.1 Login (scr-login), 7.2 Home (scr-home), 7.3 Activity detail (scr-activity), 7.4 Capture form (scr-capture), 7.5 Responses list (scr-responses), 7.6 Presentation (scr-pres), 7.7 Manage (scr-manage), 7. Screens and workflows

### Community 260 - "manifest.json"
Cohesion: 0.25
Nodes (7): background_color, display, icons, name, short_name, start_url, theme_color

### Community 261 - "ADR-099 DevGuide Is an Index + Skill + Topic Files, Not a Monolith"
Cohesion: 0.25
Nodes (7): ADR-099 DevGuide Is an Index + Skill + Topic Files, Not a Monolith, Alternatives Considered, Consequences, Context, Decision, Status, Status History

### Community 262 - "ADR-100 Visual Design via shared/theme-v2.css Token Presets, Outside Ponytail's Scope"
Cohesion: 0.25
Nodes (7): ADR-100 Visual Design via shared/theme-v2.css Token Presets, Outside Ponytail's Scope, Alternatives Considered, Consequences, Context, Decision, Status, Status History

### Community 263 - "ADR-101 SVG Is the Working Format for Print Creatives; CorelDRAW Is Fallback Only"
Cohesion: 0.25
Nodes (7): ADR-101 SVG Is the Working Format for Print Creatives; CorelDRAW Is Fallback Only, Alternatives Considered, Consequences, Context, Decision, Status, Status History

### Community 264 - "ADR-102 Modern CDR Conversion Must Originate From CorelDRAW; Cloud Converters Only for Legacy CDRs"
Cohesion: 0.25
Nodes (7): ADR-102 Modern CDR Conversion Must Originate From CorelDRAW; Cloud Converters Only for Legacy CDRs, Alternatives Considered, Consequences, Context, Decision, Status, Status History

### Community 265 - "ADR-103 Print Bridge Runs Over a Syncthing Job Folder With a Self-Updating Watcher"
Cohesion: 0.25
Nodes (7): ADR-103 Print Bridge Runs Over a Syncthing Job Folder With a Self-Updating Watcher, Alternatives Considered, Consequences, Context, Decision, Status, Status History

### Community 266 - "Source: rvdbreemen/adr-kit instructions/adr.coding.md (adapted for 360lm)"
Cohesion: 0.25
Nodes (7): ADR Rules for Coding Work, Before implementing, Creating a new ADR, Implementation checklist, Source: rvdbreemen/adr-kit instructions/adr.coding.md (adapted for 360lm), Superseding an existing ADR, When ADR rules do NOT apply

### Community 267 - "Tour AI Proxy"
Cohesion: 0.43
Nodes (8): ANTHROPIC_API_KEY, GOOGLE_MAPS_API_KEY, POST /tour-ai/analyze, POST /tour-ai/maps, Tour AI Proxy, POST /tour-ai/replan, POST /tour-ai/route, Route Planning Screen

### Community 268 - "Module Design Document — Contacts PWA"
Cohesion: 0.25
Nodes (7): ADRs governing this module, Data state (2026-07-03), Decisions (user, 2026-07-03), Files, Module Design Document — Contacts PWA, Schema (verified live, lm360), Summary

### Community 269 - "14. Blogsmith Feature-Parity Expansion (2026-07-03, same day)"
Cohesion: 0.25
Nodes (8): 14.1 Data Model Changes (`migrations/migrate_videosmith_v2.sql`), 14.2 Scheduler (mirrors Blogsmith's `scheduler_worker()` exactly), 14.3 Auto-Posting via Upload-Post (verified live against the real API, not just docs), 14.4 UI Improvement — Multi-Topic Chip Input (the requested improvement over Blogsmith's plain textarea), 14.5 New Screens/Endpoints, 14.6 Verified Live (2026-07-03), 14.7 Playwright Coverage Added (2026-07-03), 14. Blogsmith Feature-Parity Expansion (2026-07-03, same day)

### Community 270 - "Signage & Fabrication Competitive Synthesis — eFlexo, CoreBridge, ShopVOX + Manufacturing Fundamentals"
Cohesion: 0.25
Nodes (8): 0. Executive summary, 1. Software competitive landscape, 2. The job-costing gap, in detail, 3. Signage manufacturing domain knowledge (summary — full detail in its own doc), 4. Implications for 360DLM's roadmap, 5. Why CoreBridge/ShopVOX didn't get the eFlexo treatment, 6. Source documents (full detail), Signage & Fabrication Competitive Synthesis — eFlexo, CoreBridge, ShopVOX + Manufacturing Fundamentals

### Community 271 - "EltaMD UV Clear Sunscreen - Marketing Infographic"
Cohesion: 0.36
Nodes (8): Equipment Rental Services, EltaMD UV Clear Sunscreen - Marketing Infographic, PCA Skin Post-Treatment Hydration - Product Marketing Ad, Impact Backhoe Rental - Equipment Marketing Poster, EltaMD SPF Product Marketing - Social Media Ad, Advertising & Campaign Design, Marketing & Product Design, Skincare / Dermatology Products

### Community 272 - "14. Verification"
Cohesion: 0.25
Nodes (8): 14.1 Screens (index.html), 14.2 Service Worker (sw.js), 14.3 Configuration (index.html), 14.4 Categories, 14.5 RPC calls, 14.6 Admin gating, 14.7 Data fetches, 14. Verification

### Community 273 - "5. Data model — expense schema"
Cohesion: 0.25
Nodes (8): 5.1 Table: `expense.sheets`, 5.2 Table: `expense.expenses`, 5.3 Table: `expense.impress_accounts`, 5.4 Table: `expense.impress_transactions`, 5.5 Table: `expense.advances`, 5.6 Views: `approved_pending_reimbursement`, 5.7 Shared tables (referenced from expense schema), 5. Data model — expense schema

### Community 274 - "Yagya Narang Portfolio v2"
Cohesion: 0.25
Nodes (8): Bebas Neue Typeface, Cormorant Garamond Typeface, IBM Plex Mono Typeface, About Section, Hero Section, Photographs Section, Portfolio OG Preview Image, Yagya Narang Portfolio v2

### Community 275 - "manifest.json"
Cohesion: 0.25
Nodes (7): background_color, display, icons, name, short_name, start_url, theme_color

### Community 276 - "4.3 Views"
Cohesion: 0.25
Nodes (8): 4.3 Views, `sales.job_material_cost` — Per-job material summary, `sales.job_materials_v` — Job cost: material lines, `sales.job_profitability_v` — Full P&L per job, `stores.inward_payment_summary` — Payment status per inbound, `stores.issues_v` — Enriched issues with cost, `stores.item_avg_cost` — Weighted Average Cost per item, `stores.payables_kpi` — Payables summary

### Community 277 - "23. Client Portal Session Bridge Pattern"
Cohesion: 0.25
Nodes (7): 23.1 Problem, 23.2 Session Keys Involved, 23.3 Login Flow (Company Code → Activity), 23.4 ?next= Redirect Pattern, 23.5 Redirect-Only Login Screen Pattern, 23.6 Two Parallel Client Systems (360LM specific), 23. Client Portal Session Bridge Pattern

### Community 278 - "4. Database (IndexedDB)"
Cohesion: 0.25
Nodes (7): 3.1 Global Variables, 3.2 Constants, 3. State Architecture, 4.1 Config Keys (cfg store), 4.2 Submission Entry Schema, 4.3 Draft Schema, 4. Database (IndexedDB)

### Community 279 - "tour_pg_sharing.spec.js"
Cohesion: 0.29
Nodes (5): cleanup(), mintHubAuth(), { test, expect }, USER_A, USER_B

### Community 280 - "MDD — EXTENSION: Counter Search + Geographical Schema + Dual-Mode Dashboard (`tour-pg-v20`)"
Cohesion: 0.25
Nodes (8): F1. Intent, F2. Decisions captured, F4. Architecture, F5. New proxy endpoints, F7. ADRs followed, F8. Files changed, F9. Done = ready check  ✅ SHIPPED 2026-06-25, MDD — EXTENSION: Counter Search + Geographical Schema + Dual-Mode Dashboard (`tour-pg-v20`)

### Community 281 - "manifest.json"
Cohesion: 0.25
Nodes (7): background_color, display, icons, name, short_name, start_url, theme_color

### Community 282 - "ADR-033"
Cohesion: 0.29
Nodes (7): ADR-033, HR Salary Payment RPC Cross-Writes to finance.transactions, Transaction Edit Delete Via Approval Queue or Direct, AI Features Use Prompt Copy-Paste Hand-Off, Statement Cannot Close Until Zero Unmatched, Approval Queue vs Direct Admin Action Pattern, Atomic Approval and Financial Deduction Pattern

### Community 283 - "Recce Portal Tutorial — counters + recce-client two-PWA walkthrough"
Cohesion: 0.33
Nodes (7): Recce Portal Tutorial — counters + recce-client two-PWA walkthrough, Gemini Prompt for Recce Portal video tutorial, Gemini Prompt Tutorial — revised tutorial-length output guide, Recce Suite Tutorial Library index, Tutorial player (player.html), Recce Portal tutorial.html walkthrough, Recce Portal End-to-End Walkthrough Storyboard

### Community 284 - "5.1 VideoSmith API Endpoints"
Cohesion: 0.29
Nodes (7): 5.1 VideoSmith API Endpoints, 5.2 MoneyPrinterTurbo Integration (Read-Only from VideoSmith), 5.3 Job Submission Request Model, 5. API Contract & Integration, Auth Endpoints, Health Check, Job & Configuration Endpoints

### Community 285 - "extract_city_hints"
Cohesion: 0.38
Nodes (6): extract_city_hints(), extract_pincode_from_text(), extract_state_from_text(), Find a 6-digit Indian PIN code in raw address text.     Returns '' if none found, Extract state from patterns like '(RAJ.)' or 'SIKAR RAJ 333001'., Extract pincode and state hint from raw address text.     Returns {'pincode': '.

### Community 286 - "index.html (Print Nest PWA)"
Cohesion: 0.29
Nodes (7): index.html (Print Nest PWA), loadDemoItems() function, loadRuns() function, loadStock() function, navTo() function, resetAdd() function, switchTab() function

### Community 287 - "PostgREST API Base URL"
Cohesion: 0.29
Nodes (7): installation.campaigns Table, localStorage (Session), In-Memory Planning State (planState), PostgREST API Base URL, Campaign Selection Screen, Login Screen, Manpower Assignment Screen

### Community 288 - "Revised prompt — tutorial-length output"
Cohesion: 0.29
Nodes (6): A — `tutorial.html` (zero-tool, runs in your browser right now), B — NotebookLM prompt (best AI-generated tutorial video), Bottom line, C — Google Vids prompt (manually edited AI deck), Revised prompt — tutorial-length output, Why the first prompt produced a 10-second clip

### Community 289 - "US sign industry standards (fragmented)"
Cohesion: 0.29
Nodes (7): ADA + ANSI A117.1, ASCE 7 §29.3 + IBC, International Sign Association (ISA), PRINTING United Alliance — Rigid Signage Certification, SEGD (Environmental graphic design), UL 48 (15th ed.) + NEC Article 600, US sign industry standards (fragmented)

### Community 290 - "22. App Update Banner Pattern"
Cohesion: 0.29
Nodes (6): 22.1 How It Works, 22.2 CSS, 22.3 HTML, 22.4 JS, 22.5 Release Checklist, 22. App Update Banner Pattern

### Community 291 - "8. Store List Management"
Cohesion: 0.29
Nodes (6): 8.1 Upload Flow, 8.2 Column Mapping (`parseStoreRow`), 8.3 Deduplication (`dedupeStores`), 8.4 Auto-fetch on Init, 8. Store List Management, 9. GPS Capture

### Community 292 - "fundcustodian.spec.js"
Cohesion: 0.29
Nodes (3): C_HDR, SESSION, { test, expect, devices }

### Community 293 - "recce_client.spec.js"
Cohesion: 0.29
Nodes (4): BRANDING_META, HC, HR, { test, expect, request, devices }

### Community 294 - "install.sh"
Cohesion: 0.52
Nodes (6): install.sh script, die(), err(), ok(), say(), warn()

### Community 295 - "External Client Portal Uses Email Magic-Link Auth"
Cohesion: 0.33
Nodes (6): External Client Portal Uses Email Magic-Link Auth, Recce View Files Served Via HMAC-Signed Proxy, Client Auth Tables RPC-Only No Direct Grants, Transactional Email Uses Outbox External Poller, External Client Magic-Link Auth, Mail Outbox and External Poller Pattern

### Community 296 - "docs/adr/README.md"
Cohesion: 0.33
Nodes (6): ADR-092 User Preference Cascading Fallback, ADR-105 Signed JWT for Proxy Auth, adr-generator, adr-kit, docs/adr/README.md, gemini-proxy container

### Community 297 - "Alternatives Considered"
Cohesion: 0.33
Nodes (6): 1. Shared Canvas Editor HTML Module, 2. No Editing — Compress Immediately After Capture, 3. Crop-Only Mode (No Full Annotation Tools), 4. Store receipt_image in list Queries, 5. Client-Side File Picker Only (No Camera or CTH), Alternatives Considered

### Community 298 - "Implementation Notes"
Cohesion: 0.33
Nodes (6): Canvas Editor Architecture, Canvas Scaling, CTH Countdown, Desktop Fallback for CTH, Implementation Notes, Size Estimate Formula

### Community 299 - "Yagya Narang (Cinematographer)"
Cohesion: 0.33
Nodes (6): Yagya Narang (Cinematographer), Email Contact, Instagram @longstorysh0t, WhatsApp Contact, Open Field (Film #2), Vintage Study (Film #1)

### Community 300 - "Learning Hub"
Cohesion: 0.33
Nodes (6): .back-btn class, catalog.json, finance/credit-card/index.html, .hdr-btn class, Learning Hub, pwa_groups.json

### Community 301 - "Design System"
Cohesion: 0.33
Nodes (6): Button System, CSS Custom Properties, Design System, Form Controls, Photo Slot (.pslot), Typography Scale

### Community 302 - "renderApprovalScreen() — Render Review UI"
Cohesion: 0.33
Nodes (6): enterRecceApproval() — Load Recce for Review, loadBrandingApprovalResults() — Fetch Branding Approvals, Client Portal PWA — Account & Grant Management, Recce Approval, renderApprovalScreen() — Render Review UI, selectApprovalOption() — Option State Manager, submitApproval() — PATCH Submission + Insert Branding Changes

### Community 303 - "5. Remote Procedure Calls (RPCs)"
Cohesion: 0.33
Nodes (6): 5.1 `fn_estimate_rollup_costs(p_estimate_id, caller_role)`, 5.2 `fn_estimate_create_and_line_add(customer_name, job_description)`, 5.3 `fn_estimate_line_add(p_estimate_id, substrate_id, width_mm, length_m, quantity, ink_colors, wastage_override)`, 5.4 `fn_estimate_send_to_customer(estimate_id)`, 5.5 `fn_record_actual_consumption(estimate_id, actual_data_json)`, 5. Remote Procedure Calls (RPCs)

### Community 304 - "6. Screens/UX"
Cohesion: 0.33
Nodes (6): 6.1 Estimate Builder Form, 6.2 Substrate Master Admin Screen, 6.3 Ink Master Admin Screen, 6.4 Plate Cost Config Admin Screen, 6.5 Variance Report (Phase 2), 6. Screens/UX

### Community 305 - "7. Data Sensitivity & Access Model"
Cohesion: 0.33
Nodes (6): 7.1 Data Classification, 7.2 Current Authorization Architecture, 7.3 Proposed Enforcement (Verdict Table), 7.4 Recommended Mitigation (Phase 1.5, Before Production), 7.5 Design Decision: Verdict, 7. Data Sensitivity & Access Model

### Community 306 - "Large (~8GB) source library scoping discussion"
Cohesion: 0.47
Nodes (6): Recommended scouting: curation/dedup and resumable-upload tooling, Large (~8GB) source library scoping discussion, Architectural change: mandatory curation and deduplication, Architectural change: persistent media library (one upload → one job → reusable per-job selection), Architectural change: separate progress reporting (material scan vs. render), Architectural change: upload transport (in-memory multipart → chunked/resumable)

### Community 307 - "Finance V1 Archived Reference (deprecated 2026-05-19)"
Cohesion: 0.33
Nodes (6): Finance Hub Portal (/finance/), Finance V1 Archived Reference (deprecated 2026-05-19), Finance V1 RPCs (do_custodian_handover, settle_claim_cash, pay_salary etc.), 13 Finance Transaction Types, UPI Direct 3-tier OCR (Tesseract → Ollama → Claude AI), Finance V1 PWA (archived HTML)

### Community 308 - "get-gemini-key.js"
Cohesion: 0.33
Nodes (3): { chromium }, readline, rl

### Community 309 - "Module Design Document — mother"
Cohesion: 0.33
Nodes (5): ADRs governing this module, Evidence, Module Design Document — mother, Next Steps (for user), Summary

### Community 310 - "PCA Skin Product Promotional Poster with Model"
Cohesion: 0.33
Nodes (6): PCA Skin Product Advertisement - Hyaluronic Acid Serum, Mercedes Steering Wheel Product Photography, PCA Skin Product Social Media Post - Features and Benefits, PCA Skin Product Promotional Poster with Model, PCA Skin Multi-Product Campaign - Peel Treatment Line, PCA Skin Social Campaign - Post-Peel Best Friend

### Community 311 - "7. Photo Pipeline"
Cohesion: 0.33
Nodes (5): 7.1 Compression (`compress`), 7.2 GPS Stamp (`stampPhoto`), 7.3 Photo Source Dialog, 7.4 Device Save (`savePhotoToDevice`), 7. Photo Pipeline

### Community 312 - "19.6 HTML Report — Rich Server Version (`generateRecceReportHtml`)"
Cohesion: 0.33
Nodes (6): 19.6 HTML Report — Rich Server Version (`generateRecceReportHtml`), Branding Item Row Layout, Hero Meta Grid, Layout Structure, Photo Grid System, Report CSS Notes

### Community 313 - "btl.spec.js"
Cohesion: 0.33
Nodes (4): ADMIN, fs, PARTNER, { test, expect, devices }

### Community 314 - "custodian_s9_recording.spec.js"
Cohesion: 0.40
Nodes (3): goToManage(), { test, expect }, WAIT()

### Community 315 - "sales_billing.spec.js"
Cohesion: 0.47
Nodes (4): api(), dbClean(), dbGet(), { test, expect, devices, request }

### Community 316 - "F6. UI components"
Cohesion: 0.33
Nodes (6): "Add to tour" flow, F6. UI components, Filter chips (both modes), Mode toggle (tab bar), Result cards, Summary tiles (dashboard only)

### Community 317 - "Module Design Document — tours"
Cohesion: 0.33
Nodes (5): ADRs governing this module, Distinction: tours directory vs tours table, Evidence, Module Design Document — tours, Summary

### Community 318 - "generate_segment"
Cohesion: 0.60
Nodes (4): fmt_srt_time(), generate_segment(), main(), Generate MP3 + SRT for one segment. Returns audio duration in seconds.

### Community 319 - "Zone deletion guard — accounts check"
Cohesion: 0.40
Nodes (5): deleteZone() function in admin PWA, Zone deletion guard — accounts check, POST /db/accounts?zone=eq. (zone filter query), client.accounts table with zone column, client.zones table schema

### Community 321 - "Recce Client Visibility Filtered Per-Brand"
Cohesion: 0.40
Nodes (5): Engaged Recce Records Use Supersede Not Delete, Recce Client Visibility Filtered Per-Brand, Learning Completion Threshold-Based 80 Percent Watch, Learning View Tracking Two-RPC Beacon, Per-Brand Counter Data Lives on recce.submissions

### Community 322 - "Related Decisions"
Cohesion: 0.40
Nodes (5): [ADR-009](ADR-009-each-pwa-owns-its-db-schema.md) — Each PWA Owns Its DB Schema, [ADR-013](ADR-013-single-html-file-no-framework.md) — Single HTML File, No Framework, [ADR-014](ADR-014-postgrest-as-api-layer.md) — PostgREST as API Layer, [ADR-021](ADR-021-sw-cache-first-network-fallback.md) — Service Worker Cache-First Strategy, Related Decisions

### Community 323 - "Approval option button handlers (approve/reject/comment)"
Cohesion: 0.40
Nodes (5): PATCH /db/submissions (client_status update), Approval option button handlers (approve/reject/comment), enterRecceApproval() function in client portal, renderApprovalScreen() function in client portal, recce.submissions table with client_status column

### Community 324 - "Brevo Account + API Key Setup CiC"
Cohesion: 0.60
Nodes (5): Brevo Account + API Key Setup CiC, Brevo Domain Auth CiC (DKIM/SPF/DMARC), 360degreelogicalmktg.com Domain, Brevo Mail Relay (counters-mail-relay worker), Recce Portal / recce-client PWA

### Community 325 - "360LM Walkthroughs Manual Install Guide"
Cohesion: 0.50
Nodes (5): Playwright-Based Walkthrough Framework, 360LM Walkthroughs Framework Install Prompt for Claude, Walkthrough HUD Overlay (Human-in-Loop), 360LM Walkthroughs Manual Install Guide, Walkthrough Test Mode (WALKTHROUGH_TEST=1 headless)

### Community 326 - "excel_to_counters Skill"
Cohesion: 0.40
Nodes (5): Counter Management CSV v2, excel_parser.py Helper, Google Maps MCP Geocode, pincode_lookup.py Helper, excel_to_counters Skill

### Community 327 - "Ponytail Help Reference"
Cohesion: 0.40
Nodes (5): Ponytail Audit Command, Ponytail Debt Tracking Command, Ponytail Gain Display Command, Ponytail Help Reference, Ponytail Review Command

### Community 328 - "Fund Custodian Dashboard after UPI Payment"
Cohesion: 0.40
Nodes (5): Fund Custodian Dashboard after UPI Payment, Access Restricted Screen, Tour Step 1 - Welcome to Fund Custodian, Tour Step 2 - Your Wallet Balance, Tour Step 3 - Non-Cash Transfers

### Community 329 - "Send/Receive Funds - Cash Giver Pending Warning"
Cohesion: 0.40
Nodes (5): Send/Receive Funds - Cash Giver Pending Warning, Shambhu Dashboard after Cash Giver Transfer, Pramod Pending Transfer Banner, Pramod Dashboard After Accepting Transfer, Send/Receive Funds - Receiver Cash Form (Gurpreet)

### Community 330 - "ADR-021: Service Worker Cache-First with Network Fallback"
Cohesion: 0.40
Nodes (5): ADR-002: Safe-Bottom CSS Mandatory, ADR-005: Service Worker Cache Busting via CACHE_VER, ADR-021: Service Worker Cache-First with Network Fallback, Service Worker Cache-First Strategy, Service Worker Browser API

### Community 331 - "3. Proposed Build Phases"
Cohesion: 0.40
Nodes (5): 3. Proposed Build Phases, Phase 1: Core Estimation Engine (Weeks 1–3), Phase 2: Variance Tracking (Weeks 4–5), Phase 3: Financial Integration (Week 6), Phase 4: Refinement (On-Demand)

### Community 332 - "8. Financial Integrity & Immutability"
Cohesion: 0.40
Nodes (5): 8.1 Invoice Sequencing (GST Compliance, India), 8.2 Rounding Rule (Prevent Silent Drift), 8.3 Currency Precision, 8.4 Immutability (ERPNext Pattern Adaptation), 8. Financial Integrity & Immutability

### Community 333 - "3. Proposed Build Phases"
Cohesion: 0.40
Nodes (5): 3. Proposed Build Phases, Phase 1: Core Generation Pipeline (Weeks 1–2), Phase 2: Credential + Provider Config UI (Weeks 3–4), Phase 3: Publishing + Distribution (Weeks 5–6), Phase 4: Batch Jobs, Analytics, Polish (On-Demand)

### Community 334 - "Schema: `videosmith`"
Cohesion: 0.40
Nodes (5): 4.1 `users` Table, 4.2 `sessions` Table, 4.3 `jobs` Table, 4. Data Model, Schema: `videosmith`

### Community 335 - "6. Screens & UX"
Cohesion: 0.40
Nodes (5): 6.1 Login Screen, 6.2 Registration Flow, 6.3 Dashboard / Main View, 6.4 Service Worker & Offline Support, 6. Screens & UX

### Community 336 - "Live walkthrough verification (PIN 0000, Harish Kumar Lal)"
Cohesion: 0.40
Nodes (5): Base64 truncation testing gotcha (inline JS strings >5KB), Highlight video end-to-end test result (portrait 1080×1920, real BGM track), Live walkthrough verification (PIN 0000, Harish Kumar Lal), Same-origin fetch() workaround for test files, VCC Class 22: base64 JS string truncation environment limitation

### Community 337 - "12. Integrations"
Cohesion: 0.40
Nodes (5): 12.1 Hub (authentication), 12.2 Custodian (payment handoff), 12.3 Finance (accounting sync), 12.4 OCR proxy (external service), 12. Integrations

### Community 338 - "generate_segment"
Cohesion: 0.60
Nodes (4): fmt_srt_time(), generate_segment(), main(), Generate MP3 + SRT for one segment. Returns audio duration in seconds.

### Community 339 - "5. RPCs (Remote Procedure Calls)"
Cohesion: 0.40
Nodes (5): 5.1 Transfer operations, 5.2 Edit request workflow (v7+), 5.3 Custodian management, 5.4 Payee operations (cross-PWA), 5. RPCs (Remote Procedure Calls)

### Community 340 - "Yagya Narang Portfolio v1"
Cohesion: 0.40
Nodes (5): Archivo Typeface, Instrument Serif Typeface, JetBrains Mono Typeface, Google Fonts CDN Service, Yagya Narang Portfolio v1

### Community 341 - "generate_segment"
Cohesion: 0.60
Nodes (4): fmt_srt_time(), generate_segment(), main(), Generate MP3 + SRT for one segment. Returns audio duration in seconds.

### Community 342 - "generate_segment"
Cohesion: 0.60
Nodes (4): fmt_srt_time(), generate_segment(), main(), Generate MP3 + SRT for one segment. Returns audio duration in seconds.

### Community 343 - "generate_segment"
Cohesion: 0.60
Nodes (4): fmt_srt_time(), generate_segment(), main(), Generate MP3 + SRT for one segment. Returns audio duration in seconds.

### Community 344 - "vehicle/index.html"
Cohesion: 0.40
Nodes (5): /shared/safe-bottom.css, vehicle/index.html, vehicle/manifest.json, Login Screen (Vehicle), Splash Screen (Vehicle)

### Community 345 - "24. Admin PWA — Extending with New Management Sections"
Cohesion: 0.40
Nodes (4): 24.1 Existing Admin PWA Structure, 24.2 Adding a New Section (e.g. `/admin/client`), 24.3 Client Management Section (planned), 24. Admin PWA — Extending with New Management Sections

### Community 346 - "10. Sync Architecture (3-Stage)"
Cohesion: 0.40
Nodes (4): 10. Sync Architecture (3-Stage), Google Slides Generation, PostgREST Schema (submissions table, recce schema), Rich HTML Report (`generateRecceReportHtml`)

### Community 349 - "4. Phases"
Cohesion: 0.40
Nodes (5): 4. Phases, Phase 1 — Extend TomTom MCP (~20 min) ✅ LIVE 2026-06-04, Phase 2 — Tour-pg proxy (~45 min) ✅ LIVE 2026-06-04, Phase 3 — PWA shell (~90 min) ✅ LIVE 2026-06-04, Phase 4 — Tests + hub registration (~30 min) ✅ LIVE 2026-06-04

### Community 350 - "5. API integration"
Cohesion: 0.50
Nodes (4): 5.1 PostgREST connection, 5.2 GForm proxy, 5.3 Photo upload proxy, 5. API integration

### Community 351 - "8. Authentication & Authorization"
Cohesion: 0.50
Nodes (4): 8.1 Employee (field worker), 8.2 Client (external user), 8.3 Admin (supervisor), 8. Authentication & Authorization

### Community 352 - "Consequences"
Cohesion: 0.50
Nodes (4): Benefits, Consequences, Risks and Mitigations, Trade-offs

### Community 353 - "ADR-105: Hub Issues a Signed JWT Alongside localStorage Session"
Cohesion: 0.50
Nodes (4): ADR-105: Hub Issues a Signed JWT Alongside localStorage Session, ADR-106: Cross-Schema Access Is Grant-Gated by Convention, Not Enforced by Views or RLS, PostgREST Multi-Schema Access via Accept-Profile Header, Signed JWT for Proxy Services and Future Native Clients

### Community 354 - "pwa_dev_style.md DevGuide"
Cohesion: 0.50
Nodes (4): pwa_dev_style.md DevGuide, Bilingual DevGuide (EN/HI), 360LM Project File Index (MEMORY.md), Master PWA DevGuide (pwa_dev_style.md)

### Community 355 - "PostgREST API Layer"
Cohesion: 0.50
Nodes (4): ADR-010: Cross-Schema Data via Proxy, Not PostgREST, Credit Card PWA - Card Reconciliation, Tour PG PWA - Tour Planning Portal, PostgREST API Layer

### Community 356 - "ADR-017: Traefik + Docker Labels for Routing"
Cohesion: 0.50
Nodes (4): ADR-015: Dev and Prod Two Full Stacks on Same VPS, ADR-017: Traefik + Docker Labels for Routing, Docker Container Runtime, Traefik Reverse Proxy

### Community 357 - "11. Red-Team: 3 Concrete Failure Modes & Mitigations"
Cohesion: 0.50
Nodes (4): 11. Red-Team: 3 Concrete Failure Modes & Mitigations, Red-Team 1: Cost/Margin Data Leaked to Unauthorized Role, Red-Team 2: Rounding/Precision Gap Causes Silent Wrong Invoice, Red-Team 3: GST Invoice Sequencing Violation (Audit Non-Compliance)

### Community 358 - "7. Data Sensitivity & Access Model"
Cohesion: 0.50
Nodes (4): 7. Data Sensitivity & Access Model, Generated Video Content, LLM Provider Keys, User & Session Data

### Community 359 - "VideoSmith Phase 1: Core Video Generation Pipeline"
Cohesion: 0.50
Nodes (4): ADR-062 Full Tiered Chain (Phase 1 Requirement), MoneyPrinterTurbo Internal-Only Deployment Model, Network Isolation (Docker-Only, No Traefik Label), VideoSmith Phase 1: Core Video Generation Pipeline

### Community 361 - "2. Domain 1 — Branding & printing (print MIS)"
Cohesion: 0.50
Nodes (4): 2.1 Product landscape, 2.2 Estimation logic (highest-value extraction), 2.3 eFlexo 45-day trial — capture checklist (do before expiry), 2. Domain 1 — Branding & printing (print MIS)

### Community 362 - "4. Architecture"
Cohesion: 0.50
Nodes (4): 4.1 Screens and UI flows, 4.2 Session and auth, 4.3 Local storage and IndexedDB, 4. Architecture

### Community 363 - "8. Offline + sync strategy"
Cohesion: 0.50
Nodes (4): 8.1 Service Workers, 8.2 IndexedDB, 8.3 Reconciliation sync, 8. Offline + sync strategy

### Community 364 - "IBU Case Study - Luxury Red Sports Car Product Photography"
Cohesion: 0.67
Nodes (4): Bellair Case Study - Toronto Street Urban Photography, IBU Case Study - Luxury Red Sports Car Product Photography, Podium Background - Minimalist Product Display Setup, Salient Case Study - DNA Helix Scientific Illustration

### Community 365 - "Lounge Hair Studio - From Fine Hair to Volume Campaign"
Cohesion: 0.50
Nodes (4): Lounge Hair Studio - From Fine Hair to Volume Campaign, EltaMD Skin Care - SPF and Skin Recovery Serum Campaign, Etherea Laser - Celebrating 1 Million Treatments Globally Campaign, EltaMD Skin Recovery Serum - Product Information Design

### Community 366 - "tour.js"
Cohesion: 0.83
Nodes (3): close(), go(), render()

### Community 367 - "Substrate specifications (manufacturer-verifiable)"
Cohesion: 0.50
Nodes (4): Acrylic / polycarbonate, Aluminum, Expanded PVC (Sintra), Substrate specifications (manufacturer-verifiable)

### Community 376 - "360LM Activity PWA"
Cohesion: 0.67
Nodes (3): safe-bottom.css, 360LM Activity PWA, manifest.json

### Community 377 - "Employee Access Control Is Dual-Written to DB and hub-access.json"
Cohesion: 0.67
Nodes (3): Employee Access Control Is Dual-Written to DB and hub-access.json, Counter Sync Prefers RPC Falls Back to stores.json, Dual-Write DB and File Fallback Pattern

### Community 378 - "Vehicle Log PWA"
Cohesion: 0.67
Nodes (3): ADR-089: Bilingual UI platform, Vehicle Log PWA, vehicle.trips - Trip Record

### Community 379 - "Customer Management mini-PWA"
Cohesion: 1.00
Nodes (3): Customer Management Manual Testing Guide, Customer Management CiC Walkthrough (Phases 1-5), Customer Management mini-PWA

### Community 380 - "OpenRouter Account + API Key CiC Walkthrough"
Cohesion: 0.67
Nodes (3): OpenRouter Account + API Key CiC Walkthrough, Health Tracker PWA, OpenRouter API (Health Tracker OCR)

### Community 381 - "ADR-023: Push Notifications Self-Hosted VAPID"
Cohesion: 0.67
Nodes (3): VAPID Self-Hosted Push Notifications, ADR-023: Push Notifications Self-Hosted VAPID, Push Notifications Server (port 8770)

### Community 382 - "360LM Contacts PWA"
Cohesion: 0.67
Nodes (3): 360LM Contacts PWA, Dexie IndexedDB Integration in Contacts PWA, Share Contacts Upload PWA

### Community 384 - "Custodian Tutorial - NEFT Transfer Filled"
Cohesion: 0.67
Nodes (3): Custodian Tutorial - Transfer Form (Empty), Custodian Tutorial - NEFT Transfer Filled, Custodian Dashboard - After NEFT Transfer

### Community 385 - "Reject Transfer Modal with Reason Field"
Cohesion: 0.67
Nodes (3): Harish Pending Transfers Banner, Reject Transfer Modal with Reason Field, Harish Dashboard After Rejecting Transfer

### Community 386 - "Sales PWA (main)"
Cohesion: 0.67
Nodes (3): Dashboard Screen (Sales PWA), Login Screen (Sales PWA), Sales PWA (main)

### Community 388 - "ADR-004: Maps Strategy — Google Primary, TomTom Fallback"
Cohesion: 0.67
Nodes (3): ADR-004: Maps Strategy — Google Primary, TomTom Fallback, Google Maps API, TomTom Maps API

### Community 389 - "2. Inspiration vs. Scope"
Cohesion: 0.67
Nodes (3): 2. Inspiration vs. Scope, Intentional Out-of-Scope for v1, References Studied

### Community 390 - "8. Open Questions — RESOLVED by User (2026-07-03)"
Cohesion: 0.67
Nodes (3): 8. Open Questions — RESOLVED by User (2026-07-03), Architecture Questions, Technical Questions

### Community 392 - "4.1 Custodian profiles + wallets"
Cohesion: 0.67
Nodes (3): 4.1 Custodian profiles + wallets, `custodian.profiles` — who holds cash, `custodian.wallets` — running balance per custodian

### Community 394 - "Finance PWA Icon (512px)"
Cohesion: 0.67
Nodes (3): Finance PWA Icon (512px), Google Pay UPI Icon, PhonePe UPI Icon

### Community 395 - "Admin PWA - Administration"
Cohesion: 0.67
Nodes (3): Admin PWA Icon 192px, Admin PWA Icon 512px, Admin PWA - Administration

### Community 396 - "Learning Hub catalog: rent-vehicle tutorial group"
Cohesion: 1.00
Nodes (3): Learning Hub catalog: rent-vehicle tutorial group, Scene guide: 12-step visual walkthrough (case study Sachin), Tutorial video metadata: script sections, clips, voiceover

### Community 397 - "PCA Skin"
Cohesion: 0.67
Nodes (3): Leibel Insurance, Lounge Hair Studio, PCA Skin

### Community 398 - "Unified Payments Interface (UPI)"
Cohesion: 0.67
Nodes (3): Google Pay Payment System, Paytm Payment Gateway, Unified Payments Interface (UPI)

### Community 399 - "Recce Client Portal Tutorial (Hinglish/English)"
Cohesion: 0.67
Nodes (3): Recce Client Portal Tutorial (Hinglish/English), View Tracking (Learning Hub Integration, start_view/end_view RPC), Rent Vehicle Tutorial (Bilingual Screencast)

## Knowledge Gaps
- **3574 isolated node(s):** `prebuild_check.sh script`, `name`, `short_name`, `description`, `start_url` (+3569 more)
  These have ≤1 connection - possible missing edges or undocumented components.
- **273 thin communities (<3 nodes) omitted from report** — run `graphify query` to explore isolated nodes.

## Suggested Questions
_Questions this graph is uniquely positioned to answer:_

- **Why does `ADR-111: Unified Job Record in sales.jobs` connect `ADR-111: Unified Job Record in sales.jobs` to `Sales PWA`, `Hub PWA`, `Tour Planner PWA`, `ADR-032: expense.employees as FK anchor`, `Custodian Expense Voucher module`?**
  _High betweenness centrality (0.022) - this node is a cross-community bridge._
- **Why does `ADR-046: installation.campaigns Canonical Job Record` connect `ADR-111: Unified Job Record in sales.jobs` to `WIKI.md`?**
  _High betweenness centrality (0.020) - this node is a cross-community bridge._
- **Are the 2 inferred relationships involving `BTL Offers — Gift Claim Portal PWA` (e.g. with `BTL PWA Icon 192x192` and `BTL PWA Icon 512x512`) actually correct?**
  _`BTL Offers — Gift Claim Portal PWA` has 2 INFERRED edges - model-reasoned connections that need verification._
- **What connects `prebuild_check.sh script`, `name`, `short_name` to the rest of the system?**
  _3574 weakly-connected nodes found - possible documentation gaps or missing edges._
- **Should `_` be split into smaller, more focused modules?**
  _Cohesion score 0.052659716653301256 - nodes in this community are weakly interconnected._
- **Should `_` be split into smaller, more focused modules?**
  _Cohesion score 0.052659716653301256 - nodes in this community are weakly interconnected._
- **Should `brevo_domain_auth.js` be split into smaller, more focused modules?**
  _Cohesion score 0.05669199298655757 - nodes in this community are weakly interconnected._