1
Tables (35)
ChecklistReports
- doc_id — VARCHAR(255) — Foreign key → Documents.id — NOT NULL — 문서 ID
- overall — VARCHAR(50) — 종합 평가
- summary_pass — INT — 통과 항목 수
- summary_warn — INT — 경고 항목 수
- summary_fail — INT — 실패 항목 수
- summary_manual — INT — 수동 확인 항목 수
Documents
- id — VARCHAR(255) — Primary key — NOT NULL — 문서 고유 UUID
- filename — VARCHAR(255) — 파일명
- doc_type — VARCHAR(50) — 사건 유형
- stage — VARCHAR(50) — 진행 단계
- page_count — INT — 전체 페이지 수
- pages_json — TEXT — 페이지별 OCR 텍스트 JSON
- full_text — TEXT — 문서 전체 OCR 텍스트
- summary — TEXT — AI 발췌 요약문
- translation_json — TEXT — 번역 및 체크리스트 JSON
- created_at — TIMESTAMP — 생성일
- updated_at — TIMESTAMP — 수정일
ImageCatalog
- image_file — VARCHAR(255) — Primary key — NOT NULL — 이미지 파일명
- title — VARCHAR(255) — 시각자료 설명 제목
- url — VARCHAR(500) — 정적 서빙 경로
- source_url — VARCHAR(500) — 웹 검색 이미지 출처 URL
ImagePlacements
- id — VARCHAR(255) — Primary key — NOT NULL — 배치 UUID
- segment_id — VARCHAR(255) — Foreign key → TranslationSegments.id — 속한 번역 세그먼트
- image_file — VARCHAR(255) — Foreign key → ImageCatalog.image_file — 매칭된 시각자료 파일명
- line_index — INT — 본문 내 배치 인덱스
- title — VARCHAR(255) — 이미지 제목
- image_url — VARCHAR(500) — 이미지 URL
- section_heading — VARCHAR(255) — 속한 소제목
- auto_filled — BOOLEAN — 자동 배치 여부
LegalDBRules
- original_key — VARCHAR(255) — Primary key — NOT NULL — 원문 용어/문장 키
- easy_text — TEXT — 표준 이지리드 순화 표현
- title — VARCHAR(255) — 관련 시각자료 제목
- image_file — VARCHAR(255) — Foreign key → ImageCatalog.image_file — 연결된 기본 일러스트
MohwTerms
- id — INT — Primary key — NOT NULL — 식별자
- original_term — VARCHAR(255) — 보건복지부 어려운 단어
- recommended_term — VARCHAR(255) — 쉬운 권고 단어
TranslationSegments
- id — VARCHAR(255) — Primary key — NOT NULL — 세그먼트 UUID
- doc_id — VARCHAR(255) — Foreign key → Documents.id — 해당 문서 ID
- original — TEXT — 원문 문장
- easy_text — TEXT — 쉬운 글 번역문
- source — VARCHAR(50) — 생성 출처
- image_file — VARCHAR(255) — 대표 이미지 파일명
- image_url — VARCHAR(500) — 이미지 접근 URL
- title — VARCHAR(255) — 시각자료 제목
UserProjects
- doc_id — VARCHAR(255) — Foreign key → Documents.id — NOT NULL — 문서 UUID
- user_id — VARCHAR(255) — Foreign key → Users.user_id — 소유 사용자
- filename — VARCHAR(255) — 업로드 원본 파일명
- created_at — TIMESTAMP — 생성일
- updated_at — TIMESTAMP — 수정일
Users
- user_id — VARCHAR(255) — Primary key — NOT NULL — 사용자 로그인 이메일 / 식별자
- created_at — TIMESTAMP — 생성일
chat_message_sources
- source_tag — VARCHAR(32) — Primary key — NOT NULL — service_guide|db|document|web|solar|generated|db_rules
- message_id — VARCHAR(64) — Foreign key → chat_messages.message_id — NOT NULL — FK chat_messages.message_id
chat_messages
- message_id — VARCHAR(64) — Primary key — NOT NULL — Message UUID
- session_id — VARCHAR(64) — Foreign key → chat_sessions.session_id — NOT NULL — FK chat_sessions.session_id
- role — VARCHAR(16) — NOT NULL — user|assistant
- content — MEDIUMTEXT — NOT NULL — Message text
- created_at — VARCHAR(40) — ISO-8601
chat_sessions
- session_id — VARCHAR(64) — Primary key — NOT NULL — Client chat session id
- user_id — VARCHAR(255) — Foreign key → users.user_id — FK users.user_id
- doc_id — VARCHAR(36) — Foreign key → documents.id — FK documents.id when on document pages
- page_path — VARCHAR(255) — UI path e.g. /documents/{id}/translate
- created_at — VARCHAR(40) — ISO-8601
checklist_items
- id — VARCHAR(64) — Primary key — NOT NULL — Result row UUID
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- rule_id — VARCHAR(64) — NOT NULL — Rule id from checklist.yaml
- category — VARCHAR(64) — NOT NULL — formal|content|participatory|etc
- label — VARCHAR(512) — NOT NULL — Human-readable rule label
- status — VARCHAR(16) — NOT NULL — pass|warn|fail|manual
- detail — TEXT — Failure/warning detail message
checklist_reports
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- overall — VARCHAR(16) — NOT NULL — pass|warn|fail
- pass_count — INT — NOT NULL — Count of pass items
- warn_count — INT — NOT NULL — Count of warn items
- fail_count — INT — NOT NULL — Count of fail items
- manual_count — INT — NOT NULL — Count of manual-review items
- updated_at — VARCHAR(40) — ISO-8601
checklist_rules
- rule_id — VARCHAR(64) — Primary key — NOT NULL — Stable id from checklist.yaml
- category — VARCHAR(64) — NOT NULL — Rule category
- label — VARCHAR(512) — NOT NULL — Rule label
- severity — VARCHAR(16) — How it affects overall score
- enabled — TINYINT(1) — NOT NULL — 1 = active
cleared_image_slots
- user_browser_key — VARCHAR(64) — Primary key — NOT NULL — Client session key (sessionStorage today)
- line_index — INT — Primary key — NOT NULL — Item line_index user cleared with X
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- cleared_at — VARCHAR(40) — ISO-8601
document_full_text
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- full_text — MEDIUMTEXT — NOT NULL — Concatenated OCR text for whole document
document_json_backups
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- backup_path — VARCHAR(1024) — NOT NULL — Path data/docs/{doc_id}.json
- payload_json — MEDIUMTEXT — NOT NULL — DocumentResponse JSON for Vercel recovery
- updated_at — VARCHAR(40) — ISO-8601
document_pages
- page_num — INT — Primary key — NOT NULL — 1-based page index
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- page_text — MEDIUMTEXT — NOT NULL — OCR text for one page (from pages_jsoni)
document_source_files
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- storage_path — VARCHAR(1024) — NOT NULL — Path under data/uploads/{doc_id}_source.*
- original_filename — VARCHAR(512) — NOT NULL — Browser upload name
- mime_type — VARCHAR(128) — PDF/image/office mime if known
- byte_size — BIGINT — File size in bytes
- created_at — VARCHAR(40) — ISO-8601
document_summaries
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- summary_text — MEDIUMTEXT — NOT NULL — AI or manually edited summary
- generated_by — VARCHAR(32) — solar|manual|refine
- updated_at — VARCHAR(40) — ISO-8601
document_translations
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- translation_text — MEDIUMTEXT — Flat easy-read text (joined segments)
- updated_at — VARCHAR(40) — ISO-8601
documents
- id — VARCHAR(36) — Primary key — NOT NULL — Document UUID (primary business key)
- filename — VARCHAR(512) — NOT NULL — Original upload filename
- doc_type — VARCHAR(32) — NOT NULL — criminal|civil|family|administrative|unknown
- stage — VARCHAR(32) — NOT NULL — uploaded|summarized|translated
- page_count — INT — NOT NULL — Number of OCR pages
- created_at — VARCHAR(40) — NOT NULL — ISO-8601 create time
- updated_at — VARCHAR(40) — NOT NULL — ISO-8601 last update time
export_jobs
- job_id — VARCHAR(64) — Primary key — NOT NULL — Export request id
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- user_id — VARCHAR(255) — Foreign key → users.user_id — FK users.user_id if logged in
- format — VARCHAR(16) — NOT NULL — pdf|docx
- status — VARCHAR(32) — NOT NULL — pending|success|failed
- download_name — VARCHAR(512) — Attachment filename
- error_message — TEXT — Failure detail
- created_at — VARCHAR(40) — ISO-8601
- finished_at — VARCHAR(40) — ISO-8601
image_catalog
- image_file — VARCHAR(255) — Primary key — NOT NULL — PNG filename under /images
- title — VARCHAR(512) — NOT NULL — Searchable title
- source_url — VARCHAR(1024) — Optional external URL for web catalog items
image_placements
- id — VARCHAR(64) — Primary key — NOT NULL — Placement UUID
- segment_id — VARCHAR(64) — Foreign key → translation_segments.id — NOT NULL — FK translation_segments.id
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id (denormalized for queries)
- image_file — VARCHAR(255) — NOT NULL — Filename under /images or catalog key
- line_index — INT — NOT NULL — Line index in easy_text for numbered item slot
- title — VARCHAR(512) — Human title for the visual aid
- image_url — VARCHAR(1024) — Optional web/generated URL
- section_heading — VARCHAR(512) — Easy-read section heading context
- auto_filled — TINYINT(1) — NOT NULL — 1 = AI/auto fill; 0 = user drag
legal_db_entries
- entry_id — VARCHAR(64) — Primary key — NOT NULL — Surrogate key
- original_sentence — TEXT — NOT NULL — Judgment sentence key in LEGAL_DB
- easy_text — MEDIUMTEXT — NOT NULL — Canonical easy-read sentence
- title — VARCHAR(512) — Linked image title
- image_file — VARCHAR(255) — Foreign key → image_catalog.image_file — FK image_catalog.image_file
- match_priority — INT — Optional ranking hint
prompt_bundles
- bundle_id — VARCHAR(64) — Primary key — NOT NULL — summary_criminal|writing_civil|checklist|chatbot|usage_guide|...
- doc_type — VARCHAR(32) — Nullable when bundle is global
- file_path — VARCHAR(512) — NOT NULL — Path under backend/prompts or data/
- description — VARCHAR(512) — Short English description
runtime_settings
- setting_key — VARCHAR(64) — Primary key — NOT NULL — openai_api_key|chatbot_prompt|usage_guide_override|...
- setting_value — MEDIUMTEXT — YAML/JSON/text payload
- updated_at — VARCHAR(40) — ISO-8601
term_dictionaries
- dict_id — VARCHAR(32) — Primary key — NOT NULL — mohw|moleg|custom
- dict_name — VARCHAR(128) — NOT NULL — Human dictionary name
- enabled — TINYINT(1) — NOT NULL — 1=used in apply_terms_for_translation
- priority — INT — NOT NULL — Lower number = higher priority; mohw overrides moleg
- source_file — VARCHAR(255) — e.g. mohw_terms_dict.json
term_entries
- original_term — VARCHAR(512) — Primary key — NOT NULL — Source legal/hard term
- dict_id — VARCHAR(32) — Foreign key → term_dictionaries.dict_id — NOT NULL — FK term_dictionaries.dict_id
- recommended_term — VARCHAR(512) — NOT NULL — First recommended easy term
translation_segments
- id — VARCHAR(64) — Primary key — NOT NULL — Segment UUID
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- seq_no — INT — NOT NULL — Display order (0 = main full-doc segment today)
- original — TEXT — NOT NULL — Matched judgment sentence or seed snippet
- easy_text — MEDIUMTEXT — NOT NULL — Easy-read text; may include **bold** and <N>size</N>
- source — VARCHAR(16) — NOT NULL — db|solar|manual
- legacy_image_file — VARCHAR(255) — Old single-image field on segment
- legacy_image_url — VARCHAR(1024) — Old single-image URL on segment
- legacy_title — VARCHAR(512) — Old single-image title on segment
user_project_artifacts
- artifact_kind — VARCHAR(32) — Primary key — NOT NULL — source|summary|translation|translation_segments|easyread_txt|easyread_docx|easyread_pdf
- user_id — VARCHAR(255) — Foreign key → user_projects.user_id — NOT NULL — FK user_projects.user_id
- doc_id — VARCHAR(36) — Foreign key → user_projects.doc_id — NOT NULL — FK user_projects.doc_id
- file_name — VARCHAR(255) — NOT NULL — Filename inside project directory
- content_type — VARCHAR(64) — text/plain|application/pdf|docx mime
- byte_size — BIGINT — Optional size
- created_at — VARCHAR(40) — ISO-8601
user_projects
- user_id — VARCHAR(255) — Foreign key → users.user_id — NOT NULL — FK users.user_id
- doc_id — VARCHAR(36) — Foreign key → documents.id — NOT NULL — FK documents.id
- filename — VARCHAR(512) — Display filename in project list
- created_at — VARCHAR(40) — ISO-8601
- updated_at — VARCHAR(40) — ISO-8601
users
- user_id — VARCHAR(255) — Primary key — NOT NULL — Login id / email. Sent as HTTP header X-User-Id
- display_name — VARCHAR(255) — Optional display name from signup
- is_admin — TINYINT(1) — NOT NULL — 1 if email is in ADMIN_EMAILS
- created_at — VARCHAR(40) — ISO-8601 timestamp