jg_wzjl_api/db/sql/monitor_data.sql

prompt PL/SQL Developer import file
prompt Created on 2026年7月22日 by 花宝男朋友
set feedback off
set define off
prompt Creating METER_WORK_MONITOR...
create table METER_WORK_MONITOR
(
  point_no                 VARCHAR2(20) not null,
  point_name               VARCHAR2(40),
  valid_wgt                VARCHAR2(1) default 1,
  valid_carno              VARCHAR2(1) default 1,
  valid_tare_time          VARCHAR2(1) default 1,
  valid_time_interval      VARCHAR2(1) default 1,
  valid_park_status        VARCHAR2(1) default 1,
  valid_exceed_wgt         VARCHAR2(1) default 1,
  valid_prediction_diff    VARCHAR2(1) default 1,
  valid_flag               VARCHAR2(1) default 1,
  valid_mat_time           VARCHAR2(1) default 1,
  car_monitor              VARCHAR2(1) default 0,
  car_monitor_lvl          NUMBER default 0,
  is_help                  VARCHAR2(1) default 0,
  is_take_over             VARCHAR2(1) default 0,
  led_writer               VARCHAR2(200),
  print_num                NUMBER(4) default 0,
  collection_code          VARCHAR2(20),
  is_over_wgt              VARCHAR2(40) default 0,
  user_no                  VARCHAR2(20),
  monitor_user_no          VARCHAR2(20),
  set_car                  VARCHAR2(20),
  led_keep                 VARCHAR2(1) default 0,
  rfid_car                 VARCHAR2(20),
  photo_car                VARCHAR2(20),
  scan_car                 VARCHAR2(20),
  edit_car                 VARCHAR2(20),
  car_err                  VARCHAR2(1) default 0,
  wgt_err                  VARCHAR2(1) default 0,
  last_time                DATE,
  stop_over_time           VARCHAR2(1),
  msg_info                 VARCHAR2(400),
  wgt                      NUMBER(10) default 0,
  is_remote                VARCHAR2(1),
  weigh_instrument_model   VARCHAR2(60),
  weigh_instrument_param   VARCHAR2(100),
  moxa_ip                  VARCHAR2(20),
  moxa_port                VARCHAR2(10),
  valid_lianda             VARCHAR2(1) default 1,
  is_open_scanning         VARCHAR2(1) default 0,
  valid_is_pre             VARCHAR2(1) default 0,
  user_ip                  VARCHAR2(30),
  power_state              VARCHAR2(1) default 0,
  dvr_state                VARCHAR2(1) default 0,
  moxa_state               VARCHAR2(1) default 0,
  plc_state                VARCHAR2(1) default 0,
  left_infrared_ray_state  VARCHAR2(1) default 0,
  right_infrared_ray_state VARCHAR2(1) default 0,
  amplifier_state          VARCHAR2(1) default 0,
  lamp_state               VARCHAR2(1) default 0,
  spot_type_no             VARCHAR2(20) default 0,
  red_green_light_state    VARCHAR2(1) default 0,
  front_infrared_ray_state VARCHAR2(1) default 0,
  rear_infrared_ray_state  VARCHAR2(1) default 0,
  rfid_state               VARCHAR2(1) default 0,
  valid_area               VARCHAR2(1) default 1,
  weight_status            VARCHAR2(2) default 0,
  ferroalloy_confirm       VARCHAR2(1) default 0,
  ferroalloy_result        VARCHAR2(200),
  zero_state               VARCHAR2(1) default 0,
  zero_weight              NUMBER,
  is_zero_state            VARCHAR2(1) default 1,
  is_valid_scan            VARCHAR2(1) default 1,
  is_enable_sound          VARCHAR2(1) default 1,
  photo_car2               VARCHAR2(20)
)
;
comment on table METER_WORK_MONITOR
  is '计量监控表';
comment on column METER_WORK_MONITOR.point_no
  is '计量点编号';
comment on column METER_WORK_MONITOR.point_name
  is '计量点';
comment on column METER_WORK_MONITOR.valid_wgt
  is '验证重量  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_carno
  is '验证车号  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_tare_time
  is '验证回皮时间  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_time_interval
  is '验证时间间隔  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_park_status
  is '验证对射(实时数据库停车位置)  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_exceed_wgt
  is '验证危化品超重  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_prediction_diff
  is '验证毛皮超差  0不验证  1验证';
comment on column METER_WORK_MONITOR.valid_flag
  is '是否有效 1有效 0无效';
comment on column METER_WORK_MONITOR.valid_mat_time
  is '验证物料可计量时间段 0不验证  1验证';
comment on column METER_WORK_MONITOR.car_monitor
  is '是否进行车号修正 0不修正 1修正';
comment on column METER_WORK_MONITOR.car_monitor_lvl
  is '车号修正级别1-3（1=修正1位；2=修正连续的2位；3=修正连续的3位）';
comment on column METER_WORK_MONITOR.is_help
  is '0未呼叫，1呼叫待接听，2呼叫已接听';
comment on column METER_WORK_MONITOR.is_take_over
  is '0智能终端，1远程计量呼叫(派位阶段)，2远程接管';
comment on column METER_WORK_MONITOR.led_writer
  is '写入LED的值';
comment on column METER_WORK_MONITOR.print_num
  is '打印纸张';
comment on column METER_WORK_MONITOR.collection_code
  is '与实时库对应的采集点';
comment on column METER_WORK_MONITOR.is_over_wgt
  is '有值时为计量完成';
comment on column METER_WORK_MONITOR.user_no
  is '接管终端用户';
comment on column METER_WORK_MONITOR.monitor_user_no
  is '监控用户';
comment on column METER_WORK_MONITOR.set_car
  is '重置车号';
comment on column METER_WORK_MONITOR.led_keep
  is '0不读取LED_WRITER的值，1读取';
comment on column METER_WORK_MONITOR.rfid_car
  is 'rfid车号';
comment on column METER_WORK_MONITOR.photo_car
  is '抓拍车号';
comment on column METER_WORK_MONITOR.scan_car
  is '扫描车号';
comment on column METER_WORK_MONITOR.edit_car
  is '修正车号';
comment on column METER_WORK_MONITOR.car_err
  is '车号异常 0正常 1异常';
comment on column METER_WORK_MONITOR.wgt_err
  is '重量异常 0正常 1异常';
comment on column METER_WORK_MONITOR.last_time
  is '最后在线时间，由于时间不一定准，所以使用旧数据时间与当前时间比如果连续30次相同则认为掉线';
comment on column METER_WORK_MONITOR.stop_over_time
  is '0正常 1停留超时';
comment on column METER_WORK_MONITOR.msg_info
  is '现场终端提示信息';
comment on column METER_WORK_MONITOR.wgt
  is '现场显示的重量';
comment on column METER_WORK_MONITOR.is_remote
  is '是否是监控界面点击的远程 0否 1是';
comment on column METER_WORK_MONITOR.weigh_instrument_model
  is '称重仪表型号';
comment on column METER_WORK_MONITOR.weigh_instrument_param
  is '称重仪表参数';
comment on column METER_WORK_MONITOR.moxa_ip
  is 'MOXA卡IP';
comment on column METER_WORK_MONITOR.moxa_port
  is 'MOXA卡端口';
comment on column METER_WORK_MONITOR.valid_lianda
  is '验证联达  0不验证  1验证';
comment on column METER_WORK_MONITOR.is_open_scanning
  is '现场扫码器是否正常连接(0=连接异常，1=连接正常)';
comment on column METER_WORK_MONITOR.valid_is_pre
  is '委托异常  0正常  1异常';
comment on column METER_WORK_MONITOR.user_ip
  is '接管用户IP';
comment on column METER_WORK_MONITOR.power_state
  is '衡器电源状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.dvr_state
  is '硬盘录像机状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.moxa_state
  is 'MOXA状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.plc_state
  is 'PLC状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.left_infrared_ray_state
  is '红外对射状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.right_infrared_ray_state
  is '红外对射状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.amplifier_state
  is '功放状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.lamp_state
  is '照明灯状态（0关闭的 1打开的）';
comment on column METER_WORK_MONITOR.spot_type_no
  is '站点类型';
comment on column METER_WORK_MONITOR.red_green_light_state
  is '红绿灯状态（0绿灯 1红灯）';
comment on column METER_WORK_MONITOR.front_infrared_ray_state
  is '前红外光栅状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.rear_infrared_ray_state
  is '后红外光栅状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.rfid_state
  is 'rfid状态（0正常 1异常）';
comment on column METER_WORK_MONITOR.valid_area
  is '允许异地结净     0不验证  1验证';
comment on column METER_WORK_MONITOR.weight_status
  is '重量是否稳定     0不稳定    1稳定';
comment on column METER_WORK_MONITOR.ferroalloy_confirm
  is '铁合金确认       0未确认  1已确认';
comment on column METER_WORK_MONITOR.ferroalloy_result
  is '铁合金确认结果 0保存失败 1保存成功';
comment on column METER_WORK_MONITOR.zero_state
  is '零点报警         0不报警  1报警';
comment on column METER_WORK_MONITOR.zero_weight
  is '零点重量';
comment on column METER_WORK_MONITOR.is_zero_state
  is '验证零点报警    0:不验证   1:验证';
comment on column METER_WORK_MONITOR.is_valid_scan
  is '允许扫码计量（0：允许；1：不允许，数据库默认为1）';
comment on column METER_WORK_MONITOR.is_enable_sound
  is '是否播放声音（0：不播放；1：播放）';
comment on column METER_WORK_MONITOR.photo_car2
  is '抓拍车号2';
alter table METER_WORK_MONITOR
  add constraint MONITOR_PK primary key (POINT_NO);

prompt Disabling triggers for METER_WORK_MONITOR...
alter table METER_WORK_MONITOR disable all triggers;
prompt Loading METER_WORK_MONITOR...
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0038', '吉瑞渣厂150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR18', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:08', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT1111', '实训室', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR50', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('06-08-2025 13:26:36', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.99', '0', '1', '1', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0128', '东铝二期氧化铝库1号汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR23', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:06', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.107', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0129', '东铝二期氧化铝库2号汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR24', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:04', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.99', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0104', '东铝二期120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR12', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:12', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.101', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JTS0001', '镜铁山150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR68', null, null, null, null, '0', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:14', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.102.0.166', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0041', '东铝一期120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR15', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:07', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0001', '1#公路汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR01', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:07', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0006', '8#门汽车衡西秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR05', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0005', '8#门汽车衡东秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR06', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0007', '9#门汽车衡东秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR03', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:06', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0008', '9#门汽车衡西秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR04', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('20-07-2026 15:47:04', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0010', '不锈钢汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR17', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:08', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0032', '汇丰不锈钢工业园150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR21', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 18:28:25', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.3.78', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0138', '物流园汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR69', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('19-06-2026 02:02:35', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 75, null, null, null, null, null, '1', '0', '0', '10.130.0.103', '0', '0', '0', '0', '0', '0', '0', '1', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '1', 72, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0136', '润源兴源门150t汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR71', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:13', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.100.248.87', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0137', '润源兴源门150t汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR77', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:13', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0135', '润源废钢100t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR73', null, null, null, null, '0', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:12', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0139', '储运新一料场汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR70', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.100.248.87', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0020', '1#公路汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR02', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0034', '5#门汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR08', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('10-07-2026 09:43:54', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.101', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0035', '5#门汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR09', null, null, null, null, '1', null, '甘B02800F', null, null, '0', '0', to_date('22-07-2026 19:03:59', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 79800, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('LX0001', '陇西50t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR60', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:10', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 30780, null, null, null, null, null, '1', '0', '0', '10.130.2.229', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', '甘JGL005');
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('LX0002', '陇西100t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR61', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('03-06-2026 07:48:03', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.2.247', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('LX0003', '陇西120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR62', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:03', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.2.145', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JTS0002', '铜选厂120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR67', null, null, '0015780', null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:12', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.230.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0047', '嘉北4#门汽车衡东秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR10', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:10', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0052', '吉瑞200t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR19', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:04', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0023', '废钢汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR16', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 11:00:18', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.133.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0026', '铁合金汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', '走', 0, 'CAR14', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('28-06-2026 09:05:51', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0027', '铁合金汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR13', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:10', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0031', '200万料场汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR07', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('25-06-2026 10:33:57', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0060', '葫芦山汽车衡', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', 0, '0', '0', null, 0, 'CAR06', '20220825174721437924', null, 'test01', null, '0', null, null, null, null, '0', '0', to_date('21-07-2022 09:17:45', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.97', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', null, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0048', '嘉北4#门汽车衡西秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR11', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:06', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2)
values ('JT0127', '汇丰公司150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR22', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.100.248.87', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null);
commit;
prompt 35 records loaded
prompt Enabling triggers for METER_WORK_MONITOR...
alter table METER_WORK_MONITOR enable all triggers;
set feedback on
set define on
prompt Done.