sub-ocr-2026
Tables (4)
documents (업로드 파일 정보)
- document_id (Key2) — varchar(100) — Primary key — NOT NULL
- session_id (Field3) — varchar(100)
- original_name (Field4) — varchar(255)
- file_path (Field5) — varchar(500)
- file_type (Field6) — varchar(20)
- status (Field7) — varchar(20)
- created_at (Field8) — timestamp
- user_id (Key) — varchar(100) — Foreign key → users.user_id — NOT NULL
extracted_texts (OCR 및 원본 텍스트 추출 결과)
- extracted_id (Key) — varchar(50) — Primary key — NOT NULL
- raw_text (Field3) — longtext
- extracted_at (Field4) — timestamp
- document_id (Key22) — varchar(100) — Foreign key → documents.document_id — NOT NULL
llm_analysis_results (LLM 요약 및 카테고리 분석 결과)
- analysis_id (Key) — varchar(50) — Primary key — NOT NULL
- summary (Field3) — text
- category (Field4) — varchar(100)
- analyzed_at (Field5) — timestamp
- document_id (Key2) — varchar(100) — Foreign key → documents.document_id — NOT NULL
users (사용자 테이블)
- user_id (Key) — varchar(100) — Primary key — NOT NULL
- email (Field2) — varchar(255)
- password_hash (Field3) — varchar(255)
- created_at (Field4) — timestamp