Funnel

Tables (8)

Question Extra (list_templates)

  • gid — Foreign key → question_groups.gid — NOT NULL
  • template_values (Field)

group_question_mapping (questions)

  • qid — Foreign key → questions.qid — NOT NULL
  • gid (gid2) — Foreign key → question_groups.gid — NOT NULL

options (candidates)

  • id (Key) — Primary key — NOT NULL
  • type (Field)
  • label (Field3)
  • next (Field2)

question_candidate_mapping

  • qid — Foreign key → questions.qid — NOT NULL
  • id (Key2) — Foreign key → options.id — NOT NULL

question_groups

  • gid — Primary key — NOT NULL
  • name
  • sheet_target_pos
  • sheet_etc_pos
  • root_qid (Field)

question_set_group_mapping

  • setid (id) — Foreign key → question_sets.id — NOT NULL
  • gid — Foreign key → question_groups.gid — NOT NULL

question_sets

  • id — Primary key — NOT NULL
  • root_gid (Field)

questions (CopyOfquestion_groups)

  • qid — Primary key — NOT NULL
  • template_id (title)
  • next