mes
Tables (47)
bom_mat
- mat_code — varchar(20) — Primary key — NOT NULL
- bom_code — varchar(20) — Foreign key → bom_tbl.bom_code — NOT NULL
- mat_name — varchar(200) — NOT NULL
- mat_type — varchar(4) — NOT NULL
- req_qtt — int(11) — NOT NULL
- unit — varchar(4) — NOT NULL
- loss_rate — double(5,2)
bom_save
- bom_save_code — varchar(20) — Primary key — NOT NULL
- mat_type — varchar(4) — NOT NULL
- req_qtt — int(11) — NOT NULL
- unit — varchar(4) — NOT NULL
- spec — varchar(4)
- loss_rate — double(5, 2)
- copy_date — datetime — NOT NULL
- wko_code — varchar(20) — Foreign key → wko_tbl.wko_code — NOT NULL
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
bom_tbl
- bom_code — varchar(20) — Primary key — NOT NULL
- unit — varchar(4)
- spec — varchar(4) — NOT NULL
- regdate — TIMESTAMP — NOT NULL
- udate — date
- is_used — varchar(4) — NOT NULL
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
client_tbl
- client_code — varchar(20) — Primary key — NOT NULL — 거래처별 코드를 자동부여
- client_name — varchar(50) — NOT NULL
- client_type — varchar(4) — NOT NULL
- client_mname — varchar(20) — NOT NULL
- brn — varchar(50) — NOT NULL
- client_pnum — varchar(20) — NOT NULL
- client_addr — varchar(100) — NOT NULL
- client_addr2 — varchar(100) — NOT NULL
- client_regdate — TIMESTAMP — NOT NULL
- note — text
common_code
- com_value — varchar(20) — Primary key — NOT NULL
- group_value — varchar(20)
- note — varchar(100) — NOT NULL
dept_tbl
- dept_code — varchar(20) — Primary key — NOT NULL
- dept_name — varchar(50) — NOT NULL
emp_tbl
- emp_code — varchar(20) — Primary key — NOT NULL — 작업자별 코드를 자동
- emp_name — varchar(200) — NOT NULL
- emp_pw — varchar(200) — NOT NULL
- emp_job_id — varchar(20) — NOT NULL
- emp_pnum — varchar(50) — NOT NULL
- emp_email — varchar(50) — NOT NULL
- hdate — date — NOT NULL
- ledate — date
- regdate — TIMESTAMP
- emp_stat — varchar(10) — NOT NULL
- auth — varchar(10) — NOT NULL
- note — text
- dept_code — varchar(20) — Foreign key → dept_tbl.dept_code — NOT NULL
- reg — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
eq_ma_tbl
- eq_ma_code — varchar(20) — Primary key — NOT NULL
- fail_date — date — NOT NULL
- fail_cause — varchar(200) — NOT NULL
- act_detail — varchar(200) — NOT NULL
- act_result — varchar(4) — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- re_chk_exp_date — date
- regdate — TIMESTAMP — NOT NULL
- note — text
- eqir_code — varchar(20) — Foreign key → eqir_tbl.eqir_code — NOT NULL
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- fix_emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
eq_tbl
- eq_code — varchar(20) — Primary key — NOT NULL
- eq_name — varchar(200) — NOT NULL
- eq_model — varchar(200) — NOT NULL
- eq_maker — varchar(200) — NOT NULL
- capacity — int(11) — NOT NULL
- stat — varchar(4) — NOT NULL
- eq_make_date — date — NOT NULL
- bring_date — date — NOT NULL
- take_date — date — NOT NULL
- eq_pos — varchar(200) — NOT NULL
- eq_type — varchar(4) — NOT NULL
- is_used — varchar(4)
eqi_list_tbl
- eq_code — varchar(20) — Foreign key → eq_tbl.eq_code — NOT NULL
- chk_type_code — varchar(20) — Foreign key → eqi_type_tbl.chk_type_code — NOT NULL
- chk_cycle — int(11) — NOT NULL
- chk_nec — varchar(4) — NOT NULL
- note — text — NOT NULL
eqi_type_tbl
- chk_type_code — varchar(20) — Primary key — NOT NULL
- eq_type — varchar(4) — NOT NULL
- chk_text — varchar(200) — NOT NULL
- chk_mth — varchar(200) — NOT NULL
- range_top — double(10,2) — NOT NULL
- range_bot — double(10,2)
- unit — varchar(4) — NOT NULL
- jdg_mth — varchar(200) — NOT NULL
- regdate — TIMESTAMP — NOT NULL
- crrdate — date
- note — text
eqii_tbl
- eqii_code — varchar(20) — Primary key — NOT NULL
- inst_date — date — NOT NULL
- chk_exp_date — date — NOT NULL
- stat — varchar(4) — NOT NULL
- note — text
- inst_emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
eqir_tbl
- eqir_code — varchar(20) — Primary key — NOT NULL
- chk_start_date — datetime — NOT NULL
- chk_end_date — datetime
- eqii_code — varchar(20) — Foreign key → eqii_tbl.eqii_code — NOT NULL
- eq_code — varchar(20) — Foreign key → eq_tbl.eq_code — NOT NULL
- chk_type_code — varchar(20) — Foreign key → eqi_type_tbl.chk_type_code — NOT NULL
- chk_detail — varchar(200) — NOT NULL
- note — text
- chk_result — varchar(4)
- eqi_stat — varchar(20) — NOT NULL
line_d_tbl
- line_eq_code — varchar(20) — Primary key — NOT NULL
- pp_code — varchar(20) — Foreign key → prod_proc_d_tbl.pp_code — NOT NULL
- line_code — varchar(20) — Foreign key → line_tbl.line_code — NOT NULL
- eq_code — varchar(20) — Foreign key → eq_tbl.eq_code — NOT NULL
line_tbl
- line_code — varchar(20) — Primary key — NOT NULL
- line_name — varchar(200) — NOT NULL
- line_type — varchar(4) — NOT NULL
- is_used — varchar(4)
- regdate_t — datetime — NOT NULL
- note — text
- mdept_code — varchar(20) — Foreign key → dept_tbl.dept_code — NOT NULL
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code
lot_tbl
- lot_num — varchar(20) — Primary key — NOT NULL
- issdate — TIMESTAMP — NOT NULL
- item_type_code — varchar(4)
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
mat_lot_tbl
- lot_num — varchar(20) — Primary key — NOT NULL
- issdate — TIMESTAMP — NOT NULL
- item_type_code — varchar(4)
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
mat_tbl
- mat_code — varchar(20) — Primary key — NOT NULL — 자재별 코드를 자동화
- mat_name — varchar(50) — NOT NULL
- unit — varchar(20) — NOT NULL
- spec — varchar(200) — NOT NULL
- save_inven — int(11) — NOT NULL
- edate — int(11) — NOT NULL
- is_used — varchar(20) — NOT NULL
- regdate — TIMESTAMP
- note — text
- sup — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- material_type_code — varchar(20) — Foreign key → common_code.com_value — NOT NULL
minbnd_tbl
- minbnd_code — varchar(20) — Primary key — NOT NULL
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
- mat_type — varchar(4)
- unit — varchar(4) — NOT NULL
- inbnd_qtt — int(11) — NOT NULL
- inbnd_date — date — NOT NULL
- ord_qtt — int(11) — NOT NULL
- qio_code — varchar(20) — Foreign key → qio_tbl.qio_code — NOT NULL
- lot_num — varchar(20) — Foreign key → mat_lot_tbl.lot_num — NOT NULL
- mat_sup — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
moutbnd_tbl
- moutbnd_code — varchar(20) — Primary key — NOT NULL
- mat_unit — varchar(4)
- outbnd_qtt — int(11)
- moutbnd_date — date
- order_qtt — int(11)
- wko_code — varchar(20) — Foreign key → wko_tbl.wko_code
- lot_num — varchar(20) — Foreign key → mat_lot_tbl.lot_num
- mat_sup — varchar(20) — Foreign key → client_tbl.client_code
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code
- prdr_code — varchar(20) — Foreign key → prdr_tbl.prdr_code
mpo_d_tbl
- mpo_d_code — varchar(20) — Primary key — NOT NULL
- unit — varchar(4) — NOT NULL
- req_qtt — int(11) — NOT NULL
- deadline — date — NOT NULL
- purchase_code — varchar(20) — Foreign key → mpo_tbl.purchase_code — NOT NULL
- client_code — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
mpo_tbl
- purchase_code — varchar(20) — Primary key — NOT NULL
- purchase_req_date — date — NOT NULL
- stat — varchar(4) — NOT NULL
- regdate — date — NOT NULL
- note — text
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
mpr_d_tbl
- mpr_d_code — varchar(20) — Primary key — NOT NULL
- req_qtt — int(11) — NOT NULL
- unit — varchar(4) — NOT NULL
- note — text
- mpr_code — varchar(20) — Foreign key → mpr_tbl.mpr_code — NOT NULL
- mat_sup — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
mpr_mapp_tbl
- mapp_code — varchar(20) — Primary key — NOT NULL
- mpr_code — varchar(20) — Foreign key → mpr_tbl.mpr_code — NOT NULL
- purchase_code — varchar(20) — Foreign key → mpo_tbl.purchase_code — NOT NULL
- req_qtt — int(11) — NOT NULL
- regdate — TIMESTAMP — NOT NULL
mpr_tbl
- mpr_code — varchar(20) — Primary key — NOT NULL
- reqdate — date
- deadline — date
- mrp_code — varchar(20) — Foreign key → mrp_tbl.mrp_code — NOT NULL — mrp 계획 단위로 번호 자동부여
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
mrp_d_tbl
- mrp_d_code — varchar(20) — Primary key — NOT NULL
- unit — varchar(20) — NOT NULL
- req_qtt — int(10) — NOT NULL
- mrp_code — varchar(20) — Foreign key → mrp_tbl.mrp_code — NOT NULL — mrp 계획 단위로 번호 자동부여
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
mrp_tbl
- mrp_code — varchar(20) — Primary key — NOT NULL — mrp 계획 단위로 번호 자동부여
- plan_date — date — NOT NULL
- start_date — date — NOT NULL
- mrp_note — text
- prdp_code — varchar(20) — Foreign key → prdp_tbl.prdp_code — NOT NULL — 생산계획에 따라 자동
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
ord_d_tbl
- ord_d_code — varchar(20) — Primary key — NOT NULL
- unit — varchar(4) — NOT NULL
- spec — varchar(4)
- ord_amount — int(11) — NOT NULL
- prod_price — int(10) — NOT NULL
- delivery_date — date — NOT NULL
- ord_priority — varchar(20)
- total_price — int(20) — NOT NULL
- ord_code — varchar(20) — Foreign key → ord_tbl.ord_code — NOT NULL — 주문별로 자동생성
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
ord_tbl
- ord_code — varchar(20) — Primary key — NOT NULL — 주문별로 자동생성
- ord_name — varchar(50) — NOT NULL
- ord_date — date — NOT NULL
- ord_stat — varchar(4) — NOT NULL
- note — text
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- client_code — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
out_req_d_tbl
- out_req_d_code — varchar(40) — Primary key — NOT NULL
- out_req_d_amount — int(11)
- ord_amount — int(10) — NOT NULL
- out_req_code — varchar(40)
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
- com_value — varchar(4)
out_req_tbl
- out_req_code — varchar(40) — Primary key — NOT NULL
- out_req_date — date — NOT NULL
- ord_predict_date — date — NOT NULL
- note — text
- ord_code — varchar(20) — Foreign key → ord_tbl.ord_code — NOT NULL — 주문별로 자동생성
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- client_code — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
pinbnd_tbl
- pinbnd_code — varchar(20) — Primary key — NOT NULL — 작업지시번호
- qtt — int(11) — NOT NULL
- pinbnd_date — date — NOT NULL
- note — text
- qir_code — varchar(20) — Foreign key → qir_tbl.qir_code
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
- lot_num — varchar(20) — Foreign key → lot_tbl.lot_num — NOT NULL
po_tbl
- po_code — varchar(20) — Primary key — NOT NULL
- po_name — varchar(200)
- note — text
- qcr_code — varchar(20) — Foreign key → qcr_tbl.qcr_code — NOT NULL
poutbnd_tbl
- poutbnd_code — varchar(40) — Primary key — NOT NULL
- req_qtt — int(11) — NOT NULL
- outbnd_qtt — int(11) — NOT NULL
- deadline — date — NOT NULL
- stat — varchar(4) — NOT NULL
- outbound_request_code — varchar(40) — Foreign key → out_req_tbl.out_req_code
- lot_num — varchar(20) — Foreign key → lot_tbl.lot_num
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
- client_code — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
- mcode — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
prdp_d_tbl
- prdp_d_code — varchar(20) — Primary key — NOT NULL — 생산계획의 상세코드(제품명)에 대한 코드 자동부여
- planned_qtt — int(11) — NOT NULL
- priority — int(11) — NOT NULL
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- prdp_code — varchar(20) — Foreign key → prdp_tbl.prdp_code — NOT NULL — 생산계획에 따라 자동
- line_code — varchar(20) — Foreign key → line_tbl.line_code — NOT NULL
prdp_tbl
- prdp_code — varchar(20) — Primary key — NOT NULL — 생산계획에 따라 자동
- prdp_name — varchar(200)
- prdp_date — date — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- due_date — date — NOT NULL
- note — text
- ord_code — varchar(20) — Foreign key → ord_tbl.ord_code
- reg — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
prdr_d_tbl
- prdr_d_code — varchar(20) — Primary key — NOT NULL
- input_qtt — int(11)
- def_qtt — int(11)
- make_qtt — int(11)
- start_date — datetime
- total_time — time
- end_date — datetime
- proc_rate — float(5,2)
- prdr_code — varchar(20) — Foreign key → prdr_tbl.prdr_code
- line_eq_code — varchar(20) — Foreign key → line_d_tbl.line_eq_code
prdr_s_tbl
- prdr_s_code — varchar(20) — Primary key — NOT NULL
- start_time — datetime
- end_time — datetime
- product_qtt — int(11)
- def_rate — double(5,2)
- op_rate — double(5,2)
- complete_rate — double(5,2)
- prdr_s_time — TIMESTAMP — NOT NULL
- op_time — time
- down_time — time
- def_qtt — int(11)
- po_code — varchar(20) — Foreign key → po_tbl.po_code — NOT NULL
prdr_tbl
- prdr_code — varchar(20) — Primary key — NOT NULL — 생산실적코드 자동부여
- start_date — datetime
- end_date — datetime
- total_time — time
- note — text
- production_qtt — int(11)
- work_order_code — varchar(20) — Foreign key → wko_tbl.wko_code — NOT NULL
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
- perform_rate — double(5, 2)
- stat — varchar(4)
- ord_qtt — int(11)
prod_proc_d_tbl
- pp_code — varchar(20) — Primary key — NOT NULL
- no — int(11)
- eq_type — varchar(20)
- prod_proc_code — varchar(20) — Foreign key → prod_proc_tbl.prod_proc_code — NOT NULL
- po_code — varchar(20) — Foreign key → po_tbl.po_code — NOT NULL
prod_proc_tbl
- prod_proc_code — varchar(20) — Primary key — NOT NULL
- po_type — varchar(4)
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code
- po_name — varchar(200)
- reg — varchar(20) — Foreign key → emp_tbl.emp_code
- reg_date — TIMESTAMP
- note — text
prod_tbl
- prod_code — varchar(20) — Primary key — NOT NULL
- prod_name — varchar(200)
- is_used — varchar(4) — NOT NULL
- edate — int(11) — NOT NULL
- unit — varchar(4)
- spec — varchar(4) — NOT NULL
- regdate — TIMESTAMP — NOT NULL
- note — text
- com_value — varchar(20) — Foreign key → common_code.com_value — NOT NULL
- reg — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- prod_type — varchar(20)
qcr_tbl
- qcr_code — varchar(20) — Primary key — NOT NULL
- inspection_item — varchar(200)
- range_top — double(10,2)
- range_bot — double(10,2)
- unit — varchar(4)
- check_method — varchar(200)
- regdate — date
- note — text
- com_value — varchar(4)
qio_tbl
- qio_code — varchar(20) — Primary key — NOT NULL
- qio_date — TIMESTAMP — NOT NULL
- insp_date — date — NOT NULL
- prdr_code — varchar(20) — Foreign key → prdr_tbl.prdr_code — 생산실적코드 자동부여
- po_code — varchar(20) — Foreign key → po_tbl.po_code
- mpr_d_code — varchar(20) — Foreign key → mpr_d_tbl.mpr_d_code
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
qir_tbl
- qir_code — varchar(20) — Primary key — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- unpass_qtt — int(11) — NOT NULL
- pass_qtt — int(11)
- unpass_rate — double(5, 2)
- result — varchar(4) — NOT NULL
- note — text
- qio_code — varchar(20) — Foreign key → qio_tbl.qio_code — NOT NULL
- qir_emp_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL — 작업자별 코드를 자동
- qcr_code — varchar(20) — Foreign key → qcr_tbl.qcr_code — NOT NULL
- mpr_d_code — varchar(20) — Foreign key → mpr_d_tbl.mpr_d_code
sup_tbl
- req_info_code — varchar(20) — Primary key — NOT NULL
- ltime — int(11)
- least_ord_qtt — int(11)
- priority — int(11)
- start_date — date
- end_date — date
- is_used — varchar(4) — NOT NULL
- note — text
- regdate — TIMESTAMP
- update_date — date
- client_code — varchar(20) — Foreign key → client_tbl.client_code — NOT NULL — 거래처별 코드를 자동부여
- mat_code — varchar(20) — Foreign key → mat_tbl.mat_code — NOT NULL — 자재별 코드를 자동화
wko_tbl
- wko_code — varchar(20) — Primary key — NOT NULL
- start_date — datetime
- stat — varchar(4)
- note — text
- prdp_code — varchar(20) — Foreign key → prdp_tbl.prdp_code
- prod_code — varchar(20) — Foreign key → prod_tbl.prod_code — NOT NULL
- emp_code — varchar(20) — Foreign key → emp_tbl.emp_code
- wko_qtt — int(11) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- reg_code — varchar(20) — Foreign key → emp_tbl.emp_code — NOT NULL
- end_date — datetime
- line_code — varchar(20) — Foreign key → line_tbl.line_code
- wko_name — varchar(200)