저니빌더_피로도관리
테이블 (4)
피로도 (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)