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