--20260624 ALTER TABLE "PRESSURE2_DYNAMIC_TB" ADD COLUMN "SKIP_PAGE_COUNT" INT DEFAULT (0); COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB"."SKIP_PAGE_COUNT" IS '跳过的页码数'; --已加 --20260630 ALTER TABLE "PRESSURE2_DYNAMIC_TB" ADD COLUMN "IMAGE_OFFSET" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB"."IMAGE_OFFSET" IS '图片偏移量,格式:x,y'; ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "IS_SIGN" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."IS_SIGN" IS '是否需要签名'; ALTER TABLE "PRESSURE2_INSPECTION_NATURE_TEMPLATE" ADD COLUMN "DEFAULT_COUNT" INT DEFAULT (1); COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE"."DEFAULT_COUNT" IS '默认数量'; ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK" ADD COLUMN "DEFAULT_COUNT" INT; COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK"."DEFAULT_COUNT" IS '默认数量'; ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK" ADD COLUMN "DEFAULT_COUNT" INT; COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK"."DEFAULT_COUNT" IS '默认数量'; ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK" MODIFY "DEFAULT_COUNT" INT DEFAULT (1) NULL; ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK" MODIFY "DEFAULT_COUNT" INT DEFAULT (1) NULL; ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "IS_FEE" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."IS_FEE" IS '是否收费'; --已加 --20260627 ALTER TABLE "PRESSURE_TASK_ORDER" ADD COLUMN "SCHEME_ENTER_TIME" DATETIME(6); ALTER TABLE "PRESSURE_TASK_ORDER" ADD COLUMN "SCHEME_APPROVAL_TIME" VARCHAR(50); ALTER TABLE "PRESSURE_TASK_ORDER" ADD COLUMN "SCHEME_RATIFY_TIME" VARCHAR(50); COMMENT ON COLUMN "PRESSURE_TASK_ORDER"."SCHEME_ENTER_TIME" IS '检验方案录入时间'; COMMENT ON COLUMN "PRESSURE_TASK_ORDER"."SCHEME_APPROVAL_TIME" IS '检验方案审核时间'; COMMENT ON COLUMN "PRESSURE_TASK_ORDER"."SCHEME_RATIFY_TIME" IS '检验方案审批时间'; ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "SCHEME_ENTER_TIME" DATETIME(6); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "SCHEME_APPROVAL_TIME" VARCHAR(50); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "SCHEME_RATIFY_TIME" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."SCHEME_ENTER_TIME" IS '检验方案录入时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."SCHEME_APPROVAL_TIME" IS '检验方案审核时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."SCHEME_RATIFY_TIME" IS '检验方案审批时间'; --已加 --20260629 ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT" ADD COLUMN "RECYCLE_EXPIRE_DATE" DATETIME(6); COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT"."RECYCLE_EXPIRE_DATE" IS '检验意见通知书回收截止时间'; ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT" ADD COLUMN "RECYCLE_EXPIRE_DATE" DATETIME(6); COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT"."RECYCLE_EXPIRE_DATE" IS '检验意见通知书回收截止时间'; --已加 --20260630 ALTER TABLE "PRESSURE2_ORDER_REPORT" ADD COLUMN "ACCEPT_ORDER_NO" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_ORDER_REPORT"."ACCEPT_ORDER_NO" IS '受理单/服务单编号'; ALTER TABLE "PRESSURE_APPOINTMENT_CONFIRM_ORDER" ADD COLUMN "ANNOTATOR_DATE" DATETIME(6); ALTER TABLE "PRESSURE_APPOINTMENT_CONFIRM_ORDER" ADD COLUMN "ANNOTATOR_ID" VARCHAR(64); ALTER TABLE "PRESSURE_APPOINTMENT_CONFIRM_ORDER" ADD COLUMN "ANNOTATOR_NAME" VARCHAR(64); COMMENT ON COLUMN "PRESSURE_APPOINTMENT_CONFIRM_ORDER"."ANNOTATOR_DATE" IS '备注日期时间'; COMMENT ON COLUMN "PRESSURE_APPOINTMENT_CONFIRM_ORDER"."ANNOTATOR_ID" IS '备注人ID'; COMMENT ON COLUMN "PRESSURE_APPOINTMENT_CONFIRM_ORDER"."ANNOTATOR_NAME" IS '备注人名称'; ALTER TABLE "PRESSURE2_DYNAMIC_TB" ADD COLUMN "IMAGE_OFFSET" VARCHAR(150); COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB"."IMAGE_OFFSET" IS '偏移量'; --已加