/*
|
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");
|
