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


--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';