mes

Tables (27)

BOM

  • BOM_no — number — Primary key — NOT NULL
  • BOM_code — varchar2 — NOT NULL — BOM_100001
  • process_no — number — Foreign key → process.process_no — NOT NULL — sequence
  • item_no — number — Foreign key → item.item_no — NOT NULL — 결과
  • BOM_qty — number — NOT NULL — 결과
  • item_no — number — NOT NULL
  • deleted — varchar — 삭제

LOT

  • LOT_no — number — Primary key — NOT NULL
  • LOT_code — varchar2 — NOT NULL — LOT_100001
  • item_no — number — Foreign key → item.item_no — NOT NULL — sequence
  • LOT_qty — number — NOT NULL — 수량
  • prod_date — date — NOT NULL — 생산날짜
  • expiry_date — date — NOT NULL — 유통기한
  • Lstatus_no — number — Foreign key → LOT_status.Lstatus_no — NOT NULL — sequence

LOT_status

  • Lstatus_no — number — Primary key — NOT NULL
  • Lstatus_name — varchar2 — NOT NULL — 정상

comment

  • comment_no — number — Primary key
  • emp_no (author) — number — Foreign key → emp.emp_no — NOT NULL
  • post_no — number — Foreign key → post.post_no — NOT NULL — sequence
  • comment_no (parent_comm) — number — Foreign key → comment.comment_no
  • content — varchar2 — NOT NULL — 내용
  • mtime — date — 최종
  • ctime — date — NOT NULL — 최초
  • deleted — varchar — 삭제

defect

  • defect_no — number — Primary key — NOT NULL
  • defect_code — varchar2 — NOT NULL — def_100001
  • qc_no — number — Foreign key → quality_check.qc_no — NOT NULL — sequence
  • defect_cnt — number — NOT NULL — 불량수량
  • solution — varchar2 — 조치
  • deleted — varchar — 삭제
  • dtype_no — number — Foreign key → defect_type.dtype_no — NOT NULL — sequence

defect_type

  • dtype_no — number — Primary key — NOT NULL
  • dtype_name — varchar2 — NOT NULL — 기기불량

dept

  • dept_no — number — Primary key — NOT NULL
  • dept_name — varchar2 — NOT NULL
  • deleted — varchar

emp

  • emp_no — number — Primary key — NOT NULL
  • emp_code — varchar2 — NOT NULL — emp_100001
  • job — varchar2 — NOT NULL — 직책
  • auth — number — NOT NULL — 권한
  • dept_no — number — Foreign key → dept.dept_no — NOT NULL
  • pw — varchar2
  • hiredate — date — NOT NULL
  • enddate — date — 퇴사일
  • deleted — varchar — NOT NULL — 재직

equiplment_log

  • log_no — number — Primary key — NOT NULL
  • log_code — varchar2 — NOT NULL — log_100001
  • equipment_no — number — Foreign key → equipment.equipment_no — NOT NULL — 유지보수한
  • error_no — number — Foreign key → equipment_error.error_no — NOT NULL
  • emp_no (director) — number — Foreign key → emp.emp_no — NOT NULL — 담당자
  • log_sdate — date — NOT NULL — 시작일
  • log_edate — date — 종료일
  • log_content — varchar2 — 유지보수
  • deleted — varchar — 삭제

equipment

  • equipment_no — number — Primary key — NOT NULL
  • equipment_code — varchar2 — NOT NULL — equip_100001
  • installdate — date — NOT NULL — 설치
  • process_no — number — Foreign key → process.process_no — NOT NULL — sequence
  • estatus_no — number — Foreign key → equipment_status.estatus_no — NOT NULL — sequence
  • deleted — varchar — 삭제

equipment_error

  • error_no — number — Primary key — NOT NULL
  • error_name — varchar2

equipment_status

  • estatus_no — number — Primary key — NOT NULL
  • estatus_name — varchar2 — NOT NULL — 정상

io

  • io_no — number — Primary key — NOT NULL
  • io_code — varchar2 — NOT NULL — in_100001
  • item_no — number — Foreign key → item.item_no — NOT NULL — sequence
  • LOT_no — number — Foreign key → LOT.LOT_no — NOT NULL — sequence
  • ior_no — number — Foreign key → io_reason.ior_no — NOT NULL — sequence
  • io_qty — number — NOT NULL — 수량
  • io_date — date — NOT NULL — 입출고
  • deleted — varchar — 삭제

io_reason

  • ior_no — number — Primary key — NOT NULL
  • io_type — varchar — NOT NULL — i
  • io_reason — varchar2 — NOT NULL — 생산

item

  • item_no — number — Primary key — NOT NULL
  • item_code — varchar2 — NOT NULL — item_100001
  • item_name — varchar2 — NOT NULL — 제품
  • itype_no — number — Foreign key → item_type.itype_no — NOT NULL — 제품
  • unit — varchar2 — 단위
  • deleted — varchar — 삭제

item_type

  • itype_no — number — Primary key — NOT NULL
  • itype_name — varhcar2 — NOT NULL — 원자재

plan_status

  • plstatus_no — number — Primary key — NOT NULL
  • plstatus_name — varchar2 — NOT NULL

post

  • post_no — number — Primary key — NOT NULL
  • ptype_no — number — Foreign key → post_type.ptype_no — NOT NULL — 1-건의사항
  • emp_no (author) — number — Foreign key → emp.emp_no — NOT NULL
  • title — varhcar2 — NOT NULL — 제목
  • content — varchar2 — NOT NULL — 내용
  • ctime — date — NOT NULL — 최초
  • mtime — date — 최종
  • deleted — varchar — 삭제

post_type

  • ptype_no — number — Primary key — NOT NULL
  • ptype_name — varhcar2 — NOT NULL — 건의사항

process

  • process_no — number — Foreign key → process.process_no — NOT NULL — 후행
  • process_code — varchar2 — NOT NULL — proc_100001
  • process_no (parent_proc) — number
  • deleted — varchar — 삭제

prod_plan

  • plan_no — number — Primary key — NOT NULL
  • plan_code — varchar2 — NOT NULL — plan_100001
  • emp_no (director) — number — Foreign key → emp.emp_no — NOT NULL — 생산계획
  • item_no — number — Foreign key → item.item_no — NOT NULL — 생산
  • plan_qty — number — NOT NULL — 생산
  • plan_sdate — date — NOT NULL — 시작일
  • plan_edate — date — NOT NULL — 종료일
  • plstatus_no — number — Foreign key → plan_status.plstatus_no — NOT NULL — 생산계획
  • deleted — varchar — 삭제

quality_check

  • qc_no — number — Primary key — NOT NULL
  • qc_code — varchar2 — NOT NULL — qc_100001
  • wo_no — number — Foreign key → workorder.wo_no — NOT NULL — sequence
  • qc_sdate — date — NOT NULL — 시작일
  • qc_edate — date — 종료일
  • emp_no (worker) — number — Foreign key → emp.emp_no — NOT NULL — 검사자
  • emp_no (director) — number — Foreign key → emp.emp_no — NOT NULL
  • deleted — varchar — 삭제

stock

  • stock_no — number — Primary key — NOT NULL
  • stock_code — varchar2 — NOT NULL — stock_100001
  • LOT_no — number — Foreign key → LOT.LOT_no — NOT NULL — sequence
  • item_no — number — Foreign key → item.item_no — NOT NULL — sequence
  • stock_qty — number — NOT NULL — 재고

vendor

  • vendor_no — number — Primary key — NOT NULL
  • vendor_code — varhcar2 — NOT NULL — vend_100001
  • vendor_name — varchar2 — NOT NULL — 거래처
  • tel — varchar2 — 연락처
  • vtype_no — number — Foreign key → vendor_type.vtype_no — NOT NULL — sequence
  • deleted — varhcar — 삭제

vendor_type

  • vtype_no — number — Primary key — NOT NULL
  • vtype_name — varchar2 — NOT NULL — 공급업체

wo_status

  • wostatus_no — number — Primary key — NOT NULL
  • wostatus_name — varchar2 — NOT NULL — 완료

workorder

  • wo_no — number — Primary key — NOT NULL
  • wo_code — varchar2 — NOT NULL — wo_100001
  • plan_no — number — Foreign key → prod_plan.plan_no — NOT NULL — 생산계획
  • process_no — number — Foreign key → process.process_no — NOT NULL — 공정
  • emp_no (worker) — number — Foreign key → emp.emp_no — NOT NULL — 관리자
  • workdate — date — NOT NULL — 작업일
  • wo_qty — number — NOT NULL — 목표수량
  • wostatus_no — number — Foreign key → wo_status.wostatus_no — NOT NULL — sequence
  • fin_qty — number — NOT NULL — 완료수량
  • deleted — varchar — 삭제