3JO

Tables (37)

auth

  • auth_no — NUMBER(20) — Primary key — NOT NULL
  • auth_lvl — NUMBER(20)
  • auth_name — VARCHAR2(100)

bom

  • bom_no — NUMBER(10) — Primary key — NOT NULL
  • pd_cd — VARCHAR2(100) — NOT NULL
  • unit — VARCHAR2(100)
  • detail_unit — VARCHAR2(100)
  • consum — NUMBER(20) — NOT NULL
  • mt_cd — VARCHAR2(100) — Foreign key → mt.mt_cd — NOT NULL
  • pd_name — VARCHAR2(20)

cli

  • cli_cd — VARCHAR2(100) — Primary key — NOT NULL
  • cli_name — VARCHAR2(100)
  • bussno — VARCHAR2(30)
  • tel — VARCHAR2(50)
  • addr — VARCHAR2(150)
  • cli_chg — VARCHAR2(50)
  • mail — VARCHAR2(150)

com_cd

  • wk_cd_no — NUMBER(20) — Primary key — NOT NULL
  • cd_name — VARCHAR2(100)
  • cd_desc — VARCHAR2(150)

com_detail_cd

  • detail_cd_no — NUMBER(20) — Primary key — NOT NULL
  • detail_cd_name — VARCHAR2(100)
  • detail_cd_desc — VARCHAR2(100) — NOT NULL
  • wk_cd_no — NUMBER(20) — Foreign key → com_cd.wk_cd_no — NOT NULL

disc_pd

  • disc_no — NUMBER(20) — Primary key — NOT NULL
  • qt — NUMBER(10)
  • cost — NUMBER(20)
  • disc_dt — DATE
  • rsn — NUMBER(20) — NOT NULL
  • disc_chg — VARCHAR2(50)
  • pd_lot — VARCHAR2(100) — Foreign key → pd_stk.pd_lot — NOT NULL

emp

  • emp_no — NUMBER(20) — Primary key — NOT NULL
  • id — VARCHAR2(100)
  • pw — VARCHAR2(100)
  • name — VARCHAR2(100)
  • tel — VARCHAR2(50)
  • enter_cd — VARCHAR2(100) — Foreign key → enter.enter_cd — NOT NULL
  • auth_no — NUMBER(20) — Foreign key → auth.auth_no — NOT NULL
  • dpt — VARCHAR2(100)

enter

  • enter_cd — VARCHAR2(100) — Primary key — NOT NULL
  • id — VARCHAR2(100)
  • pw — VARCHAR2(100)
  • bussno — VARCHAR2(30) — NOT NULL
  • enter_name — VARCHAR2(100)
  • chg — VARCHAR2(50)
  • mail — VARCHAR2(150)
  • ceo — VARCHAR2(100)
  • auth_no — NUMBER(20) — Foreign key → auth.auth_no — NOT NULL
  • st — NUMBER(20)

fc

  • fc_cd — VARCHAR2(100) — Primary key — NOT NULL
  • fc_name — VARCHAR2(100)
  • st — NUMBER(20)
  • ins_mf — VARCHAR2(150)
  • mnf_com — VARCHAR2(150)
  • str_dt — DATE
  • ins_cycle — NUMBER(20)
  • last_ins_dt — DATE
  • output — NUMBER(10)
  • dur_time — INTEGER
  • next_ins_dt — DATE

fc_ins

  • ins_cd — VARCHAR2(100) — Primary key — NOT NULL
  • ins_dt — DATE
  • ins_cat — NUMBER(20)
  • ins_cont — VARCHAR2(150)
  • cc — VARCHAR2(150)
  • chg — VARCHAR2(50)
  • fc_cd — VARCHAR2(100) — Foreign key → fc.fc_cd — NOT NULL

mf_ck

  • mf_ck_no — NUMBER(20) — Primary key — NOT NULL
  • cc_name — VARCHAR2(100)
  • ck_st — NUMBER(20)
  • pd_name — VARCHAR2(100)
  • pdt_qt — NUMBER(10)
  • rt_dt — DATE
  • rt_chg — VARCHAR2(50)
  • first_cc — NUMBER(100)
  • second_cc — NUMBER(100)
  • third_cc — NUMBER(100)
  • fourth_cc — NUMBER(100)
  • fifth_cc — NUMBER(100)
  • cc_avg — NUMBER(100)
  • mfck_res — VARCHAR2(20)
  • ck_dt — DATE
  • ck_chg — VARCHAR2(50)
  • pass_std — VARCHAR2(100)
  • pdt_inst_detail_no — NUMBER(20)

mf_ps

  • pdt_ps_cd — VARCHAR2(150) — Primary key — NOT NULL
  • mf_ps_div — VARCHAR2(50)
  • mf_step — NUMBER(10)
  • mf_step_time — NUMBER(10)
  • mf_ps_name — VARCHAR2(50)

mt

  • mt_cd — VARCHAR2(100) — Primary key — NOT NULL
  • mt_div — VARCHAR2(50)
  • mt_name — VARCHAR2(100)
  • cost — NUMBER(20)
  • unit — VARCHAR2(20)
  • exp_dt — DATE
  • leadtm — NUMBER(20) — NOT NULL
  • safe_stk_rate — NUMBER(10)
  • cli_cd — VARCHAR2(100) — Foreign key → cli.cli_cd — NOT NULL

mt_ck

  • mt_ck_no — NUMBER(20) — Primary key — NOT NULL
  • mt_cd — VARCHAR2(100) — NOT NULL
  • str_qt — NUMBER(10)
  • str_comp_dt — DATE
  • cli_name — VARCHAR2(100)
  • str_chg — VARCHAR2(50)
  • mc — VARCHAR2(100)
  • first_mc — NUMBER(100)
  • second_mc — NUMBER(100)
  • third_mc — NUMBER(100)
  • fourth_mc — NUMBER(100)
  • fifth_mc — NUMBER(100)
  • mc_avg — NUMBER(100)
  • mc_res — VARCHAR2(50)
  • ck_dt — DATE
  • ck_chg — VARCHAR2(50)
  • first_ic — NUMBER(100)
  • second_ic — NUMBER(100)
  • third_ic — NUMBER(100)
  • fourth_ic — NUMBER(100)
  • fifth_ic — NUMBER(100)
  • ic_avgval — NUMBER(100)
  • pass_std — NUMBER(100)
  • ic_res — VARCHAR2(100)
  • mt_placeod_cd — VARCHAR2(100) — Foreign key → mt_placeod.mt_placeod_cd — NOT NULL

mt_disc

  • mt_disc_no — NUMBER(20) — Primary key — NOT NULL
  • disc_qt — NUMBER(10)
  • disc_cost — NUMBER(20)
  • disc_compdt — DATE
  • rsn — NUMBER(20) — NOT NULL
  • disc_chg — VARCHAR2(50)
  • mt_lot — VARCHAR2(100) — Foreign key → mt_stk.mt_lot — NOT NULL
  • mt_cd — VARCHAR2(100) — NOT NULL

mt_placeod

  • mt_placeod_cd — VARCHAR2(100) — Primary key — NOT NULL
  • placeod_qt — NUMBER(10)
  • placeod_compdt — DATE
  • placeod_chg — VARCHAR2(50)
  • placeod_st — NUMBER(20)
  • mt_cd — VARCHAR2(100) — Foreign key → mt.mt_cd — NOT NULL
  • cli_cd — VARCHAR2(100) — Foreign key → cli.cli_cd — NOT NULL

mt_rtn

  • mt_rtn_no — NUMBER(20) — Primary key — NOT NULL
  • rtn_qt — NUMBER(10)
  • rtn_compdt — DATE
  • rtn_chg — VARCHAR2(50)
  • mt_placeod_cd — VARCHAR2(100) — Foreign key → mt_placeod.mt_placeod_cd — NOT NULL
  • mt_cd — VARCHAR2(100) — NOT NULL

mt_send

  • mt_send_no — NUMBER(20) — Primary key — NOT NULL
  • send_qt — NUMBER(10)
  • send_compdt — DATE
  • send_chg — VARCHAR2(50)
  • send_st — NUMBER(20)
  • mt_lot — VARCHAR2(100) — Foreign key → mt_stk.mt_lot — NOT NULL
  • pdt_inst_detail_no — NUMBER(20)

mt_stk

  • mt_lot — VARCHAR2(100) — Primary key — NOT NULL
  • stk_qt — NUMBER(10)
  • exp_dt — DATE
  • mt_cd — VARCHAR2(100) — Foreign key → mt.mt_cd — NOT NULL
  • mt_str_no — NUMBER(20) — Foreign key → mt_str.mt_str_no — NOT NULL

mt_str

  • mt_str_no — NUMBER(20) — Primary key — NOT NULL
  • str_qt — NUMBER(10)
  • str_compdt — DATE
  • str_chg — VARCHAR2(50)
  • mt_placeod_cd — VARCHAR2(100) — Foreign key → mt_placeod.mt_placeod_cd — NOT NULL
  • mt_cd — VARCHAR2(100) — NOT NULL

nonop_mgmt

  • nonop_cd — VARCHAR2(100) — Primary key — NOT NULL
  • nonop_stt_time — TIMESTAMP()
  • nonop_fn_time — TIMESTAMP()
  • fc_chg — VARCHAR2(50)
  • rsn — VARCHAR2(150)
  • rsn_desc — VARCHAR2(150)
  • fc_cd — VARCHAR2(100) — Foreign key → fc.fc_cd — NOT NULL

od

  • od_no — NUMBER(20) — Primary key — NOT NULL
  • od_dt — DATE
  • od_chg — VARCHAR2(50)
  • dc_rate — NUMBER(10)
  • total_price — NUMBER(20)
  • cli_cd — VARCHAR2(100) — Foreign key → cli.cli_cd — NOT NULL
  • od_detail_st — NUMBER(20)

od_detail

  • od_detailno — NUMBER(20) — Primary key — NOT NULL
  • qt — NUMBER(10)
  • cost — NUMBER(20)
  • detail_price — NUMBER(20)
  • od_no — NUMBER(20) — Foreign key → od.od_no — NOT NULL
  • pd_cd — VARCHAR2(100) — Foreign key → pd.pd_cd — NOT NULL
  • due_dt — DATE
  • send_od_st — NUMBER(20)

pack_ck

  • pack_ck_no — NUMBER(20) — Primary key — NOT NULL
  • nc_name — VARCHAR2(100)
  • ck_st — NUMBER(20)
  • pd_name — VARCHAR2(100)
  • pdt_qt — NUMBER(10)
  • pd_lot — VARCHAR2(100)
  • pack_dt — DATE
  • pack_chg — VARCHAR2(50)
  • first_nc — NUMBER(100)
  • second_nc — NUMBER(100)
  • third_nc — NUMBER(100)
  • fourth_nc — NUMBER(100)
  • fifth_nc — NUMBER(100)
  • nc_avgval — NUMBER(100)
  • packck_res — VARCHAR2(20)
  • ck_dt — DATE
  • ck_chg — VARCHAR2(50)
  • pass_std — NUMBER(100)
  • pdt_inst_detail_no — NUMBER(20)

pay

  • pay_cd — VARCHAR2(100) — Primary key — NOT NULL
  • pay_dt — DATE
  • price — NUMBER(20)
  • sub_no — NUMBER(20) — Foreign key → sub.sub_no — NOT NULL
  • enter_cd — VARCHAR2(100) — Foreign key → enter.enter_cd — NOT NULL

pd

  • pd_cd — VARCHAR2(100) — Primary key — NOT NULL
  • pd_name — VARCHAR2(100)
  • unit — VARCHAR2(20)
  • cost — NUMBER(20)
  • safe_stk_qt — NUMBER

pd_stk

  • pd_lot — VARCHAR2(100) — Primary key — NOT NULL
  • unit — VARCHAR2(100)
  • qt — NUMBER(10)
  • pdt_dt — DATE
  • exp_dt — DATE
  • pd_cd — VARCHAR2(100) — Foreign key → pd.pd_cd — NOT NULL
  • pdt_inst_detail_no — NUMBER(20)

pdt_inst

  • pdt_inst_no — NUMBER(20) — Primary key — NOT NULL
  • pdt_inst_dt — DATE
  • pdt_plan_cd — VARCHAR2(100) — Foreign key → pdt_plan.pdt_plan_cd — NOT NULL
  • pdt_chg — VARCHAR2(50)

pdt_inst_detail

  • pdt_inst_detail_no — NUMBER(20) — Primary key — NOT NULL
  • pd_cd — VARCHAR2(50)
  • qt — NUMBER(10)
  • pdt_stt_time — DATE
  • pdtexpt_fn_time — DATE
  • pdt_inst_no — NUMBER(20)
  • comp_st — VARCHAR2(100)

pdt_pd_cd

  • mf_no — NUMBER(10) — Primary key — NOT NULL
  • pdt_pd_cd — VARCHAR2(100)
  • add_time — NUMBER(10)
  • pdt_ps_cd — VARCHAR2(150)

pdt_plan

  • pdt_plan_cd — VARCHAR2(100) — Primary key — NOT NULL
  • wk_plan_stt_dt — DATE
  • plan_name — VARCHAR2(100)

pdt_plan_detail

  • pdt_plan_detail_no — NUMBER(20) — Primary key — NOT NULL
  • pdt_plan_cd — VARCHAR2(100)
  • pd_name — VARCHAR2(100)
  • qt — NUMBER(10)
  • due_dt — DATE
  • pd_cd — VARCHAR2(50)

pdt_prog_hist

  • pdt_hist_no — NUMBER(20) — Primary key — NOT NULL
  • pdt_dt — DATE
  • pd_cd — VARCHAR2(50)
  • pdt_qt — NUMBER(10)
  • pdt_expt_stt_time — TIMESTAMP
  • pdt_expt_fn_time — TIMESTAMP
  • pdt_stt_time — TIMESTAMP()
  • pdt_fn_time — TIMESTAMP()
  • pdt_inst_detail_no — NUMBER(20)
  • mf_qual_st — NUMBER(20)
  • pack_qual_st — NUMBER(20)
  • fail_rsn — VARCHAR2(150)
  • mf_no — NUMBER(10)
  • pdt_unit — VARCHAR2(50)

qual_ck_std_mgmt

  • std_mgmt_no — NUMBER(20) — Primary key — NOT NULL
  • category — VARCHAR2(100)
  • ck_name — VARCHAR2(100)
  • pass_std — NUMBER(100)
  • input_avail_val — NUMBER(100)

rtn

  • rtn_no — NUMBER(20) — Primary key — NOT NULL
  • cli_chg — VARCHAR2(50)
  • rtn_chg — VARCHAR2(50)
  • rtn_compdt — DATE
  • od_no — NUMBER(20) — Foreign key → od.od_no — NOT NULL

send

  • send_no — NUMBER(20) — Primary key — NOT NULL
  • qt — NUMBER(10)
  • send_dt — DATE
  • send_chg — VARCHAR2(50)
  • od_no — NUMBER(20) — Foreign key → od.od_no — NOT NULL
  • pd_lot — VARCHAR2(100) — Foreign key → pd_stk.pd_lot — NOT NULL

sub

  • sub_no — NUMBER(20) — Primary key — NOT NULL
  • rank — NUMBER(20) — NOT NULL
  • sub_name — VARCHAR2(100)
  • pr — NUMBER(20)
  • detail_desc — VARCHAR2(150)