손보협 과제
테이블 (12)
CHUNK
- chunk_id — CHAR(36) — 기본 키 — NOT NULL
- source_version_id — CHAR(36) — 외래 키 → SOURCE_VERSION.source_version_id — NOT NULL
- sequence_number — INTEGER — NOT NULL
- heading — VARCHAR(300)
- article_number — VARCHAR(100)
- page_number — INTEGER
- locator — VARCHAR(500) — NOT NULL
- content — TEXT — NOT NULL
- content_sha256 — CHAR(64) — NOT NULL
- extraction_version — VARCHAR(80) — NOT NULL
- chunking_version — VARCHAR(80) — NOT NULL
- index_status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
CITATION
- citation_id — CHAR(36) — 기본 키 — NOT NULL
- question_id — CHAR(36) — 외래 키 → QUESTION.question_id — NOT NULL
- chunk_id — CHAR(36) — 외래 키 → CHUNK.chunk_id — NOT NULL
- source_version_id — CHAR(36) — 외래 키 → SOURCE_VERSION.source_version_id — NOT NULL
- question_revision — INTEGER — NOT NULL
- option_index — SMALLINT — NOT NULL
- locator_snapshot — VARCHAR(500) — NOT NULL
- quote — TEXT — NOT NULL
- quote_sha256 — CHAR(64) — NOT NULL
- check_status — VARCHAR(30) — NOT NULL
- checked_at — DATETIME
- created_at — DATETIME — NOT NULL
EXAM
- exam_id — CHAR(36) — 기본 키 — NOT NULL
- exam_name — VARCHAR(200) — NOT NULL
- organizer — VARCHAR(200)
- exam_year — INTEGER
- round_label — VARCHAR(100)
- exam_date — DATE
- material_type — VARCHAR(30) — NOT NULL
- provenance_status — VARCHAR(30) — NOT NULL
- rights_status — VARCHAR(30) — NOT NULL
- source_url — TEXT
- original_file_uri — TEXT
- original_sha256 — CHAR(64)
- verified_by — VARCHAR(100)
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
GENERATION_RUN
- generation_run_id — CHAR(36) — 기본 키 — NOT NULL
- request_id — VARCHAR(150) — NOT NULL
- requested_by — VARCHAR(100) — NOT NULL
- exam_name — VARCHAR(200) — NOT NULL
- requested_question_count — SMALLINT — NOT NULL
- topic_plan_json — LONGTEXT — NOT NULL
- source_versions_json — LONGTEXT — NOT NULL
- allocation_policy_version — VARCHAR(80) — NOT NULL
- retrieval_policy_version — VARCHAR(80) — NOT NULL
- model_id — VARCHAR(150) — NOT NULL
- prompt_version — VARCHAR(80) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- failure_reason — TEXT
- started_at — DATETIME — NOT NULL
- finished_at — DATETIME
INDEX_JOB
- index_job_id — CHAR(36) — 기본 키 — NOT NULL
- source_version_id — CHAR(36) — 외래 키 → SOURCE_VERSION.source_version_id — NOT NULL
- idempotency_key — VARCHAR(150) — NOT NULL
- job_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- attempt_count — INTEGER — NOT NULL
- processed_chunk_count — INTEGER — NOT NULL
- error_message — TEXT
- requested_at — DATETIME — NOT NULL
- started_at — DATETIME
- finished_at — DATETIME
PAST_QUESTION
- past_question_id — CHAR(36) — 기본 키 — NOT NULL
- exam_id — CHAR(36) — 외래 키 → EXAM.exam_id — NOT NULL
- topic_id — CHAR(36) — 외래 키 → TOPIC.topic_id
- printed_number — VARCHAR(50) — NOT NULL
- page_number — INTEGER
- original_locator — VARCHAR(500) — NOT NULL
- stem — TEXT
- options_json — LONGTEXT
- answer_index — SMALLINT
- official_explanation — TEXT
- answer_source — TEXT
- content_sha256 — CHAR(64)
- verification_status — VARCHAR(30) — NOT NULL
- verified_by — VARCHAR(100)
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
QUESTION
- question_id — CHAR(36) — 기본 키 — NOT NULL
- generation_run_id — CHAR(36) — 외래 키 → GENERATION_RUN.generation_run_id — NOT NULL
- topic_id — CHAR(36) — 외래 키 → TOPIC.topic_id — NOT NULL
- slot_number — SMALLINT — NOT NULL
- revision — INTEGER — NOT NULL
- stem — TEXT — NOT NULL
- options_json — LONGTEXT — NOT NULL
- answer_index — SMALLINT — NOT NULL
- explanation — TEXT — NOT NULL
- question_type — VARCHAR(30)
- content_sha256 — CHAR(64) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- approved_by — VARCHAR(100)
- approved_at — DATETIME
- candidate_expires_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
REVIEW_DECISION
- review_decision_id — CHAR(36) — 기본 키 — NOT NULL
- question_id — CHAR(36) — 외래 키 → QUESTION.question_id — NOT NULL
- question_revision — INTEGER — NOT NULL
- decision — VARCHAR(20) — NOT NULL
- decided_by — VARCHAR(100) — NOT NULL
- decision_reason — TEXT
- validation_status_snapshot — VARCHAR(30) — NOT NULL
- question_sha256_snapshot — CHAR(64) — NOT NULL
- decided_at — DATETIME — NOT NULL
SOURCE
- source_id — CHAR(36) — 기본 키 — NOT NULL
- source_type — VARCHAR(30) — NOT NULL
- title — VARCHAR(300) — NOT NULL
- issuing_organization — VARCHAR(200)
- owner_scope — VARCHAR(200) — NOT NULL
- rights_status — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
SOURCE_VERSION
- source_version_id — CHAR(36) — 기본 키 — NOT NULL
- source_id — CHAR(36) — 외래 키 → SOURCE.source_id — NOT NULL
- version_label — VARCHAR(100) — NOT NULL
- published_on — DATE
- effective_from — DATE
- effective_to — DATE
- source_url — TEXT
- original_file_uri — TEXT — NOT NULL
- original_sha256 — CHAR(64) — NOT NULL
- file_format — VARCHAR(30) — NOT NULL
- rights_status — VARCHAR(30) — NOT NULL
- processing_status — VARCHAR(30) — NOT NULL
- use_status — VARCHAR(30) — NOT NULL
- registered_by — VARCHAR(100) — NOT NULL
- registered_at — DATETIME — NOT NULL
- activated_at — DATETIME
TOPIC
- topic_id — CHAR(36) — 기본 키 — NOT NULL
- topic_code — VARCHAR(10) — NOT NULL
- topic_name — VARCHAR(200) — NOT NULL
- display_order — SMALLINT — NOT NULL
- reference_question_count — INTEGER — NOT NULL
- reference_data_type — VARCHAR(30) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
VALIDATION_ATTEMPT
- validation_attempt_id — CHAR(36) — 기본 키 — NOT NULL
- question_id — CHAR(36) — 외래 키 → QUESTION.question_id — NOT NULL
- question_revision — INTEGER — NOT NULL
- attempt_type — VARCHAR(30) — NOT NULL
- provider — VARCHAR(80) — NOT NULL
- model_id — VARCHAR(150) — NOT NULL
- prompt_version — VARCHAR(80) — NOT NULL
- input_sha256 — CHAR(64) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- option_results_json — LONGTEXT
- findings_json — LONGTEXT
- failure_reason — TEXT
- started_at — DATETIME — NOT NULL
- finished_at — DATETIME