CREATE TABLE orders (

order_id INT AUTO_INCREMENT PRIMARY KEY,

customer_name VARCHAR(255) NOT NULL,

product_model VARCHAR(255) NOT NULL,

quantity INT NOT NULL,

delivery_date DATE NOT NULL,

status ENUM('Pending', 'In Progress', 'Completed') DEFAULT 'Pending'

);

]]>

CREATE TABLE inventory (

mold_id INT AUTO_INCREMENT PRIMARY KEY,

mold_type VARCHAR(255) NOT NULL,

current_quantity INT NOT NULL,

location VARCHAR(255)

);

]]>

CREATE TABLE tasks (

task_id INT AUTO_INCREMENT PRIMARY KEY,

order_id INT,

start_date DATE,

end_date DATE,

status ENUM('Not Started', 'In Progress', 'Completed') DEFAULT 'Not Started',

FOREIGN KEY (order_id) REFERENCES orders(order_id)

);

]]>