ai_oss.sql 905 B

123456789101112131415161718
  1. -- AI 附件对象存储(本地磁盘口径,等价替换 RuoYi sys_oss;biz-buddy 附件/文档业务按 ossId 引用)
  2. drop table if exists ai_oss cascade;
  3. create table if not exists ai_oss (
  4. oss_id bigint not null,
  5. file_name varchar(500) not null,
  6. original_name varchar(500),
  7. file_suffix varchar(50),
  8. url varchar(1000),
  9. create_by bigint,
  10. create_time timestamp,
  11. constraint pk_ai_oss primary key (oss_id)
  12. );
  13. comment on table ai_oss is 'AI 附件对象存储(本地存储)';
  14. comment on column ai_oss.file_name is '存储相对路径(storage.local.root-path 下)';
  15. comment on column ai_oss.original_name is '原始文件名';
  16. comment on column ai_oss.file_suffix is '文件后缀';
  17. comment on column ai_oss.url is '公开访问 URL';
  18. comment on column ai_oss.create_by is '上传用户主键(附件注册时校验归属)';