tagMgt

테이블 (9)

as (TB_ERP_AS)

  • mgt_id — int
  • as_cnt — int — NOT NULL
  • as_document_code — VARCHAR
  • as_issue_date — DATETIME
  • as_end_date — DATETIME
  • as_delivery_date — DATETIME

공구 정보 (TB_ERP_TOOL_INFO)

  • mgt_id — int
  • tool_maker — VARCHAR
  • process — VARCHAR
  • tool_id — VARCHAR

공장 serial (TB_ERP_FAC_SER)

  • mgt_id — int
  • factory_code — VARCHAR — NOT NULL
  • factory_serial_no — VARCHAR — NOT NULL

기본정보 (TB_ERP_BASIC_INFO)

  • mgt_id — int — NOT NULL
  • mac — VARCHAR
  • lot — VARCHAR
  • product_order — VARCHAR
  • project_code — VARCHAR
  • pm — VARCHAR
  • inbound_date — DATE
  • delivery_date — DATE
  • insp_lab_date — DATE
  • insp_tech_date — DATE
  • factory_code — VARCHAR
  • factory_serial_no — VARCHAR
  • delete_status — VARCHAR
  • delete_date — DATE
  • delete_reason — VARCHAR

네트워크 설정 (TB_ERP_NET_CONF)

  • mgt_id — int — NOT NULL
  • device_ip — VARCHAR
  • server_ip — VARCHAR
  • gateway — VARCHAR
  • mask — VARCHAR
  • tdma — VARCHAR
  • port — VARCHAR

버전 및 설정정보 (TB_ERP_VER_CONF)

  • mgt_id — int — NOT NULL
  • hw_ver — VARCHAR
  • fw_ver — VARCHAR
  • led_sec — int
  • ri_ms — int
  • tx_power — int
  • random_dev — VARCHAR — NOT NULL
  • rf_profile — int
  • channel — int
  • sleep_mode — VARCHAR
  • sleep_threshold — VARCHAR
  • sleep_interval — int
  • bc_ver — int
  • bc_period — int
  • bc_sleep — int
  • device_ip — VARCHAR
  • server_ip — VARCHAR
  • gateway — VARCHAR
  • mask — VARCHAR
  • tdma — VARCHAR
  • port — VARCHAR

삭제여부 (TB_ERP_DEL)

  • mgt_id — int
  • delete_status — VARCHAR
  • delete_date — DATE
  • delete_reason — TEXT

슬립 설정 (TB_ERP_SLP_CONF)

  • mgt_id — int — NOT NULL
  • sleep_mode — VARCHAR
  • sleep_threshold — VARCHAR
  • sleep_interval — int
  • bc_ver — int
  • bc_period — int
  • bc_sleep — int

타입 (TB_ERP_TYPE)

  • type_code — VARCHAR
  • type_name — VARCHAR