CREATE TABLE CastingReports (
    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,

    user_id INT NOT NULL,

    casting_material_id INT NOT NULL,
    casting_material_amount_a DECIMAL(13, 4) default(0.0),
    casting_material_amount_b DECIMAL(13, 4) default(0.0),

    pigment_id INT NOT NULL,
    pigment_amount DECIMAL(13, 4) default(0.0),

    completed BOOLEAN default(false),
    completed_at TIMESTAMP,

    duration_seconds INT default(0),
    gross_labor_cost DECIMAL(13, 4) default(0.0),

    raw_material_cost DECIMAL(13, 4) default(0.0),
    pigment_cost DECIMAL(13, 4) default(0.0),
    total_material_cost DECIMAL(13, 4) default(0.0),

)