如何在MySQL中设计仓库管理系统的表结构来跟踪库存销售记录？

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

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

CREATE TABLE inventory (
    id INT PRIMARY KEY AUTO_INCREMENT,
    product_id INT,
    warehouse_id INT,
    quantity INT,
    FOREIGN KEY (product_id) REFERENCES products(id),
    FOREIGN KEY (warehouse_id) REFERENCES warehouses(id)
);

CREATE TABLE sales (
    id INT PRIMARY KEY AUTO_INCREMENT,
    product_id INT,
    quantity INT,
    sales_date DATE,
    FOREIGN KEY (product_id) REFERENCES products(id)
);

INSERT INTO products (name, description, price)
VALUES ('Apple', 'A fruit', 0.5);

INSERT INTO warehouses (name, address)
VALUES ('Warehouse A', '123 Main St, City');

INSERT INTO inventory (product_id, warehouse_id, quantity)
VALUES (1, 1, 100);

INSERT INTO sales (product_id, quantity, sales_date)
VALUES (1, 10, '2021-01-01');

SELECT p.name, w.name, i.quantity
FROM inventory i
JOIN products p ON i.product_id = p.id
JOIN warehouses w ON i.warehouse_id = w.id;

SELECT s.sales_date, s.quantity
FROM sales s
JOIN products p ON s.product_id = p.id
WHERE p.name = 'Apple';