AI Parser_V1
Tables (15)
ExtendExtractionRun (extend_async_extraction_run)
- extend_async_extraction_run_id — BIGINT — Primary key — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- job_instance_file_id — VARCHAR(36) — NOT NULL
- extend_run_id — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- extend_file_id — VARCHAR(255)
- extractor_version_id — VARCHAR(255)
- extend_server_created_at — datetime
- extend_server_updated_at — datetime
- output_json — LONGTEXT
- metadata_json — LONGTEXT
- usage_credits — DECIMAL
- failure_reason — VARCHAR(255)
- failure_message — LONGTEXT
JobExtractionRun (job_extraction_run)
- id (job_extraction_run_id) — VARCHAR(36) — Primary key — NOT NULL
- job_extraction_result_id (ExtractionResult) — ExtractionResult — Foreign key → job_extraction_result.id — NOT NULL
- job_id — BIGINT — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- file_id — BIGINT
- run_sequence — INT — NOT NULL
- document_category — VARCHAR(255)
- document_type — VARCHAR(255)
- extend_run_id — VARCHAR(255)
- job_status — VARCHAR(255)
- start_time_stamp — datetime
- end_time_stamp — datetime
- is_confirmed — VARCHAR(255)
- deadline — datetime
- extract_result_id — BIGINT
- failure_reason — VARCHAR(255)
billing_contract
- billing_contract_id — BIGINT — Primary key — NOT NULL
- usage_unit_type — VARCHAR(20) — NOT NULL
- policy_quota — BIGINT — NOT NULL
- expired_at — DATE
- input_id — VARCHAR(100)
- input_dt — DATETIME(6)
- modify_id — VARCHAR(100)
- modify_dt — DATETIME(6)
- version — BIGINT
billing_usage_record
- billing_usage_record_id — BIGINT — Primary key — NOT NULL
- source_id — VARCHAR(255) — NOT NULL
- file_id — VARCHAR(36) — NOT NULL
- document_type — VARCHAR(36) — NOT NULL
- po_count — INT — NOT NULL
- extend_credits — INT — NOT NULL
- recorded_date — VARCHAR(36) — NOT NULL
- dept_id — BIGINT
- user_id — VARCHAR(255)
- input_id — VARCHAR(100)
- input_dt — DATETIME(6)
- modify_id — VARCHAR(100)
- modify_dt — DATETIME(6)
- version — BIGINT
departments
- dept_id — BIGINT — Primary key — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- dept_code — VARCHAR(255) — NOT NULL
- parent_dept_code — VARCHAR(8)
- name_kor — VARCHAR(200) — NOT NULL
- active — VARCHAR(1) — NOT NULL
- dept_path — VARCHAR(255)
- is_root — VARCHAR(1)
- sort_order — INT
erp_code
- erp_code_id — BIGINT — Primary key — NOT NULL
- code_type — VARCHAR(255) — NOT NULL
- document_type — VARCHAR(255) — NOT NULL
- code — VARCHAR(255) — NOT NULL
- name — VARCHAR(200) — NOT NULL
- sort_order — INT — NOT NULL
- input_id — VARCHAR(255)
- input_dt — DATETIME(6)
- modify_id — VARCHAR(255)
- modify_dt — DATETIME(6)
- version — BIGINT
extraction_result_change_log
- change_log_id — BIGINT — Primary key — NOT NULL
- id (job_extraction_run_id) — VARCHAR(36) — Foreign key → JobExtractionRun.id — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- before_snapshot — LONGTEXT
- after_snapshot — LONGTEXT — NOT NULL
file_metadata
- file_id — BIGINT — Primary key — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- original_file_name — VARCHAR(255)
- stored_file_name — VARCHAR(255)
- file_path — VARCHAR(255)
- file_extension — VARCHAR(255)
- mime_type — VARCHAR(255)
- file_size — BIGINT
- upload_status — VARCHAR(255)
- start_time_stamp — datetime
- complete_time_stamp — datetime
- del_yn — VARCHAR(1) — NOT NULL
job
- id (job_id) — BIGINT — Primary key — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- job_name — VARCHAR(255)
- document_category — VARCHAR(255)
- document_type — VARCHAR(255)
- description — VARCHAR(255)
- owner_dept_id — BIGINT
- hidden_yn (숨김여부) — VARCHAR(1)
job_extraction_result
- id (job_extraction_result_id) — BIGINT — Primary key — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- json_result — LONGTEXT
- normalized_result — LONGTEXT
job_file
- job_file_id — BIGINT — Primary key — NOT NULL
- id (job_id2) — BIGINT — Foreign key → job.id — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- file_id — BIGINT
- hidden_yn (숨김여부) — VARCHAR(1)
monthly_billing
- monthly_billing_id — BIGINT — Primary key — NOT NULL
- billing_contract_id — BIGINT — NOT NULL
- period_start_date — VARCHAR(255) — NOT NULL
- period_end_date — VARCHAR(36) — NOT NULL
- usage_unit_type — VARCHAR(20) — NOT NULL
- policy_quota — BIGINT — NOT NULL
- po_count_sum — BIGINT — NOT NULL
- credit_used — INT — NOT NULL
- input_id — VARCHAR(100)
- input_dt — DATETIME(6)
- modify_id — VARCHAR(100)
- modify_dt — DATETIME(6)
- version — BIGINT
outbox
- outbox_id — BIGINT — Primary key — NOT NULL
- aggregate_type — VARCHAR(255) — NOT NULL
- aggregate_id — VARCHAR(255) — NOT NULL
- event_type — VARCHAR(255) — NOT NULL
- payload — TEXT — NOT NULL
- status — VARCHAR(255) — NOT NULL
- created_at — datetime — NOT NULL
- published_at — datetime
- retry_count — INT — NOT NULL
- next_retry_at — datetime
- last_error — VARCHAR(500)
- trace_id — VARCHAR(36)
- user_id — VARCHAR(36)
user_dept_authorities
- authority_id — BIGINT — Primary key — NOT NULL
- user_id (user_id2) — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- target_dept_id — BIGINT — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
users
- user_id — VARCHAR(36) — Primary key — NOT NULL
- input_id — VARCHAR(255)
- input_dt — datetime
- modify_id — VARCHAR(255)
- modify_dt — datetime
- version — BIGINT
- employ_code — VARCHAR(255)
- employ_no — VARCHAR(255)
- user_name — VARCHAR(255)
- user_email — VARCHAR(255)
- user_type — VARCHAR(255)
- active — VARCHAR(1)
- dept_id — BIGINT