MySQL を使用して在庫調整を処理する倉庫管理システムのテーブル構造を設計するにはどうすればよいですか?

CREATE TABLE products (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    price DECIMAL(10, 2)
);

CREATE TABLE warehouses (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    address VARCHAR(255)
);

CREATE TABLE stock_records (
    id INT PRIMARY KEY,
    product_id INT,
    warehouse_id INT,
    quantity INT,
    updated_at TIMESTAMP,
    created_at TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id),
    FOREIGN KEY (warehouse_id) REFERENCES warehouses(id)
);

CREATE TABLE stock_adjustments (
    id INT PRIMARY KEY,
    warehouse_id INT,
    product_id INT,
    previous_quantity INT,
    adjustment_quantity INT,
    adjustment_type ENUM('increase', 'decrease'),
    reason TEXT,
    updated_at TIMESTAMP,
    created_at TIMESTAMP,
    FOREIGN KEY (warehouse_id) REFERENCES warehouses(id),
    FOREIGN KEY (product_id) REFERENCES products(id)
);

-- 更新库存记录
UPDATE stock_records
SET quantity = quantity + 100,
    updated_at = NOW()
WHERE product_id = <product_id>
  AND warehouse_id = <warehouse_id>;

-- 记录库存调整
INSERT INTO stock_adjustments (warehouse_id, product_id, previous_quantity, adjustment_quantity, adjustment_type, reason, updated_at, created_at)
VALUES (<warehouse_id>, <product_id>, <previous_quantity>, 100, 'increase', '库存调整', NOW(), NOW());