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)