스마트제조혁신
테이블 (32)
t_agent_info
- agent_id — VARCHAR(50) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- agent_name — VARCHAR(100) — NOT NULL
- agent_desc — VARCHAR(500)
- agent_type — VARCHAR(20) — NOT NULL
- system_prompt — TEXT
- model_name — VARCHAR(50)
- temperature — DECIMAL(3,2)
- max_tokens — INT
- config — JSON
- version — INT — NOT NULL
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_agent_param
- param_id — VARCHAR(50) — NOT NULL
- agent_id — VARCHAR(50) — 외래 키 → t_agent_info.agent_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- param_name — VARCHAR(100) — NOT NULL
- param_type — VARCHAR(20) — NOT NULL
- param_desc — VARCHAR(500)
- default_value — TEXT
- required_yn — VARCHAR(1) — NOT NULL
- param_order — INT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_agent_tool
- tool_id — VARCHAR(50) — NOT NULL
- agent_id — VARCHAR(50) — 외래 키 → t_agent_info.agent_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- tool_name — VARCHAR(100) — NOT NULL
- tool_type — VARCHAR(20) — NOT NULL
- tool_desc — VARCHAR(500)
- tool_config — JSON
- input_schema — JSON
- output_schema — JSON
- use_yn — VARCHAR(1) — NOT NULL
- tool_order — INT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_apply_comp
- comp_apply_code — VARCHAR(20) — NOT NULL
- comp_name — VARCHAR(100) — NOT NULL
- ceo_name — VARCHAR(50)
- gln_code — VARCHAR(20)
- address — VARCHAR(200)
- zip_code — VARCHAR(10)
- tel — VARCHAR(20)
- fax — VARCHAR(20)
- email — VARCHAR(100)
- b_type_parent — VARCHAR(20)
- b_type — VARCHAR(20)
- web_url — VARCHAR(200)
- b_number — VARCHAR(20)
- img_file — VARCHAR(200)
- service_gubn_parent — VARCHAR(20)
- service_gubn — VARCHAR(20)
- apply_state_parent — VARCHAR(20)
- apply_state — VARCHAR(20) — NOT NULL
- apply_date — TIMESTAMP
- apply_reason — TEXT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_apply_user_info
- user_apply_code — VARCHAR(20) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- dept_name — VARCHAR(50)
- job_name — VARCHAR(50)
- user_pw — VARCHAR(200) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- user_email — VARCHAR(100)
- d_phone — VARCHAR(20)
- m_phone — VARCHAR(20)
- user_gubn_parent — VARCHAR(20)
- user_gubn — VARCHAR(20)
- apply_state_parent — VARCHAR(20)
- apply_state — VARCHAR(20) — NOT NULL
- apply_date — TIMESTAMP
- apply_reason — TEXT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_chat_message
- message_id — VARCHAR(50) — NOT NULL
- session_id — VARCHAR(50) — 외래 키 → t_chat_session.session_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- token_usage — INT
- model_name — VARCHAR(50)
- response_time_ms — INT
- message_order — INT — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_chat_session
- session_id — VARCHAR(50) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → t_sys_user_info.user_id — NOT NULL
- session_title — VARCHAR(200)
- agent_id — VARCHAR(50) — 외래 키 → t_agent_info.agent_id
- message_count — INT — NOT NULL
- last_message_dt — TIMESTAMP
- delete_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_chat_source
- source_id — BIGINT — NOT NULL
- message_id — VARCHAR(50) — 외래 키 → t_chat_message.message_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- doc_id — VARCHAR(50) — 외래 키 → t_doc_info.doc_id
- chunk_id — VARCHAR(50)
- source_type — VARCHAR(20) — NOT NULL
- content_preview — VARCHAR(500)
- relevance_score — DECIMAL(5,4)
- reg_dt — TIMESTAMP — NOT NULL
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_doc_chunk
- chunk_id — VARCHAR(50) — NOT NULL
- doc_id — VARCHAR(50) — 외래 키 → t_doc_info.doc_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- chunk_index — INT — NOT NULL
- chunk_type — VARCHAR(20) — NOT NULL
- content_preview — VARCHAR(500)
- page_number — INT
- section_title — VARCHAR(200)
- keyword — VARCHAR(500)
- proposition_count — INT
- os_index_id — VARCHAR(100)
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_doc_info
- doc_id — VARCHAR(50) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- file_name — VARCHAR(200) — NOT NULL
- file_type — VARCHAR(20) — NOT NULL
- file_size — BIGINT
- minio_path — VARCHAR(500) — NOT NULL
- page_count — INT
- chunk_count — INT
- parse_status — VARCHAR(20) — NOT NULL
- doc_type — VARCHAR(20)
- sha256 — VARCHAR(64)
- metadata — JSON
- delete_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_doc_parse_log
- log_id — BIGINT — NOT NULL
- doc_id — VARCHAR(50) — 외래 키 → t_doc_info.doc_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- step — VARCHAR(20) — NOT NULL
- step_status — VARCHAR(20) — NOT NULL
- start_dt — TIMESTAMP — NOT NULL
- end_dt — TIMESTAMP
- detail — TEXT
- error_msg — TEXT
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_doc_schema
- schema_id — VARCHAR(50) — NOT NULL
- doc_id — VARCHAR(50) — 외래 키 → t_doc_info.doc_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- schema_name — VARCHAR(100)
- json_schema — JSON — NOT NULL
- data — JSON
- row_count — INT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_sys_btn_info
- btn_id — VARCHAR(20) — NOT NULL
- btn_disp_type_parent — VARCHAR(20)
- btn_disp_type — VARCHAR(20)
- btn_caption — VARCHAR(50)
- btn_class — VARCHAR(50)
- btn_icon — VARCHAR(50)
- icon_loc_parent — VARCHAR(20)
- icon_loc — VARCHAR(20)
- lang_code — VARCHAR(10)
- use_yn_parent — VARCHAR(1)
- use_yn — VARCHAR(1) — NOT NULL
- btn_order — INT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_comcode
- code_id — VARCHAR(20) — NOT NULL
- parent_code_id — VARCHAR(20)
- code_name1 — VARCHAR(100)
- code_name2 — VARCHAR(100)
- code_name3 — VARCHAR(100)
- code_name4 — VARCHAR(100)
- code_name5 — VARCHAR(100)
- code_comment — VARCHAR(200) — ARCHAR(200
- code_order — INT
- lang_code — VARCHAR(10)
- code_type_parent — VARCHAR(20)
- code_type — VARCHAR(20)
- use_yn_parent — VARCHAR(1)
- use_yn — VARCHAR(1) — NOT NULL
- sub_yn_parent — VARCHAR(1)
- sub_yn — VARCHAR(1)
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_comp
- comp_name — VARCHAR(100) — NOT NULL
- ceo_name — VARCHAR(50)
- gln_code — VARCHAR(20)
- address — VARCHAR(200)
- zip_code — VARCHAR(10)
- tel — VARCHAR(20)
- fax — VARCHAR(20)
- email — VARCHAR(100)
- b_type_parent — VARCHAR(20)
- b_type — VARCHAR(20)
- web_url — VARCHAR(200)
- b_number — VARCHAR(20)
- img_file — VARCHAR(200)
- service_gubn_parent — VARCHAR(20)
- service_gubn — VARCHAR(20)
- plan_type — VARCHAR(20)
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code — VARCHAR(20) — NOT NULL
t_sys_dept
- dept_id — VARCHAR(20) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- parent_dept_id — VARCHAR(20)
- dept_name — VARCHAR(100) — NOT NULL
- dept_code — VARCHAR(20)
- dept_desc — VARCHAR(200)
- dept_order — INT
- code_type_parent — VARCHAR(20)
- code_type — VARCHAR(20)
- use_yn_parent — VARCHAR(1)
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_sys_global_option
- g_opt_code — VARCHAR(50) — NOT NULL
- g_opt_name — VARCHAR(100) — NOT NULL
- g_opt_value — TEXT
- g_opt_remark — VARCHAR(200)
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_log
- log_idx — BIGINT — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code
- user_id — VARCHAR(50)
- ip_addr — VARCHAR(50)
- user_browser — VARCHAR(200)
- browser_name — VARCHAR(50)
- request_uri — VARCHAR(500)
- request_data — TEXT
- mobile_yn — VARCHAR(1)
- request_method — VARCHAR(10)
- os_name — VARCHAR(50)
- reg_dt — TIMESTAMP — NOT NULL
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_sys_login_log
- log_idx — BIGINT — NOT NULL
- comp_code — VARCHAR(20)
- log_type — VARCHAR(20)
- login_id — VARCHAR(50)
- login_ip — VARCHAR(50)
- login_result — VARCHAR(20)
- login_msg — VARCHAR(200)
- device_type — VARCHAR(20)
- is_mobile — VARCHAR(1)
- reg_dt — TIMESTAMP — NOT NULL
t_sys_menu_btn
- menu_id — INT — 외래 키 → t_sys_menu_info.menu_id — NOT NULL
- btn_id — VARCHAR(20) — 외래 키 → t_sys_btn_info.btn_id — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_menu_btn_role_info
- role_id — VARCHAR(20) — 외래 키 → t_sys_role_info.role_id — NOT NULL
- menu_id — INT — 외래 키 → t_sys_menu_info.menu_id — NOT NULL
- btn_id — VARCHAR(20) — 외래 키 → t_sys_btn_info.btn_id — NOT NULL
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_role_info.comp_code — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_menu_info
- menu_id — INT — NOT NULL
- parent_menu_id — INT
- menu_name — VARCHAR(100) — NOT NULL
- menu_url — VARCHAR(200)
- menu_sbc — VARCHAR(200)
- menu_icon — VARCHAR(50)
- menu_order — INT
- code_type_parent — VARCHAR(20)
- code_type — VARCHAR(20)
- use_yn — VARCHAR(1) — NOT NULL
- lang_code — VARCHAR(10)
- code_id — VARCHAR(20)
- sub_prefix — VARCHAR(20)
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_numbering
- num_code — VARCHAR(20) — NOT NULL
- num_desc — VARCHAR(100)
- num_prefix — VARCHAR(10)
- seq_length — INT — NOT NULL
- use_year — VARCHAR(1)
- use_month — VARCHAR(1)
- use_day — VARCHAR(1)
- stack_count — INT — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_sys_role_info
- role_id — VARCHAR(20) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- role_name — VARCHAR(50) — NOT NULL
- role_gubn_parent — VARCHAR(20)
- role_gubn — VARCHAR(20)
- use_yn_parent — VARCHAR(1)
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_sys_user_info
- user_id — VARCHAR(50) — NOT NULL
- user_apply_code — VARCHAR(20)
- dept_name — VARCHAR(50)
- job_name — VARCHAR(50)
- user_pw — VARCHAR(200) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- user_email — VARCHAR(100)
- d_phone — VARCHAR(20)
- m_phone — VARCHAR(20)
- user_gubn_parent — VARCHAR(20)
- user_gubn — VARCHAR(20)
- use_yn_parent — VARCHAR(1)
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_sys_user_role_info
- role_id — VARCHAR(20) — 외래 키 → t_sys_role_info.role_id — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → t_sys_user_info.user_id — NOT NULL
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_user_info.comp_code — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
t_user_token
- token_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → t_sys_user_info.user_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- refresh_token — VARCHAR(500) — NOT NULL
- device_info — VARCHAR(200)
- ip_addr — VARCHAR(50)
- expire_dt — TIMESTAMP — NOT NULL
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_wf_definition
- wf_id — VARCHAR(50) — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- wf_name — VARCHAR(100) — NOT NULL
- wf_desc — VARCHAR(500)
- wf_status — VARCHAR(20) — NOT NULL
- trigger_type — VARCHAR(20)
- trigger_config — JSON
- version — INT — NOT NULL
- use_yn — VARCHAR(1) — NOT NULL
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_wf_edge
- edge_id — VARCHAR(50) — NOT NULL
- wf_id — VARCHAR(50) — 외래 키 → t_wf_definition.wf_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- source_node_id — VARCHAR(50) — 외래 키 → t_wf_node.node_id — NOT NULL
- target_node_id — VARCHAR(50) — 외래 키 → t_wf_node.node_id — NOT NULL
- edge_type — VARCHAR(20)
- edge_condition — JSON
- edge_label — VARCHAR(100)
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_wf_execution
- exec_id — VARCHAR(50) — NOT NULL
- wf_id — VARCHAR(50) — 외래 키 → t_wf_definition.wf_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → t_sys_user_info.user_id — NOT NULL
- exec_status — VARCHAR(20) — NOT NULL
- start_dt — TIMESTAMP — NOT NULL
- end_dt — TIMESTAMP
- input_data — JSON
- output_data — JSON
- error_msg — TEXT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_wf_execution_log
- log_id — BIGINT — NOT NULL
- exec_id — VARCHAR(50) — 외래 키 → t_wf_execution.exec_id — NOT NULL
- node_id — VARCHAR(50) — 외래 키 → t_wf_node.node_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- node_status — VARCHAR(20) — NOT NULL
- start_dt — TIMESTAMP — NOT NULL
- end_dt — TIMESTAMP
- input_data — JSON
- output_data — JSON
- token_usage — INT
- error_msg — TEXT
- retry_count — INT
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
t_wf_node
- node_id — VARCHAR(50) — NOT NULL
- wf_id — VARCHAR(50) — 외래 키 → t_wf_definition.wf_id — NOT NULL
- comp_code — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL
- agent_id — VARCHAR(50) — 외래 키 → t_agent_info.agent_id
- node_type — VARCHAR(20) — NOT NULL
- node_name — VARCHAR(100)
- node_config — JSON
- position_x — INT
- position_y — INT
- node_order — INT
- reg_id — VARCHAR(50) — NOT NULL
- reg_dt — TIMESTAMP — NOT NULL
- mod_id — VARCHAR(50)
- mod_dt — TIMESTAMP
- comp_code (comp_code2) — VARCHAR(20) — 외래 키 → t_sys_comp.comp_code — NOT NULL