DROP TABLE IF EXISTS storage_blob;
|
|
CREATE TABLE storage_blob
|
(
|
id bigserial PRIMARY KEY,
|
create_time timestamp default now() NOT NULL,
|
key varchar(150) DEFAULT '' NOT NULL,
|
content_type varchar(100) DEFAULT '' NOT NULL,
|
original_filename varchar(255) DEFAULT '' NOT NULL,
|
bucket_filename varchar(255) DEFAULT '' NOT NULL,
|
bucket_name varchar(255) DEFAULT '' NOT NULL,
|
byte_size bigint DEFAULT 0 NOT NULL,
|
UNIQUE (key)
|
);
|
|
COMMENT ON TABLE storage_blob IS '通用文件上传的附件信息';
|
|
COMMENT ON COLUMN storage_blob.key IS '资源id';
|
COMMENT ON COLUMN storage_blob.content_type IS '资源类型，例如JPG图片的资源类型为image/jpg';
|
COMMENT ON COLUMN storage_blob.original_filename IS '原文件名称';
|
COMMENT ON COLUMN storage_blob.bucket_filename IS '存储桶中文件名';
|
COMMENT ON COLUMN storage_blob.bucket_name IS '存储桶名';
|
COMMENT ON COLUMN storage_blob.byte_size IS '资源尺寸(字节)';
|
