CREATE TABLE ProductComponents (

    id INT PRIMARY KEY AUTO_INCREMENT UNIQUE NOT NULL,

    product_id int NOT NULL,
    component_type VARCHAR(255) NOT NULL,
    unique_key VARCHAR(255) UNIQUE NOT NULL,

    printed_part_id INT NOT NULL,
    casted_part_id INT NOT NULL,
    purchased_part_id INT NOT NULL,

    quantity INT NOT NULL

); 