DROP TABLE IF EXISTS inventory_summary;

-- 创建库存汇总表
CREATE TABLE inventory_summary
(
    id                 BIGSERIAL PRIMARY KEY,             -- 主键ID
    inventory_id       bigint         not null default 0,
    inventory_type     varchar(10)    not null default '',
    inventory_quantity DECIMAL(10, 2) not null default 0,
    input_end_record_id      bigint         not null default 0,
    output_end_record_id      bigint         not null default 0,
    deleted            INT            NOT NULL DEFAULT 0, -- 软删除标志：0=未删除，1=已删除
    create_time        TIMESTAMP WITHOUT TIME ZONE,       -- 创建时间，默认当前时间
    update_time        TIMESTAMP WITHOUT TIME ZONE        -- 最后更新时间，默认当前时间
);


-- 添加表注释
COMMENT ON TABLE inventory_summary IS '库存汇总表';

-- 添加字段注释
COMMENT ON COLUMN inventory_summary.id IS '主键ID';
COMMENT ON COLUMN inventory_summary.inventory_id IS '库id';
COMMENT ON COLUMN inventory_summary.inventory_type IS '库类型';
COMMENT ON COLUMN inventory_summary.inventory_quantity IS '库存数量';
COMMENT ON COLUMN inventory_summary.input_end_record_id IS '入库中止明细记录id';
COMMENT ON COLUMN inventory_summary.output_end_record_id IS '出库中止明细记录id';
COMMENT ON COLUMN inventory_summary.deleted IS '软删除标志，0=未删除，1=已删除';
COMMENT ON COLUMN inventory_summary.create_time IS '记录创建时间';
COMMENT ON COLUMN inventory_summary.update_time IS '记录最后更新时间';