손보협 과제

테이블 (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