-- 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; ---- 以上已加