有一个MES系统，给出一个该系统的6个数据库表的创建语句以及插入语句

好的，以下是一个MES系统可能会使用的6个数据库表的创建语句以及插入语句：

1. Order表的创建语句和插入语句：

CREATE TABLE Order (
    order_id INT PRIMARY KEY,
    product_type VARCHAR(50),
    order_quantity INT
);

INSERT INTO Order VALUES
    (1, 'Product A', 100),
    (2, 'Product B', 200),
    (3, 'Product C', 300);

2. BOM表的创建语句和插入语句：

CREATE TABLE BOM (
    bom_id INT PRIMARY KEY,
    part_number VARCHAR(50),
    quantity INT,
    usage VARCHAR(50)
);

INSERT INTO BOM VALUES
    (1, 'Part 1', 10, 'Product A'),
    (2, 'Part 2', 20, 'Product A'),
    (3, 'Part 3', 30, 'Product B'),
    (4, 'Part 4', 40, 'Product C');

3. Inventory表的创建语句和插入语句：

CREATE TABLE Inventory (
    inventory_id INT PRIMARY KEY,
    part_number VARCHAR(50),
    quantity INT,
    location VARCHAR(50)
);

INSERT INTO Inventory VALUES
    (1, 'Part 1', 100, 'Warehouse A'),
    (2, 'Part 2', 200, 'Warehouse A'),
    (3, 'Part 3', 300, 'Warehouse B'),
    (4, 'Part 4', 400, 'Warehouse C');

4. ProductionLog表的创建语句和插入语句：

CREATE TABLE ProductionLog (
    production_id INT PRIMARY KEY,
    production_date DATE,
    production_quantity INT,
    machine_number VARCHAR(50)
);

INSERT INTO ProductionLog VALUES
    (1, '2022-01-01', 50, 'Machine A'),
    (2, '2022-01-02', 100, 'Machine B'),
    (3, '2022-01-03', 150, 'Machine C');

5. QualityCheck表的创建语句和插入语句：

CREATE TABLE QualityCheck (
    check_id INT PRIMARY KEY,
    check_date DATE,
    check_result VARCHAR(50),
    check_person VARCHAR(50)
);

INSERT INTO QualityCheck VALUES
    (1, '2022-01-01', 'Pass', 'Person A'),
    (2, '2022-01-02', 'Fail', 'Person B'),
    (3, '2022-01-03', 'Pass', 'Person C');

6. Maintenance表的创建语句和插入语句：

CREATE TABLE Maintenance (
    maintenance_id INT PRIMARY KEY,
    maintenance_date DATE,
    maintenance_content VARCHAR(50),
    maintenance_person VARCHAR(50)
);

INSERT INTO Maintenance VALUES
    (1, '2022-01-01', 'Clean Machine A', 'Person A'),
    (2, '2022-01-02', 'Replace Part B', 'Person B'),
    (3, '2022-01-03', 'Calibrate Machine C', 'Person C');