Databases

Dynamic Survey Builder & Branching Schema

ER Diagrams · made in Skemio

ER diagram showing surveys, survey_steps, branching_rules, survey_responses, and response_answers.
ER diagram showing surveys, survey_steps, branching_rules, survey_responses, and response_answers.

What it shows

  • Questions sit in orderable steps with typed response constraints.
  • Branching rules evaluate condition operators against submitted values.
  • Answers store heterogeneous values in JSONB without altering schema.

The takeaway

Represent question steps and conditional branching as directed graph edges evaluated against submitted answers.

More er diagrams