WorkHive: Platform Architecture

Last audited: 2026-04-18 · All checks PASS

Legend Write (cross-page insert) Read (cross-page query) Bidirectional Entry point Retired Hover nodes and arrows for detail

Entry Point

🏠

Home / Sign In

index.html

Identity gate. Hive join / create.

📋

Logbook

logbook.html

Work records, faults, PM logs.

📅

Day Planner

dayplanner.html

DILO / WILO / MILO / YILO.

🤖

AI Assistant

assistant.html

Platform-aware AI chat.

🐝

Hive Board

hive.html

Team feed. Reads logbook + PM.

📦

Inventory

inventory.html

Parts catalog. Linked to logbook.

🔧

PM Scheduler

pm-scheduler.html

PM tasks, completions, asset mgmt.

🎯

Skill Matrix

skillmatrix.html

Skills, exams, badges, radar.

RETIRED

🗄️

Parts Tracker

parts-tracker.html

Retired. Parts now in logbook.

Supabase Tables: Ownership + Risk Columns

logbook

Owner: logbook.html

date · machine · maintenance_type
category · problem · action
knowledge · status · closed_at
hive_id · worker_name
asset_node_id · pm_completion_id

pm_completions

Owner: pm-scheduler.html

asset_id · scope_item_id
completed_at · findings
action_taken · hive_id
worker_name · next_due

hive_members

Owner: hive.html

hive_id · worker_name
role · status · joined_at
created_by

inventory_items

Owner: inventory.html

name · category · qty
unit · min_qty · hive_id
worker_name · status

pm_assets

Owner: pm-scheduler.html

name · category · location
hive_id · worker_name
registered_at

pm_scope_items

Owner: pm-scheduler.html

asset_id · item_text
frequency · category
created_at

LocalStorage Key Chains (identity gate: all pages must read all aliases)

Worker Identity

wh_last_worker || wh_worker_name || workerName → redirect if empty

Hive ID

wh_active_hive_id || wh_hive_id → null if absent

Hive Role

wh_hive_role · always re-validate from DB

Nav Hub

wh-hub-position · FAB snap position (left/right)

Cross-Page Data Flows: Living Registry

Source	Target Table	Trigger	Risk Columns (must verify on every change)
pm-scheduler.html	logbook	User marks PM task done with "Log to Logbook" on	category (use task's PM category, not asset category) · closed_at (always set when Closed) · maintenance_type
pm-scheduler.html	pm_completions	Same PM task completion trigger	hive_id · worker_name
logbook.html	pm_completions	User logs a PM entry with PM tasks checked	hive_id · worker_name · scope_item_id
hive.html ← reads	logbook + pm_completions	Hive feed load on page open	Both tables must have hive_id populated · Old rows without hive_id fall to worker-name fallback
inventory.html ↔	logbook (parts used)	Parts used added to a logbook entry	Transaction must reference logbook entry id · Inventory qty decremented

Nav Hub Registry Status

Page	In nav-hub.js	Match string
index.html	✓ PASS	`index, /`
logbook.html	✓ PASS	`logbook`
dayplanner.html	✓ PASS	`dayplanner`
assistant.html	✓ PASS	`assistant`
hive.html	✓ PASS	`hive`
inventory.html	✓ PASS	`inventory`
pm-scheduler.html	✓ PASS	`pm-scheduler`
skillmatrix.html	✓ PASS	`skillmatrix`
checklist.html	✗ Retired
parts-tracker.html	✗ Retired

Integrity Audit: Last Run 2026-04-18

Check	Result
Nav Hub Registry (all live pages)	✓ PASS
utils.js load order	✓ PASS
Identity key fallback chain	✓ PASS
Hive ID fallback chain	✓ PASS
AI assistant platform context	✓ PASS
Retired page references	✓ PASS
companion-launcher.js page context registry	✓ PASS
Cross-page insert field parity	✓ PASS
Category mapping source correctness	✓ PASS
Data flow registry completeness	✓ PASS