KB-4896
07 — Official List Inventory (15 lists)
7 min read Revision 1
architecturediscoveryofficial-listsinventorypivotreuse-first
07 — Official List Inventory
For each list: source, owner law, existing artifacts, current vs planned count method, and readiness across pivot / birth / IU-KG / DOT-refresh / UI. No new lists designed here. Readiness: ✅ live · 🟡 partial · ❌ absent.
Legend for count method — PIV-xxx = already covered by a live pivot_definition.
1. DOT Registry List
- Source: PG
dot_tools(309) +dot_iu_command_catalog(54). Owner law: Đ23/Đ35. Live count: PIV-007 (309). Pivot ✅ · Birth 🟡 (dot_tool species births exist) · IU-KG 🟡 (dot_tools→taxonomy edges; 2 IU rows only) · DOT-refresh ✅ (fn_refresh_dot_count/orphan) · UI 🟡 (manifest itemdot-registry, spec_ready). Reconcile: CAT-006 vs CAT-DOT dual count; 178 unpaired. Action: REUSE pivot; RECONCILE count target. (Deep-dive doc 08.)
2. UI Preview Master List
- Source: manifest (static JSON on VPS). Owner law: Đ28. Live count: hand-baked in JSON (61/36/25/16), no pivot. Pivot ❌ · Birth ❌ · IU-KG ❌ (surfaces not IUs) · DOT-refresh ❌ · UI ✅ (it is the UI). Reconcile: vs
ui_pages(37 live, PG) — no join key. Action: EXTEND to PG-backed + NEW pivot; RECONCILE with ui_pages. (Deep-dive doc 09.)
3. Workflow Design List
- Source: PG
workflows(2) +workflow_steps(70) +workflow_step_relations(80), body inline (bpmn_xml/narrative), NOT IU-bound. Owner: Đ37/Đ7 (MOWD under GOV-MOW, not 5th Mother). Count: PIV-004/005. Pivot ✅ · Birth 🟡 · IU-KG ❌ (no iu_ref cols) · DOT-refresh 🟡 · UI 🟡 (workflow-designspec_ready). Action: EXTEND with iu_ref/owner_gov_code (additive).
4. Workflow Runtime List
- Source: ❌ runtime tables (
workflow_instance/task_instance) not born (manifest DATA items, not_started/spec_ready). Owner: Đ45/Đ37. Count: n/a. Pivot ❌ · all ❌. Action: DEFER (runtime out of scope) / NEW under Đ45 when needed.
5. Task List
- Source: PG
tasks(10) +task_comments(75) +task_checkpoints. Owner: GOV-MOT (draft). Count: PIV-010/021. Pivot ✅ · Birth 🟡 · IU-KG ❌ · DOT-refresh 🟡 · UI 🟡 (task-registry/my-tasks-dashboard). Action: REUSE pivot.
6. Field Registry List
- Source: directus_fields (1,482) live;
field_registryproposed ABSENT;collection_field_standards(11, has tier). Owner: GOV-MOIT (draft). Count: none for proposed registry. Pivot ❌ (for new registry) · Birth ❌ (dress-rehearsed) · IU-KG ❌ · UI 🟡 (field-registry/field-registry-manager). Action: RECONCILE (directus_fields = field truth) before NEW; await Đ32.
7. Trigger Registry List
- Source: PG
trigger_registry(107) = physical DB triggers. Owner: Đ31/system. Count: PIV-015. Pivot ✅ · Birth 🟡 · IU-KG 🟡 (trigger_registry→taxonomy 354 edges) · DOT-refresh 🟡 · UI 🟡 (trigger-registry). COLLISION: not the same as design/business triggers (workflow_trigger_designabsent). Action: REUSE for DB triggers; NEW separate table for design triggers.
8. Input Form Registry List
- Source:
input_form_registryABSENT;forms/block_formempty (0). Owner: GOV-MOIT. Count: n/a. All ❌. UI 🟡 (input-form-registry/moit-form-builder). Action: NEW (await Đ32); form definitions currently unborn.
9. Output Table Registry List
- Source:
design_templates(1) is the de-facto output substrate;output-table-registryproposed absent. Owner: GOV-MOUT (draft) / Đ28. Count: n/a. Pivot ❌ · UI 🟡 (output-table-registry/mout-table-renderer). Action: EXTEND design_templates / NEW registry under MOUT.
10. Personnel / Role / Agent List
- Source: PG
directus_users(13) +directus_roles(9) +directus_policies(8) +agents(6). Owner: Đ37 (human-org-role unborn). Count: PIV-011 (agents). Pivot 🟡 (agents only) · Birth 🟡 · IU-KG ❌ · UI 🟡 (personnel-registry/role-registry/agent-registry). Action: REUSE Directus RBAC + agents; add pivots for users/roles.
11. Approval / Proposal List
- Source: PG
approval_requests(211) +apr_approvals(42) +workflow_change_requests(3) +table_proposals(0). Owner: Đ32/Đ37. Count: PIV-207. Pivot ✅ · Birth 🟡 · IU-KG ❌ · DOT-refresh ✅ · UI 🟡 (approval-queue/approval-queue-manager). Action: REUSE as universal approval spine for all list changes.
12. Event / Notification / DLQ List
- Source: PG
event_outbox(165k) +event_type_registry(40) +iu_outbound_route(15) +job_queue/DLQ (0). Owner: Đ45. Count: pivotable on event_type_registry (add pivot). Pivot 🟡 · Birth 🟡 · IU-KG 🟡 · DOT-refresh 🟡 · UI 🟡 (notification-queue/trigger-event-log/notification-center). Action: REUSE single substrate; flip dry_run when ready.
13. Collection / Table / Meta Catalog List
- Source: PG
meta_catalog(169, SoT) +collection_registry(168) +table_registry(21, UI defs). Owner: Đ26/Đ36/Đ29. Count: PIV-001/002/009 + refresh_meta_catalog_from_pivot. Pivot ✅ · Birth ✅ · IU-KG 🟡 · DOT-refresh ✅ · UI ✅ (/knowledge/registries). Action: REUSE — this is the reference implementation of a living list.
14. IU / KG Relation List
- Source: PG
information_unit(219) +iu_relation(60) +universal_edges(2199) + viewv_kg_edges_all(2259). Owner: Đ38/Đ39/Đ44. Count: pivotable (add PIV for IU/edges). Pivot 🟡 · Birth 🟡 · IU-KG ✅ · DOT-refresh 🟡 (fn_iu_kg_edge_audit) · UI ❌. Action: REUSE as semantic/profile layer; add count pivots.
15. Law / Normative Registry List
- Source: PG
normative_registry(47, metadata SoT) +law_catalog(5, legacy) +governance_registry(9); text in KB. Owner: Đ38/Đ37. Count: add pivot (none today). Pivot ❌ · Birth 🟡 · IU-KG ✅ (law_units 187 in IU) · DOT-refresh 🟡 · UI 🟡. Reconcile: Đ23/Đ45 missing from normative_registry; law_catalog stale. Action: RECONCILE (register Đ23/45, deprecate law_catalog); add count pivot.
Pattern observed
The mature lists (DOT, collection/meta, approval, workflow, task, trigger, agents) are already PG-backed and pivot-counted. The immature lists (UI Preview Master, field/form/output, runtime, human-org-role) are either static files or unborn registries. The reuse-first path: lift immature lists onto the same meta_catalog + pivot + birth + approval pattern the mature lists already use — do not invent a parallel "living list" engine.