-- Migration: add fk_source_jt to llx_scanstation_job_tracking
-- Links a trimming (FG) confirm row back to the specific SF piece it consumed.
-- Run once after deploying the SF→FG trimming feature.

ALTER TABLE llx_scanstation_job_tracking
    ADD COLUMN fk_source_jt INT DEFAULT NULL AFTER entity,
    ADD INDEX idx_ss_jt_source (fk_source_jt);
