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)