스마트제조혁신

테이블 (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