Solutionunvalidated
add an `orgId` FK column to `tenants` pointing at `organization.id` — during transition. Tension: sync it on create/transfer, keep `tenants.id` as the stable internal identifier forever. Outcome: keep `tenants.id` as the canonical RLS target.
db510b77-2bd7-4202-9e14-f72e943fb7b6
add an orgId FK column to tenants pointing at organization.id — during transition. Tension: sync it on create/transfer, keep tenants.id as the stable internal identifier forever. Outcome: keep tenants.id as the canonical RLS target.