Document Studio v1.1.1

Tables (22)

app_settings

  • setting_key — varchar(100) — Primary key — NOT NULL
  • setting_value — varchar(1000) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

document_classification

  • id — varchar(255) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_by — varchar(255) — Foreign key → users.id — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

document_classification_document

  • id — varchar(255) — Primary key — NOT NULL
  • owner_id — varchar(255) — Foreign key → users.id — NOT NULL
  • file_name — varchar(255) — NOT NULL
  • stored_file_name — varchar(255)
  • doc_data — varchar(500) — NOT NULL
  • file_data — longblob
  • content_type — varchar(100)
  • doc_format — varchar(100)
  • file_size — bigint(20)
  • status — varchar(20) — NOT NULL
  • error_code — varchar(50)
  • error_message — text
  • processing_time — double
  • completed_at — datetime
  • signature_check_status — varchar(20)
  • has_missing_signature — tinyint(1)
  • signature_check_json — longtext
  • created_at — datetime
  • updated_at — datetime

document_classification_label

  • id — varchar(255) — Primary key — NOT NULL
  • schema_id — varchar(255) — Foreign key → document_classification.id — NOT NULL
  • label — varchar(255) — NOT NULL
  • description — text
  • sort_order — int(11) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

document_classification_result

  • id — varchar(255) — Primary key — NOT NULL
  • document_id — varchar(255) — NOT NULL
  • document_source — varchar(100) — NOT NULL
  • owner_id — varchar(255) — Foreign key → users.id — NOT NULL
  • schema_id — varchar(255) — Foreign key → document_classification.id
  • label — varchar(255) — NOT NULL
  • confidence — double
  • reason — text
  • note — text
  • result_json — longtext
  • prompt_version — varchar(50)
  • created_at — datetime
  • updated_at — datetime

documents

  • id — varchar(255) — Primary key — NOT NULL
  • status — varchar(50)
  • doc_order — int(11) — NOT NULL
  • doc_id — varchar(255) — NOT NULL
  • doc_format — varchar(100)
  • owner_id — varchar(255) — Foreign key → users.id
  • page_count — int(11)
  • file_name — varchar(255)
  • file_size — bigint(20)
  • job_id — varchar(255)
  • external_job_id — varchar(255)
  • job_status — varchar(50)
  • doc_data — varchar(255)
  • result_md — longtext
  • result_html — longtext
  • result_json — longtext
  • review_published_json — longtext
  • review_published_md — longtext
  • review_published_html — longtext
  • review_revision — bigint(20)
  • review_published_at — datetime
  • review_published_by — varchar(255)
  • processing_time — float
  • score — int(11)
  • risk_score — int(11)
  • error_code — varchar(100)
  • error_message — text
  • created_at — datetime
  • completed_at — datetime

error_logs

  • id — varchar(64) — Primary key — NOT NULL
  • occurred_at — datetime — NOT NULL
  • service_type — varchar(30) — NOT NULL
  • error_type — varchar(50) — NOT NULL
  • error_code — varchar(100)
  • error_message — text
  • http_status — int(11)
  • request_duration_ms — bigint(20)
  • retry_result — varchar(30)
  • retry_count — int(11)
  • recovered_at — datetime
  • request_method — varchar(10)
  • request_path — varchar(500)
  • processing_stage — varchar(100)
  • user_id — varchar(255)
  • trace_id — varchar(100)
  • request_summary — longtext
  • response_summary — longtext
  • created_at — datetime — NOT NULL

feedback_attachments

  • id — varchar(255) — Primary key — NOT NULL — 첨부파일 ID (UUID)
  • feedback_id — varchar(255) — Foreign key → feedbacks.id — NOT NULL — 피드백 ID
  • original_file_name — varchar(255) — NOT NULL — 원본 파일명
  • content_type — varchar(255) — MIME 타입
  • file_size — bigint(20) — 파일 크기(Byte)
  • file_data — longblob — NOT NULL — 첨부파일 바이너리
  • created_at — datetime

feedback_parser_reasons

  • id — varchar(255) — Primary key — NOT NULL — 사유 ID (UUID)
  • feedback_id — varchar(255) — Foreign key → feedbacks.id — NOT NULL — 피드백 ID
  • reason_code — varchar(100) — NOT NULL — TEXT_ACCURACY, TABLE_EXTRACTION 등
  • created_at — datetime

feedbacks

  • id — varchar(255) — Primary key — NOT NULL — 피드백 ID (UUID)
  • owner_id — varchar(255) — Foreign key → users.id — NOT NULL — 작성자 사용자 ID
  • channel — varchar(50) — NOT NULL — GLOBAL, DOC_PARSER
  • category — varchar(50) — FEATURE_REQUEST, BUG, OTHER
  • sentiment — varchar(50) — SATISFIED, DISSATISFIED
  • source_page — varchar(100) — NOT NULL — 피드백이 발생한 화면
  • entry_point — varchar(100) — 피드백 버튼/팝업 노출 위치
  • title — varchar(255) — 전역 피드백 제목
  • content — text — 상세 내용 또는 추가 의견
  • reference_document_id — varchar(255) — 내부 문서 ID
  • reference_doc_id — varchar(255) — parser 결과 UUID
  • reference_job_id — varchar(255) — 파싱 작업 ID
  • review_status — varchar(50) — NOT NULL — 운영 처리 상태
  • created_at — datetime
  • updated_at — datetime

flyway_schema_history

  • installed_rank — int(11) — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int(11)
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int(11) — NOT NULL
  • success — tinyint(1) — NOT NULL

kie_extractor_schema

  • id — varchar(255) — Primary key — NOT NULL
  • owner_id — varchar(255) — Foreign key → users.id — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — text
  • source_type — varchar(50) — NOT NULL
  • source_document_id — varchar(255)
  • source_file_name — varchar(255)
  • schema_json — longtext — NOT NULL
  • prompt_version — varchar(50)
  • deleted_at — datetime
  • created_at — datetime
  • updated_at — datetime

license_server_online_account_features

  • id — varchar(255) — Primary key — NOT NULL
  • user_id — varchar(255) — Foreign key → users.id — NOT NULL
  • feature_code — varchar(100) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

license_server_online_accounts

  • user_id — varchar(255) — Foreign key → users.id — NOT NULL
  • external_account_id — varchar(255) — NOT NULL
  • grant_id — bigint(20)
  • product_code — varchar(100) — NOT NULL
  • status — varchar(50) — NOT NULL
  • expires_at — datetime
  • created_at — datetime
  • updated_at — datetime

ocr_documents

  • id — varchar(255) — Primary key — NOT NULL
  • status — varchar(50)
  • doc_order — int(11) — NOT NULL
  • doc_id — varchar(255) — NOT NULL
  • doc_format — varchar(100)
  • owner_id — varchar(255) — Foreign key → users.id
  • page_count — int(11)
  • file_name — varchar(255)
  • file_size — bigint(20)
  • job_id — varchar(255)
  • job_status — varchar(50)
  • doc_data — varchar(255)
  • result_md — longtext
  • result_json — longtext
  • review_published_json — longtext
  • review_published_md — longtext
  • review_revision — bigint(20)
  • review_published_at — datetime
  • review_published_by — varchar(255)
  • processing_time — float
  • score — int(11)
  • risk_score — int(11)
  • error_code — varchar(100)
  • error_message — text
  • created_at — datetime
  • completed_at — datetime

playground_documents

  • id — varchar(255) — Primary key — NOT NULL
  • status — varchar(50)
  • doc_order — int(11) — NOT NULL
  • doc_id — varchar(255) — NOT NULL
  • doc_format — varchar(100)
  • page_count — int(11)
  • file_name — varchar(255)
  • file_size — bigint(20)
  • external_job_id — varchar(255)
  • owner_id — varchar(255) — Foreign key → users.id
  • doc_data — varchar(255)
  • result_md — longtext
  • result_html — longtext
  • result_json — longtext
  • review_published_json — longtext
  • review_published_md — longtext
  • review_published_html — longtext
  • review_revision — bigint(20)
  • review_published_at — datetime
  • review_published_by — varchar(255)
  • processing_time — float
  • error_code — varchar(100)
  • error_message — text
  • created_at — datetime
  • completed_at — datetime

playground_kie_document_pages

  • id — bigint(20) — Primary key — NOT NULL
  • document_id — varchar(255) — Foreign key → playground_kie_documents.id — NOT NULL
  • page_number — int(11) — NOT NULL
  • status — varchar(30) — NOT NULL
  • schema_json — longtext
  • extracted_json — longtext
  • final_json — longtext
  • error_code — varchar(100)
  • error_message — text
  • processing_time — float
  • created_at — datetime
  • updated_at — datetime
  • completed_at — datetime

playground_kie_documents

  • id — varchar(255) — Primary key — NOT NULL
  • status — varchar(50)
  • doc_order — int(11) — NOT NULL
  • doc_id — varchar(255) — NOT NULL
  • doc_format — varchar(100)
  • page_count — int(11)
  • multi_page_strategy — varchar(50)
  • file_name — varchar(255)
  • file_size — bigint(20)
  • owner_id — varchar(255) — Foreign key → users.id
  • doc_data — varchar(255)
  • file_data — longblob
  • prompt_version — varchar(50)
  • vlm_model — varchar(100)
  • input_file_type — varchar(20)
  • extraction_mode — varchar(20)
  • schema_json — longtext
  • extracted_json — longtext
  • final_json — longtext
  • signature_check_status — varchar(20)
  • has_missing_signature — tinyint(1)
  • signature_check_json — longtext
  • review_revision — bigint(20)
  • reviewed_at — datetime
  • reviewed_by — varchar(255)
  • processing_time — float
  • error_code — varchar(100)
  • error_message — text
  • created_at — datetime
  • completed_at — datetime

playground_ocr_documents

  • id — varchar(255) — Primary key — NOT NULL
  • status — varchar(50)
  • doc_order — int(11) — NOT NULL
  • doc_id — varchar(255) — NOT NULL
  • doc_format — varchar(100)
  • page_count — int(11)
  • file_name — varchar(255)
  • file_size — bigint(20)
  • owner_id — varchar(255) — Foreign key → users.id
  • doc_data — varchar(255)
  • result_md — longtext
  • result_json — longtext
  • review_published_json — longtext
  • review_published_md — longtext
  • review_revision — bigint(20)
  • review_published_at — datetime
  • review_published_by — varchar(255)
  • processing_time — float
  • error_code — varchar(100)
  • error_message — text
  • created_at — datetime
  • completed_at — datetime

terms

  • id — varchar(255) — Primary key — NOT NULL — UUID
  • type — enum('TERMS_OF_SERVICE', 'PRIVACY_POLICY') — NOT NULL — 약관 종류
  • title — varchar(255) — NOT NULL — 약관 제목
  • content — longtext — NOT NULL — 약관 내용
  • version — varchar(50) — NOT NULL — 약관 버전
  • effective_date — date — NOT NULL — 시행일
  • created_at — datetime
  • updated_at — datetime
  • created_by — varchar(255) — Foreign key → users.id
  • updated_by — varchar(255) — Foreign key → users.id

user_api_keys

  • id — varchar(255) — Primary key — NOT NULL — API 키 식별자 (UUID)
  • api_title — varchar(255) — NOT NULL — API 이름
  • api_description — varchar(255) — NOT NULL — API 설명
  • owner_id — varchar(255) — Foreign key → users.id — NOT NULL — 사용자 ID (FK)
  • api_key — varchar(255) — NOT NULL — 실제 API 키 값
  • label — varchar(100) — 키 별칭 (예: 개발용, 서비스용)
  • status — enum('ACTIVE', 'INACTIVE', 'EXPIRED') — 키 상태
  • last_used_at — datetime — 마지막 사용 일시
  • expires_at — datetime — 키 만료 일시
  • created_at — datetime
  • updated_at — datetime

users

  • id — varchar(255) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(100)
  • phone — varchar(20)
  • icon_url — varchar(255)
  • role — enum('ADMIN','MANAGER','USER')
  • status — enum('ACTIVE','INACTIVE','SUSPENDED','PENDING','REJECTED','EXPIRED','REVOKED')
  • login_fail_count — int(11)
  • password_changed_at — datetime
  • expires_at — datetime
  • notes — text
  • last_login_at — datetime
  • language — varchar(10)
  • theme — varchar(20)
  • created_at — datetime
  • updated_at — datetime
  • created_by — varchar(255)
  • updated_by — varchar(255)