ㅇㅇㅇ

Tables (7)

Grade

  • grade_id — INT
  • grade_template_id — INT
  • grade_name — VARCHAR(50)
  • grade_description — VARCHAR(255)
  • grade_range — INT
  • converted_score — INT

Grade_Template

  • grade_template_id — INT
  • review_id — INT
  • use_grade_score — BOOLEAN

Question

  • question_id — INT
  • section_id — INT
  • question_text — TEXT
  • description — TEXT
  • question_type — ENUM('Score Selection', 'Single Line Answer', 'Single Line and Score Selection')
  • display_order — INT
  • question_weighted — BOOLEAN

Review

  • review_id — INT
  • author_assignment_method — VARCHAR(50)
  • reference_material_provided — VARCHAR(255)
  • final_grade_setting — VARCHAR(255)

Review_Section

  • section_id — INT
  • stage_id — INT
  • section_name — VARCHAR(255)
  • section_description — TEXT
  • section_weighted — BOOLEAN
  • display_order — INT

Review_Stage

  • stage_id — INT
  • template_id — INT
  • stage_name — VARCHAR(255)
  • display_order — INT

Review_Template

  • template_id — INT
  • review_id — INT
  • template_name — VARCHAR(255)