-- 更新uat环境sql语句 -- 更新动态报表字段 2026/3/19 16:40 ALTER TABLE "PRESSURE2_DYNAMIC_TB" ADD COLUMN "COPY_CONFIG" JSON; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB"."COPY_CONFIG" IS '复制续页配置'; -- 添加是否需要前台约检确认字段 2026/4/1 16:27 ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING" ADD COLUMN "HAS_ORDER_CONFIRM" BIT DEFAULT (1); COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING"."HAS_ORDER_CONFIRM" IS '是否需要前台约检确认'; ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING" ADD COLUMN "HAS_ORDER_CONFIRM" BIT DEFAULT (1); COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING"."HAS_ORDER_CONFIRM" IS '是否需要前台约检确认'; -- 添加承压检验性质关联报告模版拓展表 2026/4/10 9:44 CREATE TABLE "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND" ( "ID" VARCHAR(64) NOT NULL, "INSPECTION_NATURE_TEMPLATE_ID" VARCHAR(64) NOT NULL, "CREATOR" VARCHAR(64) DEFAULT '', "CREATE_TIME" TIMESTAMP(6) NOT NULL, "UPDATER" VARCHAR(64) DEFAULT '', "UPDATE_TIME" TIMESTAMP(6), "DELETED" BIT DEFAULT 0, "PART" VARCHAR(512), NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND" IS '承压检验性质关联报告模版'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."INSPECTION_NATURE_TEMPLATE_ID" IS '检验性质ID'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."UPDATER" IS '更新者'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND"."PART" IS '部件，按/区分'; ALTER TABLE "PRESSURE2_INSPECTION_NATURE_TEMPLATE_EXPAND" MODIFY "PART" TEXT NULL; ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "PROJECT_CODE" VARCHAR(50); ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "ACCEPT_ORDER_TEMPLATE_ID" VARCHAR(64); ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "FEE_TYPES" VARCHAR(50); ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "FEE_CALC_TYPE" VARCHAR(50); ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "FEE" VARCHAR(64); ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "STATUS" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."PROJECT_CODE" IS '项目代码'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."ACCEPT_ORDER_TEMPLATE_ID" IS '受理单模板'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."FEE_TYPES" IS '费用类型'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."FEE_CALC_TYPE" IS '费用计算类型'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."FEE" IS '费用'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."STATUS" IS '状态'; ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "IS_MAIN_PROJECT" BIT; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."ACCEPT_ORDER_TEMPLATE_ID" IS '受理单模板（参数计算时为报表id）'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."FEE_TYPES" IS '费用类型(法定收费:1,服务收费:0),按,分割'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."FEE_CALC_TYPE" IS '费用计算类型(固定费用:1,参数计算:0)'; COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."IS_MAIN_PROJECT" IS '是否为主项目'; ALTER TABLE "PRESSURE2_BOILER_CONNECT_RECORD_REPORT" ADD COLUMN "FEE_FILE_URL" VARCHAR(128); COMMENT ON COLUMN "PRESSURE2_BOILER_CONNECT_RECORD_REPORT"."FEE_FILE_URL" IS '费用计算url'; CREATE TABLE "PRESSURE2_DYNAMIC_TB_FEE_COL" ( "ID" VARCHAR(64) NOT NULL, "CREATE_TIME" TIMESTAMP(6), "CREATOR" VARCHAR(64), "UPDATE_TIME" TIMESTAMP(6), "UPDATER" VARCHAR(64), "DELETED" BIT DEFAULT 0, "CODE" VARCHAR(50), "NAME" VARCHAR(50), "COL_TYPE" VARCHAR(50), "VAL_TYPE" VARCHAR(50), "DESCRIPTION" VARCHAR(50), "PROJECT_ID" TEXT, NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ; COMMENT ON TABLE "PRESSURE2_DYNAMIC_TB_FEE_COL" IS '承压动态报表字段'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."ID" IS '主键'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."CREATOR" IS '创建人'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."UPDATER" IS '更新人'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."DELETED" IS '是否删除'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."CODE" IS '字段标识'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."NAME" IS '字段名称'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."COL_TYPE" IS '字段类型'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."VAL_TYPE" IS '值类型'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."DESCRIPTION" IS '说明'; COMMENT ON COLUMN "PRESSURE2_DYNAMIC_TB_FEE_COL"."PROJECT_ID" IS '关联项目'; ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK" ADD COLUMN "FEE_CALCULATE_JSON" TEXT; COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK"."FEE_CALCULATE_JSON" IS '费用计算json'; ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK" ADD COLUMN "FEE_CALCULATE_JSON" TEXT; COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK"."FEE_CALCULATE_JSON" IS '费用计算json'; -- 添加字段 20260417 ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK" ADD COLUMN "TYPE" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_CHECK"."TYPE" IS '类型 1 法定 2 服务'; ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE" ADD COLUMN "CHARGE_TYPE" VARCHAR(50); ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE" ADD COLUMN "IS_EXEMPT" VARCHAR(50); ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE" ADD COLUMN "SHOULD_AMOUNT" DECIMAL(22,6); ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE" ADD COLUMN "SERVICE_AMOUNT" DECIMAL(22,6); ALTER TABLE "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE" ADD COLUMN "REDUCE_FEE" DECIMAL(22,6); COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE"."CHARGE_TYPE" IS '收费类型 1 非合同收费 2 合同收费'; COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE"."IS_EXEMPT" IS '是否免征 0 否 1 是'; COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE"."SHOULD_AMOUNT" IS '应收法定金额'; COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE"."SERVICE_AMOUNT" IS '服务收费金额'; COMMENT ON COLUMN "PRESSURE2_EQUIP_PIPE_SCHEDULING_FEE"."REDUCE_FEE" IS '免征费用'; ALTER TABLE "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT" ADD COLUMN "FEE_TYPE" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_PIPE_TASK_ORDER_ITEM_REPORT"."FEE_TYPE" IS '费用类型（1=法定，2=服务）'; -- 添加字段 20260418 ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK" ADD COLUMN "TYPE" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_CHECK"."TYPE" IS '类型 1 法定 2 服务'; ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE" ADD COLUMN "CHARGE_TYPE" VARCHAR(50); ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE" ADD COLUMN "IS_EXEMPT" VARCHAR(50); ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE" ADD COLUMN "SHOULD_AMOUNT" DECIMAL(22,6); ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE" ADD COLUMN "SERVICE_AMOUNT" DECIMAL(22,6); ALTER TABLE "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE" ADD COLUMN "REDUCE_FEE" DECIMAL(22,6); COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE"."CHARGE_TYPE" IS '收费类型 1 非合同收费 2 合同收费'; COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE"."IS_EXEMPT" IS '是否免征 0 否 1 是'; COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE"."SHOULD_AMOUNT" IS '应收法定金额'; COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE"."SERVICE_AMOUNT" IS '服务收费金额'; COMMENT ON COLUMN "PRESSURE2_EQUIP_BOILER_SCHEDULING_FEE"."REDUCE_FEE" IS '免征费用'; ALTER TABLE "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT" ADD COLUMN "FEE_TYPE" VARCHAR(50); COMMENT ON COLUMN "PRESSURE2_BOILER_TASK_ORDER_ITEM_REPORT"."FEE_TYPE" IS '费用类型（1=法定，2=服务）'; CREATE TABLE PRESSURE2_EQUIP_BOILER_PRESSURE_PART ( ID VARCHAR(64) NOT NULL, BOILER_ID VARCHAR(64) NOT NULL, PART_TYPE VARCHAR(64), PART_NAME VARCHAR(255), SPECIFICATION VARCHAR(128), MATERIAL VARCHAR(128), REMARK VARCHAR(500), CREATOR VARCHAR(64), CREATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, UPDATER VARCHAR(64), UPDATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, DELETED CHAR(1) DEFAULT '0', PRIMARY KEY (ID) ); CREATE SEQUENCE PRESSURE2_EQUIP_BOILER_PRESSURE_PART_SEQ START WITH 1 INCREMENT BY 1; ALTER TABLE "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 '是否删除';