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)