DROP TABLE IF EXISTS input_inventory_record;

-- 创建入库记录表
CREATE TABLE input_inventory_record
(
    id             BIGSERIAL PRIMARY KEY,             -- 主键ID
    inventory_id   bigint         not null default 0,
    inventory_type varchar(10)    not null default '',
    quantity       DECIMAL(10, 2) not null default 0,
    deleted        INT            NOT NULL DEFAULT 0, -- 软删除标志：0=未删除，1=已删除
    create_by      VARCHAR(255),                      -- 创建人用户名
    create_time    TIMESTAMP WITHOUT TIME ZONE        -- 创建时间，默认当前时间

);
-- 创建索引
create index index_inventory_id_and_inventory_type_and_quantity_for_input_inventory_record on input_inventory_record (inventory_id, inventory_type, quantity);


-- 添加表注释
COMMENT ON TABLE input_inventory_record IS '入库记录表';

-- 添加字段注释
COMMENT ON COLUMN input_inventory_record.id IS '主键ID';
COMMENT ON COLUMN input_inventory_record.inventory_id IS '库id';
COMMENT ON COLUMN input_inventory_record.inventory_type IS '库类型';
COMMENT ON COLUMN input_inventory_record.quantity IS '记录数量';
COMMENT ON COLUMN input_inventory_record.deleted IS '软删除标志，0=未删除，1=已删除';
COMMENT ON COLUMN input_inventory_record.create_by IS '创建该记录的用户';
COMMENT ON COLUMN input_inventory_record.create_time IS '记录创建时间';
