-- ----------------------------
-- 附件表
-- ----------------------------
drop table if exists storage_attachment;
CREATE TABLE storage_attachments
(
    id              bigserial PRIMARY KEY,
    created_at      timestamp    default now() NOT NULL,
    updated_at      timestamp    default now() NOT NULL,
    deleted_at      bigint       DEFAULT 0     NOT NULL,
    record_type     smallint     DEFAULT 0     NOT NULL,
    record_id       bigint       DEFAULT 0     NOT NULL,
    name            varchar(100) DEFAULT ''    NOT NULL,
    storage_blob_id bigint       DEFAULT 0     NOT NULL
);

COMMENT ON TABLE storage_attachments IS '通用文件上传的附件信息';

COMMENT ON COLUMN storage_attachments.record_type IS '关联的记录类型';
COMMENT ON COLUMN storage_attachments.record_id IS '关联的记录id';
COMMENT ON COLUMN storage_attachments.name IS '名称, 如: file, avatar (区分同一条记录不同类型的附件)';
COMMENT ON COLUMN storage_attachments.storage_blob_id IS '关联storage_blob记录id';

CREATE INDEX idx_storage_attachments_on_record
    ON storage_attachments (record_type, record_id);