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)