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