メニュー
Use when implementing or modifying multi-tenant (organization/org_id) behavior in Unity ERP. Covers the staged rollout approach, verification queries, and common pitfalls like missing org membership causing null nested relations.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
| name | unity-erp-tenancy |
| description | Use when implementing or modifying multi-tenant (organization/org_id) behavior in Unity ERP. Covers the staged rollout approach, verification queries, and common pitfalls like missing org membership causing null nested relations. |
docs/README.mddocs/operations/tenant-data-isolation-zero-downtime-runbook.mddocs/operations/tenant-module-entitlements-runbook.mdorg_id nullable + backfill + defaults + indexes + NOT VALID FKs.org_id filled, parent/child match).NOT NULL).docs/operations/tenant-data-isolation-zero-downtime-runbook.md.public tables that include org_id, the expected end-state is:
org_id is NOT NULLUSING true / WITH CHECK true authenticated policies20260225073626_timekeeper_anon_read_hotfix_qbutton.sql20260225074120_timekeeper_anon_insert_policy_fix.sql20260225074246_timekeeper_anon_policy_uuid_lock_fix.sql20260225074503_timekeeper_trigger_security_definer_fix.sqlQbutton staff while keeping authenticated org-scoped policies intact.anon policies on staff / time_clock_events without replacing scanner auth flow first.Read docs/operations/tenant-data-isolation-zero-downtime-runbook.md and use the queries in:
organization_members)If one table is tenant-locked but a related table is not (or a user has no org membership), Supabase nested selects can return null for embedded objects.
UI must treat nested relations as nullable and avoid direct dereferences like:
row.supplier_component.component.internal_code
After each migration baby step:
Known local/dev smoke noise (not tenancy regressions):
cutlist_material_defaults may return 406 for users with no defaults row.406/401/404 when the record/context is missing.For current production state and next steps, see:
docs/overview/todo-index.mdBlueprint for building or upgrading detail pages (entity views with tabs/sections) to match Unity ERP's visual depth standard. Use when creating a new detail page, upgrading an existing one that feels flat, or adding tabs/sections to an entity view. Covers page canvas, sticky headers, sidebar decisions, gradient stat cards, and accent borders.
Use when adding a new furniture template, modifying parametric parts generation, extending the configurator UI (forms, previews, edge banding), or porting the configurator pattern to another project.
Use when building a Polygon sales document — pitch advert, capability pamphlet, product brochure, or any image-and-quote-led PDF in the spine+nervous-system visual brand. Triggers include "build a pitch pamphlet for [prospect]", "make an advert for [agent name]", revising/extending the existing Tight Factories advert or Purchasing Agent pamphlet, or porting the same pattern to a new agent (Inter-Site Transfer Agent, Daily Brief Agent, etc.).
Tailwind CSS v4 and shadcn v4 reference for Unity ERP. Use when writing or editing Tailwind classes, modifying globals.css or @theme config, adding shadcn components, or any frontend styling work. Prevents writing outdated v3 syntax from training data.
Unity ERP domain-specific business rules. Use when working on staff/attendance/payroll, time clock logic, file storage/uploads, or any module where non-obvious business logic applies.
Cutting diagram PDF layout, dimension labels, and rendering. Use when fixing or enhancing the PDF cutting diagram — panel labels, dimension overlays, sheet dimensions, legend table, or SVG layout.