Constraints

5 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
journey_barrier_run_id_fkey
journey_barrier.run_id
journey_run.id
Cascade on delete
journey_narrative_run_id_fkey
journey_narrative.run_id
journey_run.id
Cascade on delete
journey_route_run_id_fkey
journey_route.run_id
journey_run.id
Cascade on delete
journey_page_a11y_run_id_fkey
journey_page_a11y.run_id
journey_run.id
Cascade on delete
journey_step_run_id_fkey
journey_step.run_id
journey_run.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
journey_barrier journey_barrier_confidence_check (confidence = ANY (ARRAY['high'::text, 'medium'::text, 'low'::text]))
journey_barrier journey_barrier_disposition_check (disposition = ANY (ARRAY['agent-navigation-error'::text, 'agent-model-error'::text, 'site-barrier-confirmed'::text, 'site-barrier-suspected'::text, 'ambiguous'::text]))