CREATE TABLE CastingReportItems (
    id INT PRIMARY KEY AUTO_INCREMENT UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT(CURRENT_TIMESTAMP),
    last_modified TIMESTAMP NOT NULL DEFAULT(CURRENT_TIMESTAMP) ON UPDATE CURRENT_TIMESTAMP,

    batch_report_id INT UNIQUE NOT NULL,
    casting_report_id INT NOT NULL,

    user_id INT NOT NULL,

    casted_part_id INT NOT NULL,
    quantity INT NOT NULL,

    casting_material_id INT NOT NULL,
    pigment_id INT NOT NULL,    

);