Mission 2: DOT Khai Báo Pivot — Report (Điều 26 v3.5)

Date: 2026-03-28 | PR: #641 | Status: MERGED + DEPLOYED

---

Step 0: Checkpoint Quotes

Operating Rules v5.x

v5.4 | 2026-03-28 — Mission 1 DONE (PR #640). pivot_count() LIVE. 30 triggers DISABLED. Mission 2 tiếp.

Merge Rule

CI GREEN = CHỈ 4 required checks GREEN: Pass Gate, Quality Gate, check-critical-files, Contract Schema Validation.

Verify Nuxt Rule

§0-AF: EVIDENCE bắt buộc từ production URL https://vps.incomexsaigoncorp.vn/api/...

Assembly Gate

#	Question	Answer
Q0	PostgreSQL ready?	YES — pivot_definitions + pivot_count() LIVE from Mission 1
Q1	Assembly First quoted?	YES
Q2	Directus available?	dot_tools collection for registration
Q3	Nuxt available?	No Nuxt changes needed — DOT tools are bash scripts
Q4	New code lines?	~150 lines dot-pivot-declare + ~200 lines dot-pivot-health
Q5	DOT tools reuse?	Pattern from dot-pg-views-ensure (SSH+psql)

---

DOT Tools Created

DOT-113: dot-pivot-declare

• File: dot/bin/dot-pivot-declare
• Single mode: --source <table> --name "<name>" [--filter] [--group] [--level]
• Batch mode: --auto-from-meta-catalog (reads from meta_catalog, no hardcode)
• Idempotent: duplicate check before INSERT
• Test: --auto-from-meta-catalog → "0 new" (all already declared from M1)

DOT-114: dot-pivot-health

• File: dot/bin/dot-pivot-health
• 7 checks: H1 execution, H2 counts, H3 source_objects, H4 coverage, H5 orphans, H6 duplicates, H7 cross-check
• --fix mode: auto-repair H4 (declare missing) + H5 (deactivate orphans)
• Test output:

---

VERIFY NUXT

---

Summary

#	Check	Status
1	Step 0 quotes	DONE
2	dot-pivot-declare created + works	DONE
3	--auto-from-meta-catalog works	DONE
4	dot-pivot-health 7 checks work	DONE
5	2 tools registered dot_tools	DONE (DOT-113, DOT-114)
6	Local build PASS	DONE
7	1 PR, 1 commit	DONE (PR #641)
8	CI GREEN (no --admin)	DONE
9	0 manual deploy	DONE
10	Production URL verified	DONE
11	Report uploaded	DONE

Mission 2 COMPLETE. Next: Mission 3 (VIEW cross-table).