/* 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 '所属单位ID'; COMMENT ON COLUMN "public"."tb_report_result_submission"."display" IS '公开情况（GROUP_OPEN：集团内公开；UNIT_OPEN：单位内公开；AUTH_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");