test

Tables (10)

evaluation

  • evaluation_id — BIGINT — NOT NULL
  • test_id — BIGINT — NOT NULL
  • description — VARCHAR(1000)

member_evaluation_answer

  • member_id — BIGINT — Primary key — NOT NULL
  • evaluation_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Primary key — NOT NULL
  • objective_choice — INT
  • subjective_answer — TEXT

objective_problem

  • question_id — BIGINT — NOT NULL
  • content — VARCHAR(1000)
  • is_correct — BOOLEAN — NOT NULL

problem

  • question_id — BIGINT — NOT NULL
  • evaluation_id — BIGINT — NOT NULL
  • content — VARCHAR(1000)
  • type — ENUM('subjective','objective') — NOT NULL

quest

  • quest_id — BIGINT — NOT NULL
  • test_id — BIGINT — NOT NULL
  • quest_content — VARCHAR(1000)

quest_answer_attached_files

  • file_id — BIGINT — NOT NULL
  • file_url — VARCHAR(150) — NOT NULL

quest_attachment_file

  • file_id — BIGINT — NOT NULL
  • quest_id — BIGINT — NOT NULL
  • file_url — VARCHAR(150) — NOT NULL

quest_member_answer

  • member_id — BIGINT — Primary key — NOT NULL
  • quest_id — BIGINT — Primary key — NOT NULL
  • file_id — BIGINT — NOT NULL
  • quest_content — VARCHAR(1000)
  • is_submitted — BOOLEAN — NOT NULL

test

  • test_id — BIGINT — NOT NULL
  • track_id — BIGINT — NOT NULL
  • test_title — VARCHAR(100) — NOT NULL
  • evaluate_start_time — DATETIME — NOT NULL
  • evaluate_end_time — DATETIME — NOT NULL
  • test_category — ENUM('evaluation','quest') — NOT NULL
  • status — BOOLEAN — NOT NULL
  • cardinal_number — BIGINT — NOT NULL

test_result

  • test_result_id — BIGINT — NOT NULL
  • test_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • test_score — INT — NOT NULL
  • test_comment — VARCHAR(1000)