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