DROP TABLE IF EXISTS storage_blob;

CREATE TABLE storage_blob
(
    id           bigserial PRIMARY KEY,
    created_at   timestamp    default now() NOT NULL,
    key          varchar(150) DEFAULT ''    NOT NULL,
    content_type varchar(100) DEFAULT ''    NOT NULL,
    filename     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.filename IS '文件名';
COMMENT ON COLUMN storage_blob.byte_size IS '资源尺寸(字节)';