sql set primary keyprimary foreign key relationship

pre: thermal imaging
next: trigger azure data factory pipeline