-- 20260421 增加字段 ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_USER" ADD COLUMN "DATE" TIMESTAMP(6); COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_USER"."DATE" IS '排期时间'; ALTER TABLE "PRESSURE2_DYNAMIC_TB_VAL" MODIFY "VAL_VALUE" TEXT NULL; --20260430 ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "IS_ISSUE_REPORT" BIT; ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "USE_LOGO" VARCHAR(500); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "USE_LOGO_TIME" DATETIME(6); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "ISSUE_URL" VARCHAR(500); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "IS_PUSH_PLATFORM" INT DEFAULT (0); COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."IS_PUSH_PLATFORM" IS '是否推送服务平台(0=否，1=是)'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."ISSUE_URL" IS '出具报告'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."USE_LOGO" IS '使用标志'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."USE_LOGO_TIME" IS '使用标志发放时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."IS_ISSUE_REPORT" IS '出具报告'; ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "IS_ISSUE_REPORT" BIT; ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "USE_LOGO" VARCHAR(500); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "USE_LOGO_TIME" DATETIME(6); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "ISSUE_URL" VARCHAR(500); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "IS_PUSH_PLATFORM" INT DEFAULT (0); COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."IS_PUSH_PLATFORM" IS '是否推送服务平台(0=否，1=是)'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."ISSUE_URL" IS '出具报告'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."USE_LOGO" IS '使用标志'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."USE_LOGO_TIME" IS '使用标志发放时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."IS_ISSUE_REPORT" IS '出具报告'; CREATE TABLE "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD" ( "ID" VARCHAR2(64) NOT NULL, "EQUIP_IDS" TEXT, "EQUIP_CODES" TEXT, "USE_UNIT_ID" VARCHAR2(64), "USE_UNIT_NAME" VARCHAR2(255), "REASON_DIST" TEXT, "CHECK_DATE" DATE, "AUDIT_STATUS" INT DEFAULT 0, "REJECTIVE_DIST" TEXT, "SUBMIT_ID" VARCHAR2(64), "SUBMIT_TIME" TIMESTAMP(6), "ORDER_ID" VARCHAR2(64), "ISSUE_REPORT_OBJECT_JSON" TEXT, "REPORT_AUDIT_ID" VARCHAR2(64), "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD" IS '管道电子报告审核记录'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."EQUIP_IDS" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."EQUIP_CODES" IS '设备注册代码'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."USE_UNIT_ID" IS '使用单位id'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."USE_UNIT_NAME" IS '使用单位名称'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."REASON_DIST" IS '发放原因'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."AUDIT_STATUS" IS '审核状态(0=审核中,1=通过,2=拒绝)'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."REJECTIVE_DIST" IS '拒绝原因'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."ISSUE_REPORT_OBJECT_JSON" IS '出具报告对象JSON'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."REPORT_AUDIT_ID" IS '审核人'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_ELECTRONIC_REPORT_AUDIT_RECORD"."DELETED" IS '是否删除'; CREATE TABLE "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD" ( "ID" VARCHAR(50) NOT NULL, "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "ORDER_ID" VARCHAR(64), "FOLLOW_ID" VARCHAR(50), "REMARK" VARCHAR(1000), "FOLLOW_TIME" DATETIME(6), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD" IS '管道任务单跟进记录'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."ID" IS 'ID'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."ORDER_ID" IS '任务单Id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."FOLLOW_ID" IS '跟进人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_FOLLOW_RECORD"."FOLLOW_TIME" IS '跟进时间'; CREATE TABLE "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT" ( "ID" VARCHAR(64), "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "CHECKLIST_TYPE" INT, "ORDER_ID" VARCHAR(64), "ISSUE_METHOD" INT, "RECIPIENT" VARCHAR(100), "RECIPIENT_PHONE" VARCHAR(50), "RECIPIENT_ADDRESS" VARCHAR(500), "TRACKING_NUMBER" VARCHAR(100), "TRACKING_COMPANY" VARCHAR(100), "REMARK" VARCHAR(500), "COPY_NUMBER" INT, "BUSINESS_MAN" VARCHAR(64), "OTHER_METHOD" VARCHAR(500), "REPORT_TYPE" INT, "MINI_PROGRAM_PUSH" BIT, "EMAIL_PUSH" BIT, "EMAIL" VARCHAR(100), "MINI_PROGRAM_ADMIN" BIT, "MINI_PROGRAM_SUB_ACCOUNT" BIT, "REPORT_NUM" INT, "RECIPIENT_MEMBER_USER_ID" VARCHAR2(64), "ORDER_ITEM_REPORT_ID" VARCHAR2(64), "BUSINESS_TYPE" BIT DEFAULT 0) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT" IS '管道任务单出具报告记录'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."CHECKLIST_TYPE" IS '报告清单类型 100 全部报告，200 部分报告'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."ISSUE_METHOD" IS '出具方式 100 快递邮寄 200 业务员送达 300 线下领取 400 其他'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."RECIPIENT" IS '接收/领取人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."RECIPIENT_PHONE" IS '接收/领取电话'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."RECIPIENT_ADDRESS" IS '接收地址'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."TRACKING_NUMBER" IS '邮寄单号'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."TRACKING_COMPANY" IS '快递公司'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."COPY_NUMBER" IS '一式几份'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."BUSINESS_MAN" IS '业务员'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."OTHER_METHOD" IS '其他方式描述'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."REPORT_TYPE" IS '报告类型 100实体报告 200电子报告'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."MINI_PROGRAM_PUSH" IS '小程序推送'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."EMAIL_PUSH" IS '邮箱推送'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."EMAIL" IS '邮箱'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."MINI_PROGRAM_ADMIN" IS '小程序推送-主帐号管理员'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."MINI_PROGRAM_SUB_ACCOUNT" IS '小程序推送-子账号'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."REPORT_NUM" IS '报告数量'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."RECIPIENT_MEMBER_USER_ID" IS '小程序推送-接收人平台用户信息id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."ORDER_ITEM_REPORT_ID" IS '任务单设备关联报告id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT"."BUSINESS_TYPE" IS '业务类型(0=出具报告,1=打印发证)'; CREATE TABLE "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM" ( "ID" VARCHAR(64), "ITEM_ID" VARCHAR(64), "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "ISSUE_REPORT_ID" VARCHAR(64)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM" IS '管道任务单出具报告记录-设备项'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."ITEM_ID" IS '任务单设备'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."DELETED" IS '删除类型'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ISSUE_REPORT_ITEM"."ISSUE_REPORT_ID" IS 'ID'; CREATE TABLE "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD" ( "ID" VARCHAR2(64) NOT NULL, "EQUIP_IDS" TEXT, "EQUIP_CODES" TEXT, "USE_UNIT_ID" VARCHAR2(64), "USE_UNIT_NAME" VARCHAR2(255), "REASON_DIST" TEXT, "CHECK_DATE" DATE, "AUDIT_STATUS" INT DEFAULT 0, "REJECTIVE_DIST" TEXT, "SUBMIT_ID" VARCHAR2(64), "SUBMIT_TIME" TIMESTAMP(6), "ORDER_ID" VARCHAR2(64), "ISSUE_REPORT_OBJECT_JSON" TEXT, "REPORT_AUDIT_ID" VARCHAR2(64), "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD" IS '锅炉电子报告审核记录'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."EQUIP_IDS" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."EQUIP_CODES" IS '设备注册代码'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."USE_UNIT_ID" IS '使用单位id'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."USE_UNIT_NAME" IS '使用单位名称'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."REASON_DIST" IS '发放原因'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."AUDIT_STATUS" IS '审核状态(0=审核中,1=通过,2=拒绝)'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."REJECTIVE_DIST" IS '拒绝原因'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."ISSUE_REPORT_OBJECT_JSON" IS '出具报告对象JSON'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."REPORT_AUDIT_ID" IS '审核人'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_ELECTRONIC_REPORT_AUDIT_RECORD"."DELETED" IS '是否删除'; CREATE TABLE "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD" ( "ID" VARCHAR(50) NOT NULL, "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "ORDER_ID" VARCHAR(64), "FOLLOW_ID" VARCHAR(50), "REMARK" VARCHAR(1000), "FOLLOW_TIME" DATETIME(6), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD" IS '锅炉任务单跟进记录'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."ID" IS 'ID'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."ORDER_ID" IS '任务单Id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."FOLLOW_ID" IS '跟进人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_FOLLOW_RECORD"."FOLLOW_TIME" IS '跟进时间'; CREATE TABLE "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT" ( "ID" VARCHAR(64), "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "CHECKLIST_TYPE" INT, "ORDER_ID" VARCHAR(64), "ISSUE_METHOD" INT, "RECIPIENT" VARCHAR(100), "RECIPIENT_PHONE" VARCHAR(50), "RECIPIENT_ADDRESS" VARCHAR(500), "TRACKING_NUMBER" VARCHAR(100), "TRACKING_COMPANY" VARCHAR(100), "REMARK" VARCHAR(500), "COPY_NUMBER" INT, "BUSINESS_MAN" VARCHAR(64), "OTHER_METHOD" VARCHAR(500), "REPORT_TYPE" INT, "MINI_PROGRAM_PUSH" BIT, "EMAIL_PUSH" BIT, "EMAIL" VARCHAR(100), "MINI_PROGRAM_ADMIN" BIT, "MINI_PROGRAM_SUB_ACCOUNT" BIT, "REPORT_NUM" INT, "RECIPIENT_MEMBER_USER_ID" VARCHAR2(64), "ORDER_ITEM_REPORT_ID" VARCHAR2(64), "BUSINESS_TYPE" BIT DEFAULT 0) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT" IS '锅炉任务单出具报告记录'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."CHECKLIST_TYPE" IS '报告清单类型 100 全部报告，200 部分报告'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."ISSUE_METHOD" IS '出具方式 100 快递邮寄 200 业务员送达 300 线下领取 400 其他'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."RECIPIENT" IS '接收/领取人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."RECIPIENT_PHONE" IS '接收/领取电话'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."RECIPIENT_ADDRESS" IS '接收地址'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."TRACKING_NUMBER" IS '邮寄单号'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."TRACKING_COMPANY" IS '快递公司'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."COPY_NUMBER" IS '一式几份'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."BUSINESS_MAN" IS '业务员'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."OTHER_METHOD" IS '其他方式描述'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."REPORT_TYPE" IS '报告类型 100实体报告 200电子报告'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."MINI_PROGRAM_PUSH" IS '小程序推送'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."EMAIL_PUSH" IS '邮箱推送'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."EMAIL" IS '邮箱'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."MINI_PROGRAM_ADMIN" IS '小程序推送-主帐号管理员'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."MINI_PROGRAM_SUB_ACCOUNT" IS '小程序推送-子账号'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."REPORT_NUM" IS '报告数量'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."RECIPIENT_MEMBER_USER_ID" IS '小程序推送-接收人平台用户信息id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."ORDER_ITEM_REPORT_ID" IS '任务单设备关联报告id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT"."BUSINESS_TYPE" IS '业务类型(0=出具报告,1=打印发证)'; CREATE TABLE "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM" ( "ID" VARCHAR(64), "ITEM_ID" VARCHAR(64), "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "ISSUE_REPORT_ID" VARCHAR(64)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM" IS '锅炉任务单出具报告记录-设备项'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."ITEM_ID" IS '任务单设备'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."DELETED" IS '删除类型'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ISSUE_REPORT_ITEM"."ISSUE_REPORT_ID" IS 'ID'; CREATE TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT" ( "ID" VARCHAR(50) NOT NULL, "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "ITEM_ID" VARCHAR(64), "TYPE" INT, "REASON" VARCHAR(100), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT" IS '锅炉设备打印记录'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."ID" IS 'ID'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."ITEM_ID" IS 'ITEM_ID'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."TYPE" IS '100 打印 200 下载PDF'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_PRINT"."REASON" IS '原因'; CREATE TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT" ( "ID" VARCHAR(50) NOT NULL, "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0, "ITEM_ID" VARCHAR(64), "TYPE" INT, "REASON" VARCHAR(100), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT" IS '管道设备打印记录'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."ID" IS 'ID'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."ITEM_ID" IS 'ITEM_ID'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."TYPE" IS '100 打印 200 下载PDF'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_PRINT"."REASON" IS '原因'; --20260508 ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING" ADD COLUMN "SOURCE_ID" VARCHAR(64); COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING"."SOURCE_ID" IS '复制行的源id'; CREATE TABLE "PRESSURE2_USER_TEMPLATE_LIBRARY" ( "ID" VARCHAR2(64) NOT NULL, "USER_ID" VARCHAR2(64) NOT NULL, "TEMPLATE_ID" VARCHAR2(64) NOT NULL, "NAME" VARCHAR2(255) NOT NULL, "DEFAULT_JSON" TEXT, "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, "TEMPLATE_TYPE" VARCHAR2(255), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_USER_TEMPLATE_LIBRARY" IS '用户操作指导书模板库'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."USER_ID" IS '用户id'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."TEMPLATE_ID" IS '模版id'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."NAME" IS '模版名称'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."DEFAULT_JSON" IS '模版默认json'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_USER_TEMPLATE_LIBRARY"."TEMPLATE_TYPE" IS '模版类型'; CREATE TABLE "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE" ( "ID" VARCHAR2(64) NOT NULL, "USER_ID" VARCHAR2(64) NOT NULL, "TEMPLATE_ID" VARCHAR2(64) NOT NULL, "NAME" VARCHAR2(255) NOT NULL, "DEFAULT_VALUE" TEXT, "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE" IS '用户壁厚测定点数模版'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."USER_ID" IS '用户id'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."TEMPLATE_ID" IS '模版id'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."NAME" IS '模版名称'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."DEFAULT_VALUE" IS '模版值'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_USER_WALL_THICKNESS_TEMPLATE"."DELETED" IS '是否删除'; CREATE TABLE PRESSURE2_EQUIP_BOILER_PRESSURE_PART ( ID VARCHAR(64) NOT NULL, BOILER_ID VARCHAR(64) NOT NULL, PART_TYPE VARCHAR(64), PART_NAME VARCHAR(255), SPECIFICATION VARCHAR(128), MATERIAL VARCHAR(128), REMARK VARCHAR(500), CREATOR VARCHAR(64), CREATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UPDATER VARCHAR(64), UPDATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, DELETED CHAR(1) DEFAULT '0', PRIMARY KEY (ID) ); CREATE SEQUENCE PRESSURE2_EQUIP_BOILER_PRESSURE_PART_SEQ START WITH 1 INCREMENT BY 1; ---- 以上已加 ALTER TABLE "PRESSURE_TASK_ORDER_SIGN_FILE" ADD COLUMN "EQUIP_MAIN_TYPE" VARCHAR(50); COMMENT ON COLUMN "PRESSURE_TASK_ORDER_SIGN_FILE"."EQUIP_MAIN_TYPE" IS '设备类型(容器=100,锅炉=200,管道=300)'; --20260512 ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT" ADD COLUMN "SIGN_TIME" DATETIME(0); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT" ADD COLUMN "RECTIFICATION_TIME" DATETIME(6); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT" ADD COLUMN "MP_SEND_STATUS" INTEGER DEFAULT (4); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT" ADD COLUMN "FINISH_UPLOAD_TIME" DATETIME(6); COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT"."FINISH_UPLOAD_TIME" IS '报告办结上传时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT"."MP_SEND_STATUS" IS '公众号推送状态'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT"."SIGN_TIME" IS '签名时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT"."RECTIFICATION_TIME" IS '整改材料提交时间（回收时间）'; ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT" ADD COLUMN "SIGN_TIME" DATETIME(0); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT" ADD COLUMN "RECTIFICATION_TIME" DATETIME(6); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT" ADD COLUMN "MP_SEND_STATUS" INTEGER DEFAULT (4); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT" ADD COLUMN "FINISH_UPLOAD_TIME" DATETIME(6); COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT"."FINISH_UPLOAD_TIME" IS '报告办结上传时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT"."MP_SEND_STATUS" IS '公众号推送状态'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT"."SIGN_TIME" IS '签名时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT"."RECTIFICATION_TIME" IS '整改材料提交时间（回收时间）'; --删除表 DROP TABLE "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"; CREATE TABLE "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM" ( "ID" VARCHAR(64) NOT NULL, "EQUIP_ID" VARCHAR(64), "REASON" VARCHAR(500), "ORDER_ID" VARCHAR(64), "CREATOR" VARCHAR(100), "CREATE_TIME" DATETIME(6), "UPDATER" VARCHAR(100), "UPDATE_TIME" DATETIME(6), "DELETED" BIT DEFAULT 0, "IS_REPORT_CITY" BIT, "UNIT_CODE" VARCHAR(100), "UNIT_NAME" VARCHAR(500), "STATUS" INT DEFAULT 100, "REMARK" VARCHAR(500), "PROCESS_INSTANCE_ID" VARCHAR(64), "SUBMIT_ID" VARCHAR(50), "SUBMIT_TIME" DATETIME(6), "ORDER_NO" VARCHAR(64), "CHECK_TYPE" INT, "AUDIT_REASON" VARCHAR(500), "CHECK_DATE" DATE, "REPORT_CITY_STATUS" INT DEFAULT 100, "REASON_DICT" VARCHAR(255), "ORDER_TYPE" INT DEFAULT 1, "IS_SUBMIT" BIT DEFAULT 0, "AREA_TYPE" VARCHAR2(5), "EQUIP_DISTRICT" INT, "EQUIP_STREET" INT, "BE_DISTRICT" INT, "REPORT_CITY_USER_ID" VARCHAR2(64), "REPORT_CITY_USER_NAME" VARCHAR2(64), "REPORT_CITY_TIME" TIMESTAMP(6), "PROCESS_STATUS" INT DEFAULT 0, "APPROVAL_ID" VARCHAR2(64), "APPROVAL_TIME" TIMESTAMP(6), "REJECTION_SOURCE" INT, "EQUIP_CODE" VARCHAR(50), "PRODUCT_NO" VARCHAR(50), "EQUIP_STATUS" VARCHAR(32), "CONTACT" VARCHAR(64), "CONTACT_PHONE" VARCHAR(255), "EQUIP_TYPE" VARCHAR(50), "ORDER_ITEM_ID" VARCHAR(50), "MAIN_REPORT_ID" VARCHAR(50), "MAIN_TASK_STATUS" VARCHAR(50), "EQUIP_MAIN_TYPE" INTEGER, "TASK_ORDER_ID" VARCHAR(50), "USE_REGISTER_NO" VARCHAR(64 CHAR), "NEXT_CHECK_DATE" DATE, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM" IS '约检确认单拒绝设备项目'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_ID" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REASON" IS '拒绝原因'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."ORDER_ID" IS '约检确认单id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."IS_REPORT_CITY" IS '是否上报 0 拒绝检验 1 上报市局'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."UNIT_CODE" IS '单位编码'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."STATUS" IS '审核状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."PROCESS_INSTANCE_ID" IS 'bpm 审批id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."ORDER_NO" IS '单号'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."CHECK_TYPE" IS '检验类型'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."AUDIT_REASON" IS '审核原因'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REPORT_CITY_STATUS" IS '上报市局状态 100 未上报市局 200上报市局'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REASON_DICT" IS '原因字典'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."ORDER_TYPE" IS '单据类型 1 约检单 2 受理单 3 任务单'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."IS_SUBMIT" IS '是否提交'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."AREA_TYPE" IS '行政区域类型(all/gz)全国/广州'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_DISTRICT" IS '设备使用地址'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_STREET" IS '设备所在行政区域'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."BE_DISTRICT" IS '设备登记区'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REPORT_CITY_USER_ID" IS '上报市局用户id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REPORT_CITY_USER_NAME" IS '上报市局用户名称'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REPORT_CITY_TIME" IS '上报市局时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."PROCESS_STATUS" IS '处理状态(0=待处理,1=无需处理)'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."APPROVAL_ID" IS '任务单变更审核人id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."APPROVAL_TIME" IS '任务单变更审核时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."REJECTION_SOURCE" IS '拒绝来源(1=窗口拒检,2=检验员拒检,3=客户拒检)'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_CODE" IS '设备代码'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."PRODUCT_NO" IS '产品编号'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_STATUS" IS '运行状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."CONTACT" IS '约检联系人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."CONTACT_PHONE" IS '约检联系人电话'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_TYPE" IS '设备类型'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."ORDER_ITEM_ID" IS '检验ID'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."MAIN_REPORT_ID" IS '主报告ID'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."MAIN_TASK_STATUS" IS '主报告状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."EQUIP_MAIN_TYPE" IS '主设备类型'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."TASK_ORDER_ID" IS '任务单ID'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."USE_REGISTER_NO" IS '使用登记证编号'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_ORDER_REFUSE_ITEM"."NEXT_CHECK_DATE" IS '下次检验日期'; --删除表 DROP TABLE "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"; CREATE TABLE "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM" ( "ID" VARCHAR(64), "EQUIP_ID" VARCHAR(64), "REASON" VARCHAR(500), "ORDER_ID" VARCHAR(64), "CREATOR" VARCHAR(100), "CREATE_TIME" DATETIME(6), "UPDATER" VARCHAR(100), "UPDATE_TIME" DATETIME(6), "DELETED" BIT DEFAULT 0, "NEXT_CHECK_DATE" DATE, "UNIT_CODE" VARCHAR(100), "UNIT_NAME" VARCHAR(500), "STATUS" INT DEFAULT 100, "REMARK" VARCHAR(500), "PROCESS_INSTANCE_ID" VARCHAR(64), "SUBMIT_ID" VARCHAR(50), "SUBMIT_TIME" DATETIME(6), "ORDER_NO" VARCHAR(64), "CHECK_TYPE" INT DEFAULT 100, "AUDIT_REASON" VARCHAR(500), "CHECK_DATE" DATE, "REPORT_CITY_STATUS" INT DEFAULT 100, "REASON_DICT" VARCHAR(255), "ORDER_TYPE" BIT DEFAULT 1, "REFUSE_ID" VARCHAR(50), "BE_DISTRICT" INT, "EQUIP_TYPE" VARCHAR(64 CHAR), "REJECTION_SOURCE" INT, "AREA_TYPE" VARCHAR2(5), "EQUIP_DISTRICT" INT, "EQUIP_STREET" INT, "EQUIP_CODE" VARCHAR(50), "PRODUCT_NO" VARCHAR(50), "EQUIP_STATUS" VARCHAR(32), "EQUIP_MAIN_TYPE" INTEGER, "USE_REGISTER_NO" VARCHAR(64 CHAR), "CONTACT" VARCHAR(64), "CONTACT_PHONE" VARCHAR(255)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM" IS '拒绝年检设备'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_ID" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."REASON" IS '拒绝原因'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."ORDER_ID" IS '约检确认单id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."NEXT_CHECK_DATE" IS '下次检验时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."UNIT_CODE" IS '单位编码'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."STATUS" IS '审核状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."PROCESS_INSTANCE_ID" IS 'bpm 审批id'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."ORDER_NO" IS '单号'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."CHECK_TYPE" IS '检验类型'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."AUDIT_REASON" IS '审核原因'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."REPORT_CITY_STATUS" IS '上报市局状态 100 未上报市局 200上报市局'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."REASON_DICT" IS '字典类型'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."ORDER_TYPE" IS '单据类型 1 约检单 2 受理单 3 任务单'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."REFUSE_ID" IS '拒绝'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."BE_DISTRICT" IS '设备登记区'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_TYPE" IS '设备归类'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."REJECTION_SOURCE" IS '拒绝来源(1=窗口拒检,2=检验员拒检,3=客户拒检)'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."AREA_TYPE" IS '行政区域类型(all/gz)全国/广州'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_DISTRICT" IS '设备使用地址'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_STREET" IS '设备所在行政区域'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_CODE" IS '设备代码'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."PRODUCT_NO" IS '产品编号'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_STATUS" IS '运行状态'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."EQUIP_MAIN_TYPE" IS '主设备类型'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."USE_REGISTER_NO" IS '使用登记证编号'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."CONTACT" IS '约检联系人'; COMMENT ON COLUMN "PRESSURE2_APPOINTMENT_CONFIRM_REFUSE_YEAR_ITEM"."CONTACT_PHONE" IS '约检联系人电话'; CREATE TABLE "PRESSURE2_EQUIPMENT_RETURN_RECORD" ( "ID" VARCHAR(64) NOT NULL, "EQUIP_ID" VARCHAR(64), "REASON" VARCHAR(500), "ORDER_ID" VARCHAR(64), "CREATOR" VARCHAR(100), "CREATE_TIME" DATETIME(6), "UPDATER" VARCHAR(100), "UPDATE_TIME" DATETIME(6), "DELETED" BIT DEFAULT 0, "IS_REPORT_CITY" BIT, "UNIT_CODE" VARCHAR(100), "UNIT_NAME" VARCHAR(500), "STATUS" INT DEFAULT 100, "REMARK" VARCHAR(500), "PROCESS_INSTANCE_ID" VARCHAR(64), "SUBMIT_ID" VARCHAR(50), "SUBMIT_TIME" DATETIME(6), "ORDER_NO" VARCHAR(64), "CHECK_TYPE" INT, "AUDIT_REASON" VARCHAR(500), "CHECK_DATE" DATE, "REPORT_CITY_STATUS" INT DEFAULT 100, "REASON_DICT" VARCHAR(255), "ORDER_TYPE" BIT DEFAULT 1, "IS_SUBMIT" BIT DEFAULT 0, "BE_DISTRICT" INT, "EQUIP_TYPE" VARCHAR(64 CHAR), "EXPLAIN" VARCHAR(500), "MAIN_TASK_STATUS" INT, "USE_REGISTER_NO" VARCHAR(64 CHAR), "PRODUCT_NO" VARCHAR(255 CHAR), "BUSINESS_TYPE" INT, "SUBMIT_TYPE" INT, "RETURN_USER_ID" VARCHAR(64), "RETURN_REASON" VARCHAR(500), "RETURN_TIME" DATETIME(6), "TASK_ORDER_ID" VARCHAR(64), "TASK_ORDER_ITEM_ID" VARCHAR(64), "TASK_ORDER_ITEM_MAIN_REPORT_ID" VARCHAR(64), "REJECTION_SOURCE" INT, "REFUSE_CHECK_STATUS" INT, "EQUIP_CODE" VARCHAR(50), "EQUIP_STATUS" VARCHAR(50), "EQUIP_MAIN_TYPE" INTEGER, "NEXT_CHECK_DATE" DATE, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_EQUIPMENT_RETURN_RECORD" IS '承压-设备退回记录'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."EQUIP_ID" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."REASON" IS '拒绝原因'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."ORDER_ID" IS '约检确认单id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."DELETED" IS '删除状态'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."IS_REPORT_CITY" IS '是否上报 0 拒绝检验 1 上报市局'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."UNIT_CODE" IS '单位编码'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."STATUS" IS '审核状态'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."PROCESS_INSTANCE_ID" IS 'bpm 审批id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."ORDER_NO" IS '单号'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."CHECK_TYPE" IS '检验类型'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."AUDIT_REASON" IS '审核原因'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."REPORT_CITY_STATUS" IS '上报市局状态 100 未上报市局 200上报市局'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."REASON_DICT" IS '拒绝原因字典'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."ORDER_TYPE" IS '单据类型 1 约检单 2 受理单 3 任务单'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."IS_SUBMIT" IS '是否提交'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."BE_DISTRICT" IS '设备登记区'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."EQUIP_TYPE" IS '设备归类'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."EXPLAIN" IS '说明'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."MAIN_TASK_STATUS" IS '主报告状态'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."USE_REGISTER_NO" IS '使用登记证编号'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."PRODUCT_NO" IS '产品编号'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."BUSINESS_TYPE" IS '业务类型(0=终止约检,1=上报市局,2=拒绝年检)'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."SUBMIT_TYPE" IS '提交用户类型(0=平台用户,1=系统用户)'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."RETURN_USER_ID" IS '退回人id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."RETURN_REASON" IS '退回原因'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."RETURN_TIME" IS '退回时间'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."TASK_ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."TASK_ORDER_ITEM_ID" IS '任务单设备id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."TASK_ORDER_ITEM_MAIN_REPORT_ID" IS '任务单设备主报告id'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."REJECTION_SOURCE" IS '拒绝来源(1=窗口拒检,2=检验员拒检,3=客户拒检)'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."REFUSE_CHECK_STATUS" IS '拒绝检验状态(0=拒绝年检,1=待处理,2=无需处理,3=审核中,4=审核已拒绝,5=已作废,6=待上报,7=已上报)'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."EQUIP_CODE" IS '设备代码'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."EQUIP_STATUS" IS '设备运行状态'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."EQUIP_MAIN_TYPE" IS '设备主类型'; COMMENT ON COLUMN "PRESSURE2_EQUIPMENT_RETURN_RECORD"."NEXT_CHECK_DATE" IS '下次检验日期'; CREATE TABLE "PRESSURE2_REPORT_CITY_RECORD" ( "ID" VARCHAR(64) NOT NULL, "EQUIP_ID" VARCHAR(64), "REASON" VARCHAR(500), "ORDER_NO" VARCHAR(100), "EQUIP_CODE" VARCHAR(100), "USE_REGISTER_NO" VARCHAR(100), "UNIT_CODE" VARCHAR(100), "EQUIP_TYPE" VARCHAR(100), "EQUIP_CATEGORY" VARCHAR(100), "CHECK_TYPE" VARCHAR(100), "PRODUCT_NO" VARCHAR(100), "CHECK_DATE" VARCHAR(50), "STATUS" INT DEFAULT 0, "SUBMIT_ID" VARCHAR(64), "IS_SUBMIT" BIT DEFAULT 0, "SUBMIT_TIME" TIMESTAMP(6), "PROCESS_INSTANCE_ID" VARCHAR(64), "CURRENT_PROCESS" VARCHAR(200), "CURRENT_NODE" VARCHAR(200), "REMARK" VARCHAR(1000), "AUDIT_REASON" VARCHAR(1000), "REPORT_CITY_STATUS" INT DEFAULT 100, "REASON_DICT" VARCHAR(100), "SCENE" INT DEFAULT 0, "AREA_TYPE" VARCHAR(20), "EQUIP_STREET" INT, "EQUIP_DISTRICT" INT, "AREA_TYPE_NAME" VARCHAR(200), "EQUIP_STREET_NAME" VARCHAR(200), "EQUIP_DISTRICT_NAME" VARCHAR(200), "BE_DISTRICT" INT, "BE_DISTRICT_NAME" VARCHAR(200), "ORDER_ID" VARCHAR(64), "TASK_ORDER_ID" VARCHAR(64), "TASK_ORDER_NO" VARCHAR(100), "TASK_ORDER_ITEM_ID" VARCHAR(64), "TASK_ORDER_ITEM_MAIN_REPORT_ID" VARCHAR(64), "MAIN_TASK_STATUS" INT, "NEW_ORDER_ID" VARCHAR(64), "ORDER_TYPE" INT, "REPORT_CITY_USER_ID" VARCHAR(64), "REPORT_CITY_USER_NAME" VARCHAR(200), "REPORT_CITY_TIME" TIMESTAMP(6), "NEXT_CHECK_DATE" DATE, "UNIT_NAME" VARCHAR(500), "CONTACT" VARCHAR(200), "CONTACT_PHONE" VARCHAR(50), "EQUIP_ADDRESS" VARCHAR(500), "EQUIP_STATUS" INT, "CREATOR" VARCHAR(64), "CREATE_TIME" TIMESTAMP(6), "UPDATER" VARCHAR(64), "UPDATE_TIME" TIMESTAMP(6), "DELETED" BIT DEFAULT 0, "TENANT_ID" VARCHAR(64), "CURRENT_AUDITOR_ID" VARCHAR(64), "EQUIP_MAIN_TYPE" INTEGER, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_REPORT_CITY_RECORD" IS '上报市局记录'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."ID" IS '主键ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_ID" IS '设备ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REASON" IS '上报原因'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."ORDER_NO" IS '关联单号'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_CODE" IS '设备编号'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."USE_REGISTER_NO" IS '使用登记号'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."UNIT_CODE" IS '单位编码'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_TYPE" IS '设备归类'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_CATEGORY" IS '设备类别'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CHECK_TYPE" IS '检验性质'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."PRODUCT_NO" IS '产品编号'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CHECK_DATE" IS '检验时间'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."STATUS" IS '状态'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."SUBMIT_ID" IS '提交人ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."IS_SUBMIT" IS '是否提交'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."PROCESS_INSTANCE_ID" IS '流程实例ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CURRENT_PROCESS" IS '当前流程'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CURRENT_NODE" IS '当前节点'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."AUDIT_REASON" IS '审核原因'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REPORT_CITY_STATUS" IS '上报状态 100未上报市局 200上报市局'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REASON_DICT" IS '拒绝原因字典'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."SCENE" IS '场景值（0=拒绝年检设备，1=拒绝约检）'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."AREA_TYPE" IS '行政区域类型(all/gz)全国/广州'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_STREET" IS '设备所在行政区域'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_DISTRICT" IS '设备所在街道'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."AREA_TYPE_NAME" IS '行政区域类型名称'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_STREET_NAME" IS '设备所在行政区域（名称）'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_DISTRICT_NAME" IS '设备所在街道（名称）'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."BE_DISTRICT" IS '设备登记区'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."BE_DISTRICT_NAME" IS '设备登记区（名称）'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."ORDER_ID" IS '约检确认单ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."TASK_ORDER_ID" IS '任务单ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."TASK_ORDER_NO" IS '任务单编号'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."TASK_ORDER_ITEM_ID" IS '任务单设备ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."TASK_ORDER_ITEM_MAIN_REPORT_ID" IS '任务单设备主报告ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."MAIN_TASK_STATUS" IS '任务单设备主报告状态'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."NEW_ORDER_ID" IS '约检确认单ID（新）'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."ORDER_TYPE" IS '订单类型 1约检单 2受理单 3任务单'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REPORT_CITY_USER_ID" IS '上报市局用户ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REPORT_CITY_USER_NAME" IS '上报市局用户名称'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."REPORT_CITY_TIME" IS '上报市局时间'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."NEXT_CHECK_DATE" IS '下次检验日期'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CONTACT" IS '约检联系人'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CONTACT_PHONE" IS '约检联系人电话'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_ADDRESS" IS '设备使用地址'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_STATUS" IS '运行状态(100=在用,200=停运,300=注销)'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."TENANT_ID" IS '租户ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."CURRENT_AUDITOR_ID" IS '当前审核人ID'; COMMENT ON COLUMN "PRESSURE2_REPORT_CITY_RECORD"."EQUIP_MAIN_TYPE" IS '设备类型'; CREATE TABLE "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD" ( "ID" VARCHAR2(64) NOT NULL, "REPORT_ID" VARCHAR2(64) NOT NULL, "REMARK" VARCHAR2(1000), "TYPE" INT DEFAULT 0, "DISTRIBUTION_METHOD" VARCHAR2(64), "FOLLOW_TIME" DATETIME(6), "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, "RECEIVER" VARCHAR2(64), "RECEIVER_PHONE" VARCHAR2(32), "RECEIVE_CONFIRM_TIME" TIMESTAMP(6), "EQUIP_MAIN_TYPE" INTEGER, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD" IS '检验意义通知书跟进记录'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."REPORT_ID" IS '检验意见通知书id'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."TYPE" IS '类型(0=消息推送,1=跟进情况,2=线下材料递交,3=人工消息推送)'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."DISTRIBUTION_METHOD" IS '发放方式'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."FOLLOW_TIME" IS '跟进时间'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."RECEIVER" IS '接收人'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."RECEIVER_PHONE" IS '接收人电话'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."RECEIVE_CONFIRM_TIME" IS '接收确认时间'; COMMENT ON COLUMN "PRESSURE2_OPINION_NOTIFICATION_FOLLOW_RECORD"."EQUIP_MAIN_TYPE" IS '设备类型'; CREATE TABLE "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER" ( "ID" VARCHAR2(64) NOT NULL, "ORDER_ID" VARCHAR2(64) NOT NULL, "ORDER_NO" VARCHAR2(64) NOT NULL, "UNIT_NAME" VARCHAR2(255) NOT NULL, "EQUIP_CODE" VARCHAR2(255) NOT NULL, "ORDER_ITEM_ID" VARCHAR2(64) NOT NULL, "CHECK_DATE" DATE, "REPORT_NO" VARCHAR2(50), "CHECK_TYPE" INT, "REPORTER_ID" VARCHAR2(64) NOT NULL, "REPORTER_NAME" VARCHAR2(255), "REPORTER_NO" VARCHAR2(50), "RECIPIENT_PHONE" VARCHAR2(50), "REPORTING_TIME" TIMESTAMP(6), "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, "EQUIP_MAIN_TYPE" INTEGER, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER" IS '任务单设备隐患上报记录表'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."ORDER_NO" IS '任务单号'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."EQUIP_CODE" IS '设备注册代码'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."ORDER_ITEM_ID" IS '任务单设备id'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."REPORT_NO" IS '意见书编号'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."CHECK_TYPE" IS '检验性质（100=定期检验,200=年度检验,300=超期限检验）'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."REPORTER_ID" IS '隐患上报人id'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."REPORTER_NAME" IS '隐患上报人名称'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."REPORTER_NO" IS '隐患上报人账号（工号）'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."RECIPIENT_PHONE" IS '接收人手机号'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."REPORTING_TIME" IS '隐患上报时间'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_HIDDEN_DANGER"."EQUIP_MAIN_TYPE" IS '设备类别'; CREATE TABLE "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED" ( "ID" VARCHAR2(64) NOT NULL, "ORDER_ID" VARCHAR2(64) NOT NULL, "ORDER_NO" VARCHAR2(64) NOT NULL, "UNIT_NAME" VARCHAR2(255) NOT NULL, "EQUIP_CODE" VARCHAR2(255) NOT NULL, "ORDER_ITEM_ID" VARCHAR2(64) NOT NULL, "CHECK_DATE" DATE, "REPORT_NO" VARCHAR2(50), "CHECK_TYPE" INT, "REPORTER_ID" VARCHAR2(64) NOT NULL, "REPORTER_NAME" VARCHAR2(255), "REPORTER_NO" VARCHAR2(50), "RECIPIENT_PHONE" VARCHAR2(50), "REPORTING_TIME" TIMESTAMP(6), "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, "EQUIP_MAIN_TYPE" INTEGER, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED" IS '任务单设备报告办结上报记录表'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."ORDER_NO" IS '任务单号'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."EQUIP_CODE" IS '设备注册代码'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."ORDER_ITEM_ID" IS '任务单设备id'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."REPORT_NO" IS '意见书编号'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."CHECK_TYPE" IS '检验性质（100=定期检验,200=年度检验,300=超期限检验）'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."REPORTER_ID" IS '报告办结上报人id'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."REPORTER_NAME" IS '报告办结上报人名称'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."REPORTER_NO" IS '报告办结上报人账号（工号）'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."RECIPIENT_PHONE" IS '接收人手机号'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."REPORTING_TIME" IS '报告办结上报时间'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_ORDER_ITEM_REPORT_COMPLETED"."EQUIP_MAIN_TYPE" IS '设备类别'; --20250515 CREATE TABLE "PRESSURE2_USE_SIGN_REPORT" ( "ID" VARCHAR(64) NOT NULL, "TASK_ORDER_ID" VARCHAR(50), "TEMPLATE_ID" VARCHAR(64), "CREATOR" VARCHAR(64), "CREATE_TIME" TIMESTAMP(6) NOT NULL, "UPDATER" VARCHAR(64), "UPDATE_TIME" TIMESTAMP(6) NOT NULL, "DELETED" BIT NOT NULL, "REPORT_NAME" VARCHAR(100), "EQUIP_ID" VARCHAR(50), "EQUIP_MAIN_TYPE" INTEGER, "ORDER_ITEM_ID" VARCHAR(50), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_USE_SIGN_REPORT" IS '使用标志表'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."TASK_ORDER_ID" IS '任务单号'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."TEMPLATE_ID" IS '模板ID'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."REPORT_NAME" IS '报告名称'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."EQUIP_ID" IS '设备ID'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."EQUIP_MAIN_TYPE" IS '设备分类'; COMMENT ON COLUMN "PRESSURE2_USE_SIGN_REPORT"."ORDER_ITEM_ID" IS '检验ID'; ALTER TABLE "PRESSURE2_ORDER_REPORT" ADD COLUMN "SIGN_DATE" TIMESTAMP(6); ALTER TABLE "PRESSURE2_ORDER_REPORT" ADD COLUMN "SIGN_URL" VARCHAR(50); COMMENT ON TABLE "PRESSURE2_ORDER_REPORT" IS '受理单服务单'; COMMENT ON COLUMN "PRESSURE2_ORDER_REPORT"."SIGN_DATE" IS '签名日期'; COMMENT ON COLUMN "PRESSURE2_ORDER_REPORT"."SIGN_URL" IS '客户签名'; --20250518 CREATE TABLE "PRESSURE2_PAYMENT_FOLLOW_RECORD" ( "ID" VARCHAR2(64) NOT NULL, "TASK_ORDER_ID" VARCHAR2(64) NOT NULL, "REMARK" VARCHAR2(1000), "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, "STATUS" INT, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PAYMENT_FOLLOW_RECORD" IS '缴费跟进记录'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."TASK_ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_PAYMENT_FOLLOW_RECORD"."STATUS" IS '公众号推送状态(0=成功,1=拒绝接收,2=其他原因失败,3=发送失败)'; CREATE TABLE "PRESSURE2_TASK_ORDER_NON_TAX_APPLY" ( "ID" VARCHAR(50) NOT NULL, "ORDER_ID" VARCHAR(50), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0 NOT NULL, "STATUS" INT DEFAULT 100, "PAYMENT_INSTRUCTION_NO" VARCHAR(255), "REMARK" VARCHAR(1000), "RETURN_REASON" VARCHAR(1000), "BILLING_TIME" DATETIME(6), "EQUIP_MAIN_TYPE" INTEGER, "CREATOR" VARCHAR(50), "RECORD_ID" VARCHAR(50), "RECEIVABLE_AMOUNT" NUMBER(10,2), "SPLIT_AMOUNT" NUMBER(10,2), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_TASK_ORDER_NON_TAX_APPLY" IS '任务单非税开单申请'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."ID" IS 'ID'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."ORDER_ID" IS '任务单id'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."STATUS" IS '状态'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."PAYMENT_INSTRUCTION_NO" IS '缴费通知书'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."RETURN_REASON" IS '退回原因'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."BILLING_TIME" IS '开单日期'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."EQUIP_MAIN_TYPE" IS '设备类型 200 锅炉 300 管道'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."RECORD_ID" IS '申请记录'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."RECEIVABLE_AMOUNT" IS '应收金额'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY"."SPLIT_AMOUNT" IS '拆单金额'; CREATE TABLE "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD" ( "ID" VARCHAR2(64) NOT NULL, "APPLY_ID" VARCHAR2(64) NOT NULL, "RECORD_ID" VARCHAR2(64) NOT NULL, "IS_ORDER_SPLIT" VARCHAR2(20) DEFAULT '0', "CREATOR" VARCHAR2(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "UPDATER" VARCHAR2(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "DELETED" BIT DEFAULT 0, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD" IS '任务单非税开单申请记录关联表'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."APPLY_ID" IS '开单申请id'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."RECORD_ID" IS '记录id'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."IS_ORDER_SPLIT" IS '是否拆单 0否 1是'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_APPLY_RECORD"."DELETED" IS '是否删除'; CREATE TABLE "PRESSURE2_TASK_ORDER_NON_TAX_RECORD" ( "ID" VARCHAR(50) NOT NULL, "PAYER" VARCHAR(255), "CONTACT_PHONE" VARCHAR(500), "EMAIL" VARCHAR(500), "TOTAL_AMOUNT" DECIMAL(22,6), "ACTUAL_AMOUNT" DECIMAL(22,6), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0 NOT NULL, "CREATOR" VARCHAR(50), "REMARK" VARCHAR(500), "PAY_ACCOUNT" VARCHAR(255), "PAY_BANK" VARCHAR(500), "RECIPIENT" VARCHAR(500), "RECIPIENT_BANK" VARCHAR(500), "RECIPIENT_ACCOUNT" VARCHAR(500), "DEADLINE" DATE, "HANDLED_BY" VARCHAR(50), "OPEN_DATE" DATETIME(6), "STATUS" INT DEFAULT 100, "PAY_STATUS" INT DEFAULT 100, "PAYMENT_INSTRUCTION_NO" VARCHAR(255), "DEPT_ID" VARCHAR(50), "PAY_DATE" DATETIME(6), "BILL_NUMBER" VARCHAR(50), "PAYMENT_INSTRUCTION" VARCHAR(1000), "PROCESS_INSTANCE_ID" VARCHAR(64), "CHECK_DATE" DATE, "UNIT_NAME" VARCHAR(500), "USE_UNIT_NAME" VARCHAR(500), "EQUIP_MAIN_TYPE" INTEGER, "PAY_DEADLINE" DATE, "RECIPIENT_PHONE" VARCHAR(255), "CLIENT_UNIT" VARCHAR(255), "CLIENT_UNIT_CODE" VARCHAR(500), "CHARGE_ITEM_CODE" VARCHAR(500), "CHARGE_ITEM_NAME" VARCHAR(500), "NUM" INT, "PRICING" VARCHAR(500), "IMP_URL" VARCHAR(500), "NOTICE_PDF_URL" VARCHAR2(500), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_TASK_ORDER_NON_TAX_RECORD" IS '任务单非税记录'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."ID" IS 'ID'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAYER" IS '付款人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CONTACT_PHONE" IS '联系电话'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."EMAIL" IS '利息人邮箱'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."TOTAL_AMOUNT" IS '缴费金额'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."ACTUAL_AMOUNT" IS '实际金额'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAY_ACCOUNT" IS '付款账号'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAY_BANK" IS '付款银行'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."RECIPIENT" IS '收款人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."RECIPIENT_BANK" IS '收款银行'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."RECIPIENT_ACCOUNT" IS '收款账号'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."DEADLINE" IS '截止日期'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."HANDLED_BY" IS '经办人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."OPEN_DATE" IS '开单日期'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."STATUS" IS '审核状态 100 待审核 200 审核通过 300 已拒绝'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAY_STATUS" IS '付款状态 100 待缴费 200 已缴费 300 已作废'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAYMENT_INSTRUCTION_NO" IS '缴费通知书'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."DEPT_ID" IS '部门'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAY_DATE" IS '付款日期'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."BILL_NUMBER" IS '票据编号'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAYMENT_INSTRUCTION" IS '缴费通知书'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PROCESS_INSTANCE_ID" IS '流程id'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CHECK_DATE" IS '检验日期'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."UNIT_NAME" IS '单位名称'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."USE_UNIT_NAME" IS '使用单位名称'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."EQUIP_MAIN_TYPE" IS '设备类型 200锅炉 300管道'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PAY_DEADLINE" IS '付款截止日期'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."RECIPIENT_PHONE" IS '报告接收电话'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CLIENT_UNIT" IS '委托单位名称'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CLIENT_UNIT_CODE" IS '委托单位编码'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CHARGE_ITEM_CODE" IS '收费项目编码'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."CHARGE_ITEM_NAME" IS '收费项目名称'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."NUM" IS '数量'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."PRICING" IS '收费标准'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."IMP_URL" IS '缴费通知书'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD"."NOTICE_PDF_URL" IS '缴费通知书PDF文件URL'; CREATE TABLE "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM" ( "ID" VARCHAR(50) NOT NULL, "RECORD_ID" VARCHAR(50), "ORDER_ID" VARCHAR(50), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0 NOT NULL, "CREATOR" VARCHAR(50), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM" IS '任务单非税记录子项'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."RECORD_ID" IS '记录'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."ORDER_ID" IS '任务单'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_RECORD_ITEM"."CREATOR" IS '创建人'; CREATE TABLE "PRESSURE2_TASK_ORDER_NON_TAX_REPORT" ( "ID" VARCHAR(64) NOT NULL, "NON_TAX_RECORD_ID" VARCHAR(50), "TEMPLATE_ID" VARCHAR(64), "CREATOR" VARCHAR(64), "CREATE_TIME" TIMESTAMP(6) NOT NULL, "UPDATER" VARCHAR(64), "UPDATE_TIME" TIMESTAMP(6) NOT NULL, "DELETED" BIT NOT NULL, "REPORT_NAME" VARCHAR(100), "EQUIP_MAIN_TYPE" INTEGER, "INS_ID" VARCHAR(50), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_TASK_ORDER_NON_TAX_REPORT" IS '非税通知书'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."NON_TAX_RECORD_ID" IS '非税记录单号'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."TEMPLATE_ID" IS '模板ID'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."REPORT_NAME" IS '报告名称'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."EQUIP_MAIN_TYPE" IS '设备分类'; COMMENT ON COLUMN "PRESSURE2_TASK_ORDER_NON_TAX_REPORT"."INS_ID" IS '报表明细ID'; CREATE TABLE "PRESSURE2_PIPE_USE_REGISTRATION_REPORT" ( "ID" VARCHAR(64) NOT NULL, "TASK_ORDER_ID" VARCHAR(50), "TEMPLATE_ID" VARCHAR(64), "CREATOR" VARCHAR(64), "CREATE_TIME" TIMESTAMP(6) NOT NULL, "UPDATER" VARCHAR(64), "UPDATE_TIME" TIMESTAMP(6) NOT NULL, "DELETED" BIT NOT NULL, "REPORT_NO" VARCHAR(50), "STATUS" INT, "REMARK" VARCHAR(1000), "REPORT_NAME" VARCHAR(100), "APPROVAL_ID" VARCHAR(50), "APPROVAL_TIME" DATETIME(6), "APPROVAL_NAME" VARCHAR(100), "SUBMIT_ID" VARCHAR(50), "SUBMIT_TIME" DATETIME(6), "SUBMIT_NAME" VARCHAR(50), "PROJECT_NO" VARCHAR(50), "UNIT_NAME" VARCHAR(50), "CERTIFICATE_NO" varchar(256), "DEPT_ID" VARCHAR(50), "EQUIP_ID" VARCHAR(50), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_USE_REGISTRATION_REPORT" IS '管道使用登记表'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."TASK_ORDER_ID" IS '任务单号'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."TEMPLATE_ID" IS '模板ID'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."UPDATER" IS '修改人'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."UPDATE_TIME" IS '修改时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."REPORT_NO" IS '报表编号'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."STATUS" IS '审核状态'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."REMARK" IS '备注'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."REPORT_NAME" IS '报告名称'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."APPROVAL_ID" IS '审核人'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."APPROVAL_TIME" IS '审核时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."APPROVAL_NAME" IS '审核人名称'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."SUBMIT_NAME" IS '提交人名称'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."PROJECT_NO" IS '工程号'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."UNIT_NAME" IS '使用单位名称'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."CERTIFICATE_NO" IS '使用登记证编号'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."DEPT_ID" IS '部门ID'; COMMENT ON COLUMN "PRESSURE2_PIPE_USE_REGISTRATION_REPORT"."EQUIP_ID" IS '设备ID'; ALTER TABLE "PRESSURE2_EQUIP_PIPE" ADD COLUMN "IS_EFFECTIVE" VARCHAR(50) DEFAULT (1); COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE"."IS_EFFECTIVE" IS '是否有效'; --20260519 ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "IS_SUSPEND" BIT DEFAULT (0); ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM" ADD COLUMN "SUSPEND_TIME" DATETIME(6); COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."IS_SUSPEND" IS '是否中止检验'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM"."SUSPEND_TIME" IS '中止时间'; ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "IS_SUSPEND" BIT DEFAULT (0); ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM" ADD COLUMN "SUSPEND_TIME" DATETIME(6); COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."IS_SUSPEND" IS '是否中止检验'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM"."SUSPEND_TIME" IS '中止时间'; CREATE TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND" ( "ID" VARCHAR(64), "ORDER_ID" VARCHAR(64) NOT NULL, "EQUIP_ID" VARCHAR(64) NOT NULL, "EQUIP_CODE" VARCHAR(64), "PLAN_DATE" DATE, "IS_LEASE" BIT, "USE_REGISTER_NO" VARCHAR(100), "EQUIP_TYPE" VARCHAR(64), "EQUIP_NAME" VARCHAR(255 CHAR), "PRODUCT_NO" VARCHAR(255 CHAR), "SAFE_MANAGER" VARCHAR(64 CHAR), "SAFE_MANAGER_PHONE" VARCHAR(32 CHAR), "NEXT_IN_CHECK_DATE" DATE, "NEXT_OUT_CHECK_DATE" DATE, "NEXT_PRESSURE_CHECK_DATE" DATE, "OVERDUE_DATE" DATE, "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0 NOT NULL, "SUBMIT_TIME" DATETIME(6), "SUBMIT_ID" VARCHAR(64), "IS_CANCEL" BIT DEFAULT 0, "REASON" VARCHAR2(1000), "APPROVAL_ID" VARCHAR2(64), "APPROVAL_TIME" TIMESTAMP(6)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND" IS '锅炉中止检验记录'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."ORDER_ID" IS '订单id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."EQUIP_ID" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."EQUIP_CODE" IS '设备代码'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."PLAN_DATE" IS '计划排期'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."IS_LEASE" IS '是否租借'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."USE_REGISTER_NO" IS '使用登记证编号'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."EQUIP_TYPE" IS '类别'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."EQUIP_NAME" IS '名称'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."PRODUCT_NO" IS '产品编号'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."SAFE_MANAGER" IS '安全管理人员'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."SAFE_MANAGER_PHONE" IS '安全管理人员电话'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."NEXT_IN_CHECK_DATE" IS '下次内部检验时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."NEXT_OUT_CHECK_DATE" IS '下次外部检验时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."NEXT_PRESSURE_CHECK_DATE" IS '下次耐压时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."OVERDUE_DATE" IS '设备超期时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."IS_CANCEL" IS '是否取消'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."REASON" IS '中止检验'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."APPROVAL_ID" IS '任务单变更审核人id'; COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_SUSPEND"."APPROVAL_TIME" IS '任务单变更审核时间'; CREATE TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND" ( "ID" VARCHAR(64), "ORDER_ID" VARCHAR(64) NOT NULL, "EQUIP_ID" VARCHAR(64) NOT NULL, "PROJECT_NO" VARCHAR(64), "PLAN_DATE" DATE, "IS_LEASE" BIT, "USE_REGISTER_NO" VARCHAR(100), "EQUIP_TYPE" VARCHAR(64), "PROJECT_NAME" VARCHAR(255 CHAR), "PRODUCT_NO" VARCHAR(255 CHAR), "SAFE_MANAGER" VARCHAR(64 CHAR), "SAFE_MANAGER_PHONE" VARCHAR(32 CHAR), "NEXT_LEGAL_CHECK_DATE" DATE, "NEXT_YEAR_CHECK_DATE" DATE, "OVERDUE_DATE" DATE, "CREATOR" VARCHAR(64 CHAR), "CREATE_TIME" TIMESTAMP(0) NOT NULL, "UPDATER" VARCHAR(64 CHAR), "UPDATE_TIME" TIMESTAMP(0) NOT NULL, "DELETED" BIT DEFAULT 0 NOT NULL, "SUBMIT_TIME" DATETIME(6), "SUBMIT_ID" VARCHAR(64), "IS_CANCEL" BIT DEFAULT 0, "REASON" VARCHAR2(1000), "APPROVAL_ID" VARCHAR2(64), "APPROVAL_TIME" TIMESTAMP(6)) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND" IS '管道中止检验记录'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."ID" IS 'id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."ORDER_ID" IS '订单id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."EQUIP_ID" IS '设备id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."PROJECT_NO" IS '工程号'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."PLAN_DATE" IS '计划排期'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."IS_LEASE" IS '是否租借'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."USE_REGISTER_NO" IS '使用登记证编号'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."EQUIP_TYPE" IS '类别'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."PROJECT_NAME" IS '工程名称'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."PRODUCT_NO" IS '产品编号'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."SAFE_MANAGER" IS '安全管理人员'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."SAFE_MANAGER_PHONE" IS '安全管理人员电话'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."NEXT_LEGAL_CHECK_DATE" IS '下次法定检验时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."NEXT_YEAR_CHECK_DATE" IS '下次年度检验时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."OVERDUE_DATE" IS '设备超期时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."SUBMIT_TIME" IS '提交时间'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."SUBMIT_ID" IS '提交人'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."IS_CANCEL" IS '是否取消'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."REASON" IS '中止检验'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."APPROVAL_ID" IS '任务单变更审核人id'; COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_SUSPEND"."APPROVAL_TIME" IS '任务单变更审核时间'; --20260521 ALTER TABLE "PRESSURE_TASK_ORDER" ADD COLUMN "ISSUE_URL" VARCHAR(50); COMMENT ON COLUMN "PRESSURE_TASK_ORDER"."ISSUE_URL" IS '出具报告文件地址';