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