저니빌더_피로도관리

테이블 (4)

접촉규칙-필드 (Untitled)

  • Field
  • Field2
  • Field3

피로도 (tb_jb_fatigue_mgnt)

  • Key (ftg_rule_id) — varchar — 기본 키 — NOT NULL
  • Field2 (ftg_rule_nm) — varchar
  • Field2 (ftg_rule_desc) — varchar
  • Field3 (ftg_rule_type) — varchar
  • Field4 (chnl_dv) — varchar
  • Field5 (pior_rank) — varchar
  • Field (term_val)
  • Field (term_dv)
  • Field (strt_dt)
  • Field (strt_tm)
  • Field (end_dt)
  • Field (end_tm)
  • Field (prms_msg_cont)
  • Field (frst_reg_dttm)
  • Field (frst_reg_user_id)
  • Field (last_upd_dttm)
  • Field (last_upd_user_id)

피로도 관리 통계 (tb_jb_fatigue_mgmt_stac)

  • Field (ftg_rule_id) — varchar
  • Field (sgmt_rule_id)
  • Field (sgmt_rule_stac_id)
  • Field (sgmt_tbl_nm)
  • Field (stac_clmn_nm)
  • Field (stac_calc_type)
  • Field (stac_oprt)
  • Field (stac_cond1)
  • Field (stac_cond2)
  • Field (stac_cond3)
  • Field (stac_cond4)
  • Field (stac_cond5)
  • Field (stac_cond6)
  • Field (stac_logi_expsn)
  • Field (stac_matched_id)
  • Field (rt_term)
  • Field (str_deli)
  • Field (filter_logi_option)

피로도상세 (tb_jb_fatigue_mgmt_dtl)

  • Key (ftg_rule_id) — varchar — 외래 키 → 피로도.Key — NOT NULL
  • Field (sgmt_rule_id)
  • Field (sgmt_rule_dtl_id)
  • Field (sgmt_dv_cd)
  • Field (sgmt_tbl_nm)
  • Field (sgmt_clmn_nm)
  • Field (sgmt_oprt)
  • Field (sgmt_cond1)
  • Field (sgmt_cond2)
  • Field (sgmt_cond3)
  • Field (sgmt_cond4)
  • Field (sgmt_cond5)
  • Field (sgmt_cond6)
  • Field (sgmt_clmn_dtp_cd)
  • Field (sgmt_rule_stac_id)
  • Field (str_deli)
  • Field (dtl_matched_id)