test
Tables (19)
applied_item_change_stats
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_detail_seq — bigint — Foreign key → conversion_request_detail.seq — NOT NULL
- item_serial — varchar(15) — NOT NULL
- company_nm — varchar(50) — 변환요청 한 포워더 회사명
- orginal_label — varchar(500)
- updated_label — varchar(500)
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
applied_revision
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_seq — bigint — Foreign key → conversion_request.seq — NOT NULL — (UK)(FK)
- applied_at — datetime — NOT NULL — (UK)
- applied_content — longblob — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
attachment_file
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_seq — bigint — Foreign key → conversion_request.seq — NOT NULL — (FK)
- file_category — varchar(30) — NOT NULL — 첨부파일, 분석파일, 텍스트추출파일
- file_name — varchar(300) — NOT NULL
- file_extension — varchar(30) — NOT NULL
- storage_path — varchar(300) — NOT NULL
- page_count — int — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
code_detail
- detail_cd_id — varchar(15) — Primary key — NOT NULL
- cd_id — varchar(15) — Foreign key → code_master.cd_id — NOT NULL
- detail_cd — varchar(30) — NOT NULL
- detail_cd_nm — varchar(300) — NOT NULL
- is_enabled — varchar(1) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
code_master
- cd_id — varchar(15) — Primary key — NOT NULL
- cd — varchar(30) — NOT NULL
- cd_nm — varchar(300) — NOT NULL
- cd_description — varchar(400)
- is_enabled — varchar(1) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
common_manual_input
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_seq — bigint — Foreign key → conversion_request.seq — NOT NULL — (UK)(FK)
- valid_to — datetime — NOT NULL — (UK)
- document_type — varchar(30) — NOT NULL — (UK)enum으로 관리(AWB, BL, CI, PL, N/A)
- valid_from — datetime — NOT NULL
- common_manual_content — longblob
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
conversion_item
- item_serial — varchar(15) — Primary key — NOT NULL
- document_type — varchar(30) — NOT NULL — (UK)enum으로 관리(AWB, BL, CI, PL, N/A)
- item_nm — varchar(50) — NOT NULL — (UK)
- item_desc — varchar(100) — NOT NULL
- is_enabled — varchar(1) — NOT NULL
- input_type — varchar(15) — NOT NULL — OCR, COM, IND
- sort_order — int — NOT NULL — 초기 GAP 10, rule_inex(비즈넷전달값)
- preferred_model — varchar(30) — NOT NULL — twinreader, LLM, layoutLM
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
conversion_request
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_id — varchar(30) — NOT NULL — (UK)
- apply_status — varchar(30) — NOT NULL — enum으로 관리(Y, N, ING)
- erp_user_nm — varchar(300) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
conversion_request_detail
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_seq — bigint — Foreign key → conversion_request.seq — NOT NULL — (UK))(FK)
- conversion_request_detail_id — varchar(30) — NOT NULL — (UK
- document_width — int — NOT NULL
- document_height — int — NOT NULL
- conversion_status — varchar(30) — NOT NULL — ING, Y, ERR
- conversion_error_msg — varchar(300)
- verification_status — varchar(30) — NOT NULL — NA,N, ING, Y
- is_confirmed — varchar(1) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
conversion_result
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_detail_seq — bigint — Foreign key → conversion_request_detail.seq — NOT NULL — (UK)(FK)
- valid_to — datetime — NOT NULL — (UK)
- valid_from — datetime — NOT NULL
- document_type — varchar(30) — NOT NULL — enum으로 관리(AWB, BL, CI, PL, N/A)
- conversion_result — longblob — 사용자가 수정한 내용 포함(룰 적용 및 비즈니스 로직 포함)
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
conversion_synonym
- synonym_serial — varchar(15) — Primary key — NOT NULL
- item_serial — varchar(15) — Foreign key → conversion_item.item_serial — NOT NULL
- synonym_item_nm — varchar(100) — NOT NULL
- is_enabled — varchar(1) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
model_invoke_log
- seq — BIGINT — Primary key — NOT NULL
- conversion_request_detail_seq — bigint — Foreign key → conversion_request_detail.seq — NOT NULL — (UK)(FK)
- service_category — varchar(20) — NOT NULL — (UK)enum으로 관리 (DocumentAi, 문서유형, 유사문서분류, twinreader, ..)
- request_params — longblob
- responded_at — datetime
- response_msg — longblob — 애자일소다, 모델, LLM 응답메시지 원본
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
port
- port_cd_serial — varchar(30) — Primary key — NOT NULL
- country_cd — varchar(2) — NOT NULL
- country_nm — varchar(100) — NOT NULL
- region_cd — varchar(3) — NOT NULL
- region_nm — varchar(100) — NOT NULL
- subdivision_cd — varchar(3)
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
program_menu
- seq — BIGINT — Primary key — NOT NULL
- menu_id — varchar(15) — NOT NULL — (UK)
- valid_to — datetime — NOT NULL — (UK)
- valid_from — datetime — NOT NULL
- menu_nm — varchar(300) — NOT NULL
- menu_eng_nm — varchar(300) — NOT NULL
- upper_menu_id — varchar(15)
- menu_lvl — int — NOT NULL
- servlet_path — varchar(400)
- is_visible — varchar(1)
- menu_order — int
- full_path — varchar(400) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
role_menu_map
- menu_seq — bigint — Primary key — NOT NULL
- user_role_seq — bigint — Foreign key → user_role.seq — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
total_log
- seq — BIGINT — Primary key — NOT NULL
- log_type — varchar(30) — NOT NULL — WEB, FILE, HUB
- log_msg — longtext
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
user
- seq — BIGINT — Primary key — NOT NULL
- user_id — varchar(15) — NOT NULL — (UK)
- valid_to — datetime — NOT NULL — (UK)
- valid_from — datetime — NOT NULL
- user_role_seq — bigint — Foreign key → user_role.seq — NOT NULL
- password — varchar(100) — NOT NULL
- user_nm — varchar(300) — NOT NULL
- company_nm — varchar(50)
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
user_role
- seq — bigint — Primary key — NOT NULL
- user_role_id — varchar(15) — NOT NULL — (UK)
- valid_to — datetime — NOT NULL — (UK)
- valid_from — datetime — NOT NULL
- role — varchar(10) — NOT NULL — enum으로 관리
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)
web_request_log
- seq — BIGINT — Primary key — NOT NULL
- url — varchar(100) — NOT NULL
- rqester_ip — varchar(23) — NOT NULL
- created_at — datetime — NOT NULL
- creater_id — VARCHAR(15)
- updated_at — datetime
- updater_id — VARCHAR(15)