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