yudao-cloud-yiqun/build-uat/update.sql

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