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)