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)