test
Tables (12)
account
- account_code — VARCHAR(50)
- account_category — VARCHAR(100)
department
- department_id — VARCHAR(50)
- department_name — VARCHAR(100)
document_template
- template_id — VARCHAR(100)
- template_ver_id — VARCHAR(50)
- template_code — VARCHAR(100)
- template_version_no — NUMBER
- template_status_cd — VARCHAR(50)
- document_kind — VARCHAR(50)
- document_category — VARCHAR(50)
employee
- employee_id — VARCHAR(50)
- employee_name — VARCHAR(100)
- department_id — VARCHAR(50) — Foreign key → department.department_id
- position_name — VARCHAR(50)
- email — VARCHAR(200)
- login_id — VARCHAR(100)
exp_resolution
- draft_id — VARCHAR(100)
- screen_id — VARCHAR(100)
- template_id — VARCHAR(100) — Foreign key → document_template.template_id
- document_subtype_id — VARCHAR(100)
- document_subtype_label — VARCHAR(100)
- document_title — VARCHAR(200)
- card_type — VARCHAR(50)
- status — VARCHAR(50)
- assignee_id — VARCHAR(50) — Foreign key → employee.employee_id
- reference_request_id — VARCHAR(100)
- reference_request_title — VARCHAR(200)
- reference_request_doc_number — VARCHAR(100)
- reference_request_date — DATE
- auto_created_from_request — CHAR(1)
- approval_line_doc_type_cd — VARCHAR(50)
- approval_line_doc_type_label — VARCHAR(100)
- approval_line_source — VARCHAR(50)
- industry_cd — VARCHAR(50)
- start_date — DATE
- end_date — DATE
- duration_days — NUMBER
- doc_number — VARCHAR(100)
- created_at — DATE
- title — VARCHAR(200)
- reference_recipients — VARCHAR(200)
- executor_name — VARCHAR(100)
- execution_date — DATE
- accounting_date — DATE
- payment_request_date — DATE
- purpose — VARCHAR(1000)
- summary — VARCHAR(1000)
- project_name — VARCHAR(200)
- payment_condition — VARCHAR(200)
- receiver_info — VARCHAR(200)
- reference_document — VARCHAR(500)
- note — VARCHAR(1000)
- bank_name — VARCHAR(100)
- account_number — VARCHAR(100)
- account_holder — VARCHAR(100)
- card_number_mask — VARCHAR(100)
- updated_at — DATE
- template_document_kind — VARCHAR(100)
- submitted_at — DATE
- requested_at — DATE
- internal_status — VARCHAR(50)
- groupware_status — VARCHAR(50)
- line_reset_yn — CHAR(1)
- line_reset_reason — VARCHAR(500)
- modified_yn — CHAR(1)
- draft_json — CLOB
exp_resolution_approval_step
- approval_step_id — NUMBER
- draft_id — VARCHAR(100) — Foreign key → exp_resolution.draft_id — NOT NULL
- employee_id — VARCHAR(50) — Foreign key → employee.employee_id
- stage_label — VARCHAR(50)
- step_type — VARCHAR(50)
- status — VARCHAR(50)
- decided_at — DATE
exp_resolution_attachment
- attachment_id — VARCHAR(100)
- draft_id — VARCHAR(100) — Foreign key → exp_resolution.draft_id — NOT NULL
- line_item_id — VARCHAR(100) — Foreign key → exp_resolution_line_item.line_item_id
- file_name — VARCHAR(300)
- file_size — NUMBER
- file_type — VARCHAR(100)
- attachment_path — VARCHAR(500)
- preview_url — VARCHAR(1000)
- download_url — VARCHAR(1000)
- uploaded_at — DATE
- uploader_id — VARCHAR(50) — Foreign key → employee.employee_id
exp_resolution_line_item
- line_item_id — VARCHAR(100)
- draft_id — VARCHAR(100) — Foreign key → exp_resolution.draft_id — NOT NULL
- item_name — VARCHAR(200)
- summary — VARCHAR(1000)
- project_name — VARCHAR(200)
- vendor_code — VARCHAR(50) — Foreign key → vendor.vendor_code
- account_code — VARCHAR(50) — Foreign key → account.account_code
- quantity — NUMBER
- unit_price — NUMBER
- supply_amount — NUMBER
- vat_amount — NUMBER
- total_amount — NUMBER
- evidence_type — VARCHAR(50)
- evidence_date — DATE
- card_reference — VARCHAR(100)
- attachment_label — VARCHAR(300)
- ocr_status — VARCHAR(50)
- ocr_retry_count — NUMBER
- ocr_last_requested_at — DATE
- ocr_trace_id — VARCHAR(100)
- ocr_last_error_message — VARCHAR(1000)
- ocr_validation_result — VARCHAR(50)
- ocr_infer_result — VARCHAR(50)
- ocr_error_code — VARCHAR(100)
- ocr_error_message — VARCHAR(1000)
- ocr_extracted_text — CLOB
- vat_manual_yn — CHAR(1)
- account_input_mode — VARCHAR(50)
- debit_account_code — VARCHAR(50)
- credit_account_code — VARCHAR(50)
- note — VARCHAR(1000)
- ocr_ref_id — VARCHAR(100)
- ocr_mapped_at — DATE
exp_resolution_ocr
- ocr_id — VARCHAR(100)
- draft_id — VARCHAR(100) — Foreign key → exp_resolution.draft_id — NOT NULL
- line_item_id — VARCHAR(100) — Foreign key → exp_resolution_line_item.line_item_id
- attachment_id — VARCHAR(100) — Foreign key → exp_resolution_attachment.attachment_id
- ocr_status — VARCHAR(50)
- ocr_requested_at — DATE
- ocr_trace_id — VARCHAR(100)
- ocr_validation_result — VARCHAR(50)
- ocr_infer_result — VARCHAR(50)
- store_name — VARCHAR(200)
- store_sub_name — VARCHAR(200)
- biz_num — VARCHAR(50)
- store_address — VARCHAR(500)
- store_tel — VARCHAR(50)
- payment_date — DATE
- payment_time — VARCHAR(20)
- card_company — VARCHAR(100)
- card_number_mask — VARCHAR(100)
- confirm_num — VARCHAR(100)
- total_price — NUMBER
- tax_price — NUMBER
- ocr_extracted_text — CLOB
- ocr_raw_response — CLOB
exp_resolution_ocr_history
- ocr_history_id — VARCHAR(100)
- draft_id — VARCHAR(100) — Foreign key → exp_resolution.draft_id — NOT NULL
- line_item_id — VARCHAR(100) — Foreign key → exp_resolution_line_item.line_item_id
- attachment_id — VARCHAR(100) — Foreign key → exp_resolution_attachment.attachment_id
- requested_at — DATE
- status — VARCHAR(50)
- trace_id — VARCHAR(100)
- message — VARCHAR(1000)
- attachment_path — VARCHAR(500)
- payload — CLOB
exp_resolution_ocr_item
- ocr_item_id — NUMBER
- ocr_id — VARCHAR(100) — Foreign key → exp_resolution_ocr.ocr_id — NOT NULL
- item_name — VARCHAR(200)
- item_count — NUMBER
- unit_price — NUMBER
- price — NUMBER
- confidence_score — NUMBER
vendor
- vendor_code — VARCHAR(50)
- vendor_name — VARCHAR(200)