MMS
Tables (4)
log (전체 로그)
- work_order_no (Key) — Primary key — NOT NULL
- work_order_wseq (Key2) — Primary key — NOT NULL
- wseq (Field)
- plant_code (Field2)
- work_center_code (Field3)
- process_code (Field4)
- machine_code (Field5)
- work_order_run_status (Field6)
- wo_plan_qty (Field7)
- wo_item_code (Field8)
- wo_run_order_date (Field9)
- wo_run_order_end_date (Field10)
- machine_operation_status (Field11)
- active_plc_signals_count (Field12)
- production_count (Field13)
- good_production_count (Field14)
- total_defect_count (Field15)
- timestamp (Field16)
- event_date (Field17)
metrics_latest_work_order (작업지시별 마지막 측정 데이터)
- work_order_no (Key) — Primary key — NOT NULL
- work_order_wseq (Key2) — Primary key — NOT NULL
- wseq (Field)
- plant_code (Field2)
- work_center_code (Field3)
- process_code (Field4)
- machine_code (Field5)
- work_order_run_status (Field6)
- wo_plan_qty (Field7)
- wo_item_code (Field8)
- wo_run_order_date (Field9)
- wo_run_order_end_date (Field10)
- machine_operation_status (Field11)
- active_plc_signals_count (Field12)
- production_count (Field13)
- good_production_count (Field14)
- total_defect_count (Field15)
- timestamp (Field16)
- event_date (Field17)
metrics_minute_work_order (분 단위 작업지시별 통계)
- ts_minute (Key) — Primary key — NOT NULL
- event_date (Key2) — Primary key — NOT NULL
- work_order_no (Field18)
- work_order_wseq (Field19)
- wseq (Field)
- plant_code (Field2)
- work_center_code (Field3)
- process_code (Field4)
- machine_code (Field5)
- work_order_run_status (Field6)
- wo_plan_qty (Field7)
- wo_item_code (Field8)
- wo_run_order_date (Field9)
- wo_run_order_end_date (Field10)
- machine_operation_status (Field11)
- active_plc_signals_count (Field12)
- production_count (Field13)
- good_production_count (Field14)
- total_defect_count (Field15)
- timestamp (Field16)
metrics_monthly_process (월별 공정 측정 데이터)
- work_order_no (Key) — Primary key — NOT NULL
- work_order_wseq (Key2) — Primary key — NOT NULL
- wseq (Field)
- plant_code (Field2)
- work_center_code (Field3)
- process_code (Field4)
- machine_code (Field5)
- work_order_run_status (Field6)
- wo_plan_qty (Field7)
- wo_item_code (Field8)
- wo_run_order_date (Field9)
- wo_run_order_end_date (Field10)
- machine_operation_status (Field11)
- active_plc_signals_count (Field12)
- production_count (Field13)
- good_production_count (Field14)
- total_defect_count (Field15)
- timestamp (Field16)
- event_date (Field17)