jg_wzjl_scheduled_job/db/sql/meter_work_monitor.sql

CREATE TABLE "LIMS"."METER_WORK_MONITOR" 
   (	"POINT_NO" VARCHAR2(20) NOT NULL ENABLE, 
	"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,0) 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,0) 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), 
	 CONSTRAINT "MONITOR_PK" PRIMARY KEY ("POINT_NO")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IMS"  ENABLE, 
	 CONSTRAINT "SYS_C009706" CHECK ("POINT_NO" IS NOT NULL) ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IMS"   NO INMEMORY ;
  CREATE UNIQUE INDEX "LIMS"."MONITOR_PK" ON "LIMS"."METER_WORK_MONITOR" ("POINT_NO") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IMS" ;
  ALTER TABLE "LIMS"."METER_WORK_MONITOR" MODIFY ("POINT_NO" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."METER_WORK_MONITOR" ADD CONSTRAINT "MONITOR_PK" PRIMARY KEY ("POINT_NO")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IMS"  ENABLE;
  ALTER TABLE "LIMS"."METER_WORK_MONITOR" ADD CONSTRAINT "SYS_C009706" CHECK ("POINT_NO" IS NOT NULL) ENABLE;
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."POINT_NO" IS '计量点编号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."POINT_NAME" IS '计量点';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_WGT" IS '验证重量  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_CARNO" IS '验证车号  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_TARE_TIME" IS '验证回皮时间  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_TIME_INTERVAL" IS '验证时间间隔  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_PARK_STATUS" IS '验证对射(实时数据库停车位置)  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_EXCEED_WGT" IS '验证危化品超重  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_PREDICTION_DIFF" IS '验证毛皮超差  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_FLAG" IS '是否有效 1有效 0无效';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_MAT_TIME" IS '验证物料可计量时间段 0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."CAR_MONITOR" IS '是否进行车号修正 0不修正 1修正';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."CAR_MONITOR_LVL" IS '车号修正级别1-3（1=修正1位；2=修正连续的2位；3=修正连续的3位）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_HELP" IS '0未呼叫，1呼叫待接听，2呼叫已接听';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_TAKE_OVER" IS '0智能终端，1远程计量呼叫(派位阶段)，2远程接管';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."LED_WRITER" IS '写入LED的值';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."PRINT_NUM" IS '打印纸张';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."COLLECTION_CODE" IS '与实时库对应的采集点';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_OVER_WGT" IS '有值时为计量完成';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."USER_NO" IS '接管终端用户';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."MONITOR_USER_NO" IS '监控用户';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."SET_CAR" IS '重置车号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."LED_KEEP" IS '0不读取LED_WRITER的值，1读取';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."RFID_CAR" IS 'rfid车号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."PHOTO_CAR" IS '抓拍车号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."SCAN_CAR" IS '扫描车号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."EDIT_CAR" IS '修正车号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."CAR_ERR" IS '车号异常 0正常 1异常';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."WGT_ERR" IS '重量异常 0正常 1异常';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."LAST_TIME" IS '最后在线时间，由于时间不一定准，所以使用旧数据时间与当前时间比如果连续30次相同则认为掉线';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."STOP_OVER_TIME" IS '0正常 1停留超时';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."MSG_INFO" IS '现场终端提示信息';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."WGT" IS '现场显示的重量';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_REMOTE" IS '是否是监控界面点击的远程 0否 1是';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."WEIGH_INSTRUMENT_MODEL" IS '称重仪表型号';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."WEIGH_INSTRUMENT_PARAM" IS '称重仪表参数';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."MOXA_IP" IS 'MOXA卡IP';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."MOXA_PORT" IS 'MOXA卡端口';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_LIANDA" IS '验证联达  0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_OPEN_SCANNING" IS '现场扫码器是否正常连接(0=连接异常，1=连接正常)';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_IS_PRE" IS '委托异常  0正常  1异常';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."USER_IP" IS '接管用户IP';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."POWER_STATE" IS '衡器电源状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."DVR_STATE" IS '硬盘录像机状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."MOXA_STATE" IS 'MOXA状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."PLC_STATE" IS 'PLC状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."LEFT_INFRARED_RAY_STATE" IS '红外对射状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."RIGHT_INFRARED_RAY_STATE" IS '红外对射状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."AMPLIFIER_STATE" IS '功放状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."LAMP_STATE" IS '照明灯状态（0关闭的 1打开的）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."SPOT_TYPE_NO" IS '站点类型';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."RED_GREEN_LIGHT_STATE" IS '红绿灯状态（0绿灯 1红灯）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."FRONT_INFRARED_RAY_STATE" IS '前红外光栅状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."REAR_INFRARED_RAY_STATE" IS '后红外光栅状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."RFID_STATE" IS 'rfid状态（0正常 1异常）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."VALID_AREA" IS '允许异地结净     0不验证  1验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."WEIGHT_STATUS" IS '重量是否稳定     0不稳定    1稳定';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."FERROALLOY_CONFIRM" IS '铁合金确认       0未确认  1已确认';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."FERROALLOY_RESULT" IS '铁合金确认结果 0保存失败 1保存成功';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."ZERO_STATE" IS '零点报警         0不报警  1报警';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."ZERO_WEIGHT" IS '零点重量';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_ZERO_STATE" IS '验证零点报警    0:不验证   1:验证';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_VALID_SCAN" IS '允许扫码计量（0：允许；1：不允许，数据库默认为1）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."IS_ENABLE_SOUND" IS '是否播放声音（0：不播放；1：播放）';
   COMMENT ON COLUMN "LIMS"."METER_WORK_MONITOR"."PHOTO_CAR2" IS '抓拍车号2';
   COMMENT ON TABLE "LIMS"."METER_WORK_MONITOR"  IS '计量监控表';