Skip to content

스킬 검색.../

Agent Skill Search Engine

검색

검색
카테고리
직업

About

About
Privacy
Terms

© 2026 Skills Pool. All rights reserved.

Unity Erp Tenancy | Skills Pool

스킬 파일

Unity Erp Tenancy

Unity ERP multi-tenancy (organizations) workflow. Use when adding org_id, backfilling data, tightening RLS, debugging "null nested relation" issues, or implementing tenant-scoped module access.

MaierG740 스타2026. 2. 16.

직업
카테고리: 생산성 및 통합

스킬 내용

Unity ERP Tenancy (Organizations)

Scope: $ARGUMENTS

Canonical Docs (start here)

docs/README.md
docs/operations/tenant-data-isolation-zero-downtime-runbook.md
docs/operations/tenant-module-entitlements-runbook.md
docs/operations/tenant-rollout-status.md
docs/overview/todo-index.md

Vocabulary

Use organization consistently in UI/code/docs.
"Tenant" is acceptable as a synonym in technical discussion.

Default Approach (safe for live systems)

Follow the staged plan in the runbook. The intent is zero downtime and easy rollback:

Expand-only first: add as nullable + default/backfill + indexes + FK.

관련 스킬

빠른 설치

Unity Erp Tenancy

npx skillvault add MaierG74/maierg74-unity-erp-claude-skills-unity-erp-tenancy-skill-md

Skill 다운로드 저장소 열기

작성자: MaierG74
스타: 0
업데이트: 2026. 2. 16.
직업

이 페이지의 내용

01Unity ERP Tenancy (Organizations)

org_id

NOT VALID

Verify data consistency:

No org_id IS NULL rows for the tables you touched.
Parent/child org alignment is correct.
No users missing public.organization_members.

Tighten RLS in baby steps:

One table at a time.
Add org-scoped policies while leaving existing permissive policies in place.
Verify with a normal user.
Only then remove permissive policies.

Enforce constraints later:

VALIDATE CONSTRAINT on FKs once stable.
Only then consider SET NOT NULL on org_id.

Common Pitfall: "Nested relation is null"

Supabase nested selects can return null for embedded objects when:

the user is missing an org membership row, or
one related table is RLS-locked while the other is not, or
the join row exists but is blocked by RLS.

UI code must treat nested relations as nullable and avoid direct dereferences like: row.supplier_component.component.internal_code

Server-Side Patterns (prefer these)

Org resolution + membership:
- lib/api/org-context.ts
Module entitlement checks:
- lib/api/module-access.ts

Guard Rails

Never tighten RLS in production without running the "users missing membership" check in the runbook.
When debugging a "works for super admin but not normal user" issue, suspect:
- missing organization_members row, or
- RLS blocking a nested relation.

02

Canonical Docs (start here)

04Default Approach (safe for live systems)

05Common Pitfall: "Nested relation is null"

06Server-Side Patterns (prefer these)

데이터베이스 아키텍트

생산성 및 통합

Feishu Perm

Feishu permission management for documents and files. Activate when user mentions sharing, permissions, collaborators.

생산성 및 통합

Discord

Discord ops via the message tool (channel=discord).

자동화 도구

Coding Agent (bash-first)

Delegate coding tasks to Codex, Claude Code, or Pi agents via background process. Use when: (1) building/creating new features or apps, (2) reviewing PRs (spawn in temp dir), (3) refactoring large codebases, (4) iterative coding that needs file exploration. NOT for: simple one-liner fixes (just edit), reading code (use read tool), thread-bound ACP harness requests in chat (for example spawn/run Codex or Claude Code in a Discord thread; use sessions_spawn with runtime:"acp"), or any work in ~/clawd workspace (never spawn agents here). Claude Code: use --print --permission-mode bypassPermissions (no PTY). Codex/Pi/OpenCode: pty:true required.

생산성 및 통합

Apple Notes

Manage Apple Notes via the `memo` CLI on macOS (create, view, edit, delete, search, move, and export notes). Use when a user asks OpenClaw to add a note, list notes, search notes, or manage note folders.

지식 베이스

Feishu Wiki

Feishu knowledge base navigation. Activate when user mentions knowledge base, wiki, or wiki links.

생산성 및 통합

Bear Notes

Create, search, and manage Bear notes via grizzly CLI.

데이터베이스 아키텍트