S158 Collection Classification Report

Session: S158 | Date: 2026-03-21 | Status: COMPLETE PRs: None needed (data-only operations via PG UPDATE)

Assembly Gate

• Q0: YES — collection_registry = PG table. Chi UPDATE governance_role.
• Q1: YES — collection_registry da co san, dot-collection-register --update available.
• Q2: Nuxt auto-reflects via API. No code changes.
• Q3: NO code moi. Chi data classification.
• Q4: PG query: 0 unclassified.
• Q5: Rollback: UPDATE governance_role = NULL.

Summary

governance_role	count	description
governed	19	Entity collections with species mapping + birth triggers
observed	43	Logs, support tables, business comms, AI, governance infra
excluded	76	CMS blocks, OS CRM, pages, website/nav, junction tables, system backup
TOTAL	138	0 unclassified

Classification Detail

Governed (19) — managed entities with species + birth triggers

agents, checkpoint_sets, checkpoint_types, collection_registry, dot_tools, entity_dependencies, entity_labels, entity_species, meta_catalog, modules, system_issues, table_registry, tasks, taxonomy, taxonomy_facets, ui_pages, workflow_change_requests, workflows, workflow_steps

Observed (43)

Governance infra/logs (12): registry_changelog, lifecycle_log, entity_audit_queue, derived_objects_registry, trigger_registry, universal_edges, universal_rule_registry, universal_rule_run_results, universal_rule_runs, universal_rule_violations, v_registry_counts, v_registry_summary

Business support/comms (17): billing, sales, contacts, organizations, organization_addresses, content_requests, conversations, messages, feedbacks, inbox, help, help_articles, help_collections, help_feedback, doc_reviews, knowledge_documents, governance_docs

Task/checkpoint support (8): checkpoint_instances, checkpoint_rules, checkpoint_type_overrides, task_checkpoints, task_comments, comments, table_proposals, workflow_categories

AI (4): ai_discussions, ai_discussion_comments, ai_tasks, agent_views

Previously classified (2): directus_fields, label_rules

Excluded (76)

CMS blocks (26): block_button, block_button_group, block_button_groups, block_buttons, block_columns, block_columns_rows, block_cta, block_divider, block_faqs, block_form, block_gallery, block_gallery_files, block_hero, block_html, block_library, block_logocloud, block_logocloud_logos, block_quote, block_richtext, block_step_items, block_steps, block_team, block_testimonials, block_testimonial_slider_items, block_video, blocks

CMS pages (8): pages, pages_blocks, pages_blog, pages_projects, pages_translations, page_blocks, posts, post_gallery_items

OS CRM (24): os_activities, os_activity_contacts, os_deal_contacts, os_deals, os_deal_stages, os_email_templates, os_expenses, os_invoice_items, os_invoices, os_items, os_payments, os_payment_terms, os_project_contacts, os_projects, os_project_templates, os_project_updates, os_proposal_approvals, os_proposal_blocks, os_proposal_contacts, os_proposals, os_settings, os_task_files, os_tasks, os_tax_rates

Website/nav/system (13): navigation, navigation_items, navigation_navigation_items, website, seo, redirects, globals, languages, team, testimonials, categories, forms, _permissions_backup_s132c

Junction tables (5): organizations_contacts, checkpoint_set_items, species_collection_map, taxonomy_matrix, workflow_step_relations

VERIFY NUXT

• Nuxt URL: /knowledge/registries → 200 OK. collection_registry row shows 138 entities. PG: 138. KHOP.
• Nuxt URL: /knowledge/registries/species → 200 OK. Species Matrix: 20 species. PG: 20. KHOP.

Spot Check (5 random per category)

Collection	Expected	Actual	PASS
workflows	governed	governed	PASS
dot_tools	governed	governed	PASS
team	excluded	excluded	PASS
os_proposal_approvals	excluded	excluded	PASS
ai_discussions	observed	observed	PASS

Cross-check: governed vs species_collection_map

19 governed collections all have species mappings (confirmed via LEFT JOIN). No governed collection without species_code.

Tu Kiem Tra

#	Cau hoi	Ket qua
1	Da doc SSOT + quote checkpoint?	DAT (OR v4.49, §I #3: DINH NGHIA TRUOC LAM SAU)
2	Schema fields governance_role ton tai?	DAT (da co tu S153)
3	Unclassified = 0?	DAT (PG verified)
4	governed count khop species_collection_map?	DAT (19 = 19)
5	excluded = tat ca block/CMS/OS/junction?	DAT (76 collections)
6	Spot check 5 random OK?	DAT
7	CI GREEN? Smoke PASS?	N/A (no code changes)
8	VERIFY NUXT section day du?	DAT
9	Report dung path?	DAT

S158 COMPLETE. 138/138 collections classified. 0 unclassified.

---

S158 | 2026-03-21 | 138 collections: 19 governed + 43 observed + 76 excluded | 0 unclassified