ai_knowledge_info.sql 2.1 KB

1234567891011121314151617181920212223242526272829
  1. create table ai_knowledge_info
  2. (
  3. id bigint auto_increment
  4. primary key,
  5. tenant_id varchar(255) default '000000' not null comment '租户id',
  6. knowledge_code varchar(255) not null comment '知识库ID',
  7. knowledge_name varchar(255) not null comment '知识库名称',
  8. description varchar(255) default '' not null comment '描述',
  9. user_id bigint default 0 not null comment '用户ID',
  10. share int default 0 not null comment '是否公开知识库(0 否 1是)',
  11. knowledge_separator varchar(255) default '' not null comment '知识分隔符',
  12. question_separator varchar(255) default '' not null comment '提问分隔符',
  13. overlap_char int default 0 not null comment '重叠字符数',
  14. retrieve_limit int default 0 not null comment '知识库中检索的条数',
  15. text_block_size int default 0 not null comment '文本块大小',
  16. vector_model_name varchar(255) default '' not null comment '向量库',
  17. embedding_model_name varchar(255) default '' not null comment '向量模型',
  18. system_prompt varchar(255) default '' not null comment '系统提示词',
  19. create_dept varchar(255) default '' not null comment '部门',
  20. create_by bigint default 0 not null comment '创建人',
  21. create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
  22. update_by bigint default 0 not null comment '更新者',
  23. update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
  24. remark varchar(500) default '' not null comment '备注',
  25. constraint idx_kid
  26. unique (knowledge_code)
  27. )
  28. comment '知识库' row_format = DYNAMIC;