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 '计量监控表';