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 — 삭제