1234

Tables (14)

answer

  • id — bigint — Primary key — NOT NULL
  • question_id — bigint — NOT NULL
  • review_id — bigint — Foreign key → new_review.id — NOT NULL

highlight

  • id — bigint — Primary key — NOT NULL
  • answer_id — bigint — NOT NULL
  • line_index — int — NOT NULL
  • start_index — int — NOT NULL
  • end_index — int — NOT NULL

new_checkbox_answer

  • id — bigint — Foreign key → answer.id — NOT NULL

new_checkbox_answer_selected_option

  • id — bigint — Primary key — NOT NULL
  • checkbox_answer_id — bigint — Foreign key → new_checkbox_answer.id — NOT NULL
  • selected_option_id — bigint — NOT NULL

new_review

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • review_group_id — bigint — NOT NULL
  • template_id — bigint — NOT NULL

new_text_answer

  • id — bigint — Foreign key → answer.id — NOT NULL
  • content — varchar(5000) — NOT NULL

option_group

  • id — bigint — Primary key — NOT NULL
  • max_selection_count — int — NOT NULL
  • min_selection_count — int — NOT NULL
  • question_id — bigint — NOT NULL

option_item

  • id — bigint — Primary key — NOT NULL
  • position — int — NOT NULL
  • option_group_id — bigint — NOT NULL
  • content — varchar(255) — NOT NULL
  • option_type — enum('CATEGORY','KEYWORD') — NOT NULL

question

  • id — bigint — Primary key — NOT NULL
  • position — int — NOT NULL
  • required — bit(1) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • guideline — varchar(1000)
  • question_type — enum('CHECKBOX','TEXT') — NOT NULL

review_group

  • id — bigint — Primary key — NOT NULL
  • template_id — bigint — NOT NULL
  • group_access_code — varchar(255) — NOT NULL
  • project_name — varchar(255) — NOT NULL
  • review_request_code — varchar(255) — NOT NULL
  • reviewee — varchar(255) — NOT NULL

section

  • id — bigint — Primary key — NOT NULL
  • position — int — NOT NULL
  • on_selected_option_id — bigint
  • header — varchar(1000) — NOT NULL
  • section_name — varchar(255) — NOT NULL
  • visible_type — enum('ALWAYS','CONDITIONAL') — NOT NULL

section_question

  • id — bigint — Primary key — NOT NULL
  • question_id — bigint — NOT NULL
  • section_id — bigint — Foreign key → section.id — NOT NULL

template

  • id — bigint — Primary key — NOT NULL

template_section

  • id — bigint — Primary key — NOT NULL
  • section_id — bigint — NOT NULL
  • template_id — bigint — Foreign key → template.id — NOT NULL