From 79c4524bc2cac69ef74cbf4adc6a092e3bfa4f4b Mon Sep 17 00:00:00 2001
From: seatonwan9
Date: 星期四, 28 八月 2025 02:07:17 +0800
Subject: [PATCH] 更新代码
---
sql/tb_report_result_submission.sql | 125 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 125 insertions(+), 0 deletions(-)
diff --git a/sql/tb_report_result_submission.sql b/sql/tb_report_result_submission.sql
new file mode 100644
index 0000000..8683e15
--- /dev/null
+++ b/sql/tb_report_result_submission.sql
@@ -0,0 +1,125 @@
+/*
+ Navicat Premium Data Transfer
+
+ Source Server : zypt
+ Source Server Type : PostgreSQL
+ Source Server Version : 110016
+ Source Host : 36.133.126.138:5432
+ Source Catalog : zypt-v2
+ Source Schema : public
+
+ Target Server Type : PostgreSQL
+ Target Server Version : 110016
+ File Encoding : 65001
+
+ Date: 26/08/2025 12:49:41
+*/
+
+
+-- ----------------------------
+-- Table structure for tb_report_result_submission
+-- ----------------------------
+DROP TABLE IF EXISTS "public"."tb_report_result_submission";
+CREATE TABLE "public"."tb_report_result_submission" (
+ "id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
+ "name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
+ "describe" varchar(6000) COLLATE "pg_catalog"."default" NOT NULL,
+ "source_id" varchar(36) COLLATE "pg_catalog"."default",
+ "source_name" varchar(100) COLLATE "pg_catalog"."default",
+ "scheme_id" varchar(36) COLLATE "pg_catalog"."default",
+ "scheme_name" varchar(100) COLLATE "pg_catalog"."default",
+ "industrial_chain_id" varchar(360) COLLATE "pg_catalog"."default",
+ "industrial_chain_name" varchar(1000) COLLATE "pg_catalog"."default",
+ "important_area_id" varchar(1000) COLLATE "pg_catalog"."default",
+ "important_area_name" varchar(1000) COLLATE "pg_catalog"."default",
+ "scene_id" varchar(36) COLLATE "pg_catalog"."default",
+ "scene_name" varchar(100) COLLATE "pg_catalog"."default",
+ "dept_id" varchar(36) COLLATE "pg_catalog"."default",
+ "submission_unit" varchar(100) COLLATE "pg_catalog"."default",
+ "sort" int4 DEFAULT 0,
+ "status" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 0,
+ "appro_status" char(1) COLLATE "pg_catalog"."default",
+ "create_by" varchar(20) COLLATE "pg_catalog"."default",
+ "create_user_id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
+ "create_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "update_by" varchar(20) COLLATE "pg_catalog"."default",
+ "update_user_id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
+ "update_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "deleted" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 0,
+ "home_image" varchar(36) COLLATE "pg_catalog"."default",
+ "upload_doc" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 0,
+ "upload_video" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 0,
+ "flow_id" varchar(36) COLLATE "pg_catalog"."default",
+ "type_id" varchar(1000) COLLATE "pg_catalog"."default",
+ "type_name" varchar(1000) COLLATE "pg_catalog"."default",
+ "type_child_id" varchar(1000) COLLATE "pg_catalog"."default",
+ "type_child_name" varchar(1000) COLLATE "pg_catalog"."default",
+ "business_process_id" varchar(360) COLLATE "pg_catalog"."default",
+ "business_process_name" varchar(1000) COLLATE "pg_catalog"."default",
+ "award_id" varchar(36) COLLATE "pg_catalog"."default",
+ "award_name" varchar(100) COLLATE "pg_catalog"."default",
+ "data_source" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 1,
+ "important_district_id" varchar(1000) COLLATE "pg_catalog"."default",
+ "important_district_name" varchar(1000) COLLATE "pg_catalog"."default",
+ "unit_id" varchar(36) COLLATE "pg_catalog"."default" DEFAULT '1'::character varying,
+ "display" varchar(36) COLLATE "pg_catalog"."default",
+ "url1" varchar(255) COLLATE "pg_catalog"."default",
+ "important_full_name" text COLLATE "pg_catalog"."default"
+)
+;
+COMMENT ON COLUMN "public"."tb_report_result_submission"."id" IS '涓婚敭id';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."name" IS '鎴愭灉鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."describe" IS '鎴愭灉鎻忚堪';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."source_id" IS '鍙戝竷鑼冨洿id';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."source_name" IS '鍙戝竷鑼冨洿';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."scheme_id" IS '鏂规id';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."scheme_name" IS '鏂规鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."industrial_chain_id" IS '鍗曚綅宸ョ▼ID(涓�绾у伐搴�)';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."industrial_chain_name" IS '鍗曚綅宸ョ▼鍚嶇О(涓�绾у伐搴�)';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."important_area_id" IS '閲嶇偣棰嗗煙id(涓夌骇宸ュ簭)';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."important_area_name" IS '閲嶇偣棰嗗煙鍚嶇О(涓夌骇宸ュ簭)';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."scene_id" IS '鍦烘櫙鏂瑰悜id';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."scene_name" IS '鍦烘櫙鏂瑰悜鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."dept_id" IS '鎻愭姤鍗曚綅id';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."submission_unit" IS '鎻愭姤鍗曚綅鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."sort" IS '鏄剧ず椤哄簭';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."status" IS '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."appro_status" IS '瀹℃牳鐘舵��';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."create_by" IS '鍒涘缓浜哄悕绉�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."create_user_id" IS '鍒涘缓鑰�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."update_by" IS '鏇存柊浜哄悕绉�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."update_user_id" IS '鏇存柊鑰�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."deleted" IS '鏄惁鍒犻櫎';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."home_image" IS '棣栭〉鍥剧墖';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."upload_doc" IS '鏄惁宸蹭笂浼犳枃妗�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."upload_video" IS '鏄惁宸蹭笂浼犺棰�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."flow_id" IS '娴佺▼ID';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."type_id" IS '绫诲瀷ID';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."type_name" IS '绫诲瀷鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."type_child_id" IS '绫诲瀷瀛愮骇ID';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."type_child_name" IS '绫诲瀷瀛愮骇鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."business_process_id" IS '涓氬姟鐜妭ID';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."business_process_name" IS '涓氬姟鐜妭鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."award_id" IS '濂栭」ID';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."award_name" IS '濂栭」鍚嶇О';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."data_source" IS '鏁版嵁鏉ユ簮锛�1锛氭墜鍔ㄦ彁鎶ワ紝2锛氭暟鎹悓姝ワ級';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."important_district_id" IS '鍗曚綅宸ョ▼ID(浜岀骇宸ュ簭)';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."important_district_name" IS '鍗曚綅宸ョ▼鍚嶇О(浜岀骇宸ュ簭)';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."unit_id" IS '鎵�灞炲崟浣岻D';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."display" IS '鍏紑鎯呭喌锛圙ROUP_OPEN锛氶泦鍥㈠唴鍏紑锛沀NIT_OPEN锛氬崟浣嶅唴鍏紑锛汚UTH_OPEN锛氭巿鏉冨叕寮�锛�';
+COMMENT ON COLUMN "public"."tb_report_result_submission"."important_full_name" IS '鍗曚綅宸ョ▼鍏ㄥ悕';
+COMMENT ON TABLE "public"."tb_report_result_submission" IS '鎴愭灉鎻愭姤鍩虹淇℃伅琛�';
+
+-- ----------------------------
+-- Indexes structure for table tb_report_result_submission
+-- ----------------------------
+CREATE INDEX "idx_appro_status_result" ON "public"."tb_report_result_submission" USING btree (
+ "appro_status" COLLATE "pg_catalog"."default" "pg_catalog"."bpchar_ops" ASC NULLS LAST
+);
+
+-- ----------------------------
+-- Primary Key structure for table tb_report_result_submission
+-- ----------------------------
+ALTER TABLE "public"."tb_report_result_submission" ADD CONSTRAINT "tb_tb_report_result_submission_pkey" PRIMARY KEY ("id");
--
Gitblit v1.8.0