AI_Engineering/ais_knowledge/knowledge/sql/knowledge.sql

----创建序列
CREATE SEQUENCE ai_knowledge_file_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

CREATE TABLE "public"."ai_knowledge_file" (
  "id" int4 NOT NULL DEFAULT nextval('ai_knowledge_file_seq'::regclass),
  "name" varchar(128) COLLATE "pg_catalog"."default",
  "url" varchar(256) COLLATE "pg_catalog"."default",
  "type" varchar(128) COLLATE "pg_catalog"."default",
  "size" "pg_catalog"."numeric",
  "parent_id" int4 DEFAULT 0,
  "vector_id" int4,
  "sort" int2,
  "creator" varchar(64) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "updater" varchar(64) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "deleted" "pg_catalog"."numeric" DEFAULT 0,
  "type_name" varchar(128) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."ai_knowledge_file"."id" IS '主键ID';
COMMENT ON COLUMN "public"."ai_knowledge_file"."name" IS '文件名称';
COMMENT ON COLUMN "public"."ai_knowledge_file"."url" IS '文件URL';
COMMENT ON COLUMN "public"."ai_knowledge_file"."type" IS '文件类型';
COMMENT ON COLUMN "public"."ai_knowledge_file"."size" IS '文件大小';
COMMENT ON COLUMN "public"."ai_knowledge_file"."parent_id" IS '父ID';
COMMENT ON COLUMN "public"."ai_knowledge_file"."vector_id" IS '向量库ID';
COMMENT ON COLUMN "public"."ai_knowledge_file"."sort" IS '排序';
COMMENT ON COLUMN "public"."ai_knowledge_file"."type_name" IS '分类类型';

-- ----------------------------
-- Primary Key structure for table ai_knowledge_file
-- ----------------------------
ALTER TABLE "public"."ai_knowledge_file" ADD CONSTRAINT "ai_knowledage_file_pkey" PRIMARY KEY ("id");

----创建序列
CREATE SEQUENCE ai_knowledge_type_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
	
CREATE TABLE "public"."ai_knowledge_type" (
  "id" int4 NOT NULL DEFAULT nextval('ai_knowledge_type_seq'::regclass),
  "name" varchar(128) COLLATE "pg_catalog"."default",
  "sort" int2,
  "parent_id" int4 NOT NULL DEFAULT 0,
  "creator" varchar(64) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "updater" varchar(64) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "deleted" "pg_catalog"."numeric" DEFAULT 0
)
;
COMMENT ON COLUMN "public"."ai_knowledge_type"."id" IS '主键ID';
COMMENT ON COLUMN "public"."ai_knowledge_type"."name" IS '分类名称';
COMMENT ON COLUMN "public"."ai_knowledge_type"."sort" IS '排序';
COMMENT ON COLUMN "public"."ai_knowledge_type"."parent_id" IS '父ID';

-- ----------------------------
-- Primary Key structure for table ai_knowledge_type
-- ----------------------------
ALTER TABLE "public"."ai_knowledge_type" ADD CONSTRAINT "ai_knowledge_type_pkey" PRIMARY KEY ("id");

----创建序列
CREATE SEQUENCE ai_question_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
CREATE TABLE "public"."ai_question" (
                                        "id" int8 NOT NULL DEFAULT nextval('ai_question_seq'::regclass),
                                        "question" text COLLATE "pg_catalog"."default",
                                        "answer" text COLLATE "pg_catalog"."default",
                                        "question_type" varchar(4) COLLATE "pg_catalog"."default" DEFAULT '知识库'::character varying,
                                        "feedback" int4 DEFAULT 0,
                                        "creator" varchar(64) COLLATE "pg_catalog"."default",
                                        "create_time" timestamp(6),
                                        "updater" varchar(64) COLLATE "pg_catalog"."default",
                                        "update_time" timestamp(6),
                                        "deleted" "pg_catalog"."numeric" DEFAULT 0,
                                        "keywords" text COLLATE "pg_catalog"."default",
                                        "net_answer" int4 DEFAULT 0,
                                        "net_answer_manual" int4 DEFAULT 0,
                                        "answer_sources" text COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."ai_question"."question" IS '问题';
COMMENT ON COLUMN "public"."ai_question"."answer" IS '回答';
COMMENT ON COLUMN "public"."ai_question"."question_type" IS '问题类型';
COMMENT ON COLUMN "public"."ai_question"."feedback" IS '反馈类型 - 0 :无反馈，1: 赞， 2: 踩';
COMMENT ON COLUMN "public"."ai_question"."keywords" IS '问题关键词';
COMMENT ON COLUMN "public"."ai_question"."net_answer" IS '是否全网回答 0 - 否 1 - 是';
COMMENT ON COLUMN "public"."ai_question"."net_answer_manual" IS '是否手动切换全网 0 - 否 1 - 是';
COMMENT ON COLUMN "public"."ai_question"."answer_sources" IS '回答来源';

-- ----------------------------
-- Primary Key structure for table ai_question
-- ----------------------------
ALTER TABLE "public"."ai_question" ADD CONSTRAINT "ai_question_pkey" PRIMARY KEY ("id");



----创建序列
CREATE SEQUENCE infra_file_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
CREATE TABLE "public"."infra_file" (
                                       "id" "pg_catalog"."numeric" NOT NULL,
                                       "config_id" "pg_catalog"."numeric",
                                       "path" varchar(512) COLLATE "pg_catalog"."default",
                                       "url" text COLLATE "pg_catalog"."default",
                                       "type" varchar(128) COLLATE "pg_catalog"."default",
                                       "size" "pg_catalog"."numeric",
                                       "creator" varchar(64) COLLATE "pg_catalog"."default",
                                       "create_time" timestamp(6),
                                       "updater" varchar(64) COLLATE "pg_catalog"."default",
                                       "update_time" timestamp(6),
                                       "deleted" "pg_catalog"."numeric" DEFAULT 0,
                                       "name" varchar(512) COLLATE "pg_catalog"."default",
                                       "project_id" varchar(60) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Primary Key structure for table infra_file
-- ----------------------------
ALTER TABLE "public"."infra_file" ADD CONSTRAINT "infra_file_pkey" PRIMARY KEY ("id");

----创建序列
CREATE SEQUENCE infra_file_config_seq
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
CREATE TABLE "public"."infra_file_config" (
                                              "id" "pg_catalog"."numeric" NOT NULL,
                                              "name" varchar(63) COLLATE "pg_catalog"."default",
                                              "storage" "pg_catalog"."numeric",
                                              "remark" varchar(255) COLLATE "pg_catalog"."default",
                                              "master" "pg_catalog"."numeric",
                                              "config" text COLLATE "pg_catalog"."default",
                                              "creator" varchar(64) COLLATE "pg_catalog"."default",
                                              "create_time" timestamp(6),
                                              "updater" varchar(64) COLLATE "pg_catalog"."default",
                                              "update_time" timestamp(6),
                                              "deleted" "pg_catalog"."numeric" DEFAULT 0
)
;

-- ----------------------------
-- Records of infra_file_config
-- ----------------------------
INSERT INTO "public"."infra_file_config" VALUES (0, '数据库', 1, '我是数据库', 1, '{"@class":"com.zjugis.ai.knowledge.file.client.db.DBFileClientConfig","domain":"http://127.0.0.1:48080"}', '1', '2022-03-15 23:56:24', '1', '2022-03-26 21:39:26', 0);

-- ----------------------------
-- Primary Key structure for table infra_file_config
-- ----------------------------
ALTER TABLE "public"."infra_file_config" ADD CONSTRAINT "infra_file_config_pkey" PRIMARY KEY ("id");

----创建序列
CREATE SEQUENCE infra_file_content_seq
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
CREATE TABLE "public"."infra_file_content" (
                                               "id" "pg_catalog"."numeric" NOT NULL,
                                               "config_id" "pg_catalog"."numeric",
                                               "path" varchar(512) COLLATE "pg_catalog"."default",
                                               "content" bytea,
                                               "creator" varchar(64) COLLATE "pg_catalog"."default",
                                               "create_time" timestamp(6),
                                               "updater" varchar(64) COLLATE "pg_catalog"."default",
                                               "update_time" timestamp(6),
                                               "deleted" "pg_catalog"."numeric" DEFAULT 0
)
;

-- ----------------------------
-- Primary Key structure for table infra_file_content
-- ----------------------------
ALTER TABLE "public"."infra_file_content" ADD CONSTRAINT "infra_file_content_pkey" PRIMARY KEY ("id");