Check relationship_members for NULL scope_uuids

Type: sql Component: rpe-context-assembler Tags: relationship-members,scope-uuid,p1.7,data-integrity Assertion: exact_match Last result:
Validates

Confirms no orphaned NULL scope_uuids in relationship_members. A non-empty result means human participants are missing scope_uuid assignment or bot participants predate migration 016.

Expected Output
Zero rows returned. All participants have scope_uuids populated.
Script
SELECT id, relationship_id, participant_a, participant_a_scope_uuid, participant_b, participant_b_scope_uuid FROM zoey_core.relationship_members WHERE participant_a_scope_uuid IS NULL OR participant_b_scope_uuid IS NULL ORDER BY id;
Run Tool

Run History

No runs yet