You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
41 lines
1.4 KiB
41 lines
1.4 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 项企36
|
|
Source Server Type : PostgreSQL
|
|
Source Server Version : 90606
|
|
Source Host : 10.8.30.36:5432
|
|
Source Catalog : data_center
|
|
Source Schema : public
|
|
|
|
Target Server Type : PostgreSQL
|
|
Target Server Version : 90606
|
|
File Encoding : 65001
|
|
|
|
Date: 24/11/2022 09:46:27
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for reserve_item_report
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."reserve_item_report";
|
|
CREATE TABLE "public"."reserve_item_report" (
|
|
"id" int4 NOT NULL DEFAULT nextval('reserve_item_report_id_seq'::regclass),
|
|
"year" int4 NOT NULL,
|
|
"month" int4 NOT NULL,
|
|
"path" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"type" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"name" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."reserve_item_report"."path" IS '七牛云路径地址';
|
|
COMMENT ON COLUMN "public"."reserve_item_report"."type" IS '1.储备项目储备周期分析
|
|
2.部门储备项目汇总表
|
|
3.储备项目丢单统计表';
|
|
COMMENT ON COLUMN "public"."reserve_item_report"."name" IS '文件名';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table reserve_item_report
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."reserve_item_report" ADD CONSTRAINT "reserve_item_report_pkey" PRIMARY KEY ("id");
|
|
|