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 '记录最后更新时间';