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